Hi,
I want to migrate enterprise console. Old server is using Win Server 2003 Standard SP2 x86, and migrate to win server 2008 Enterprise R2 x64. Just following Server to Server Migrate Guide. For the first, I was backing up database using DataBackupRestore.exe. I got warning, this a log:
C:\Program Files\Sophos\Enterprise Console>sqlcmd -E -S "(local)\SOPHOS" -b -Q "
BACKUP DATABASE SOPHOSENC52 TO DISK = 'C:\Documents and Settings\All Users\Appli
cation Data\Sophos\TempData\SOPHOSENC52.bak'"
Msg 945, Level 14, State 2, Server CSIJKTAV01\SOPHOS, Line 1
Database 'SOPHOSENC52' cannot be opened due to inaccessible files or insufficien
t memory or disk space. See the SQL Server errorlog for details.
Msg 3013, Level 16, State 1, Server CSIJKTAV01\SOPHOS, Line 1
BACKUP DATABASE is terminating abnormally.
Failed
Warning: Cannot find file C:\Documents and Settings\All Users\Application Data\S
ophos\TempData\SOPHOSENC52.bak
C:\Program Files\Sophos\Enterprise Console>sqlcmd -E -S "(local)\SOPHOS" -b -Q "
BACKUP DATABASE SOPHOSPATCH52 TO DISK = 'C:\Documents and Settings\All Users\App
lication Data\Sophos\TempData\SOPHOSPATCH52.bak'"
Processed 58680 pages for database 'SOPHOSPATCH52', file 'SOPHOSPATCH52' on file
1.
Processed 1 pages for database 'SOPHOSPATCH52', file 'SOPHOSPATCH52_log' on file
1.
BACKUP DATABASE successfully processed 58681 pages in 56.807 seconds (8.070 MB/s
ec).
Succeeded
Copy file C:\Documents and Settings\All Users\Application Data\Sophos\TempData\S
OPHOSPATCH52.bak successful.
Backup successfully for registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\Patch
Backup successfully for registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\Patc
h
C:\Program Files\Sophos\Enterprise Console>sqlcmd -E -S "(local)\SOPHOS" -b -Q "
BACKUP DATABASE SOPHOS521 TO DISK = 'C:\Documents and Settings\All Users\Applica
tion Data\Sophos\TempData\SOPHOS521.bak'"
Processed 13656 pages for database 'SOPHOS521', file 'SOPHOS521' on file 1.
Processed 6 pages for database 'SOPHOS521', file 'SOPHOS521_log' on file 1.
BACKUP DATABASE successfully processed 13662 pages in 13.804 seconds (7.731 MB/s
ec).
Succeeded
Copy file C:\Documents and Settings\All Users\Application Data\Sophos\TempData\S
OPHOS521.bak successful.
Backup successfully for registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\Certifi
cation Manager
Backup successfully for registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\Mana
gement Tools
Backup successfully for registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\Managem
entServer
Backup successfully for registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\Soph
os Enterprise Console
Successful operations on secure store.
C:\Program Files\Sophos\Enterprise Console>sqlcmd -E -S "(local)\SOPHOS" -b -Q "
BACKUP DATABASE SophosSecurity TO DISK = 'C:\Documents and Settings\All Users\Ap
plication Data\Sophos\TempData\SophosSecurity.bak'"
Processed 488 pages for database 'SophosSecurity', file 'SophosSecurity' on file
1.
Processed 2 pages for database 'SophosSecurity', file 'SophosSecurity_log' on fi
le 1.
BACKUP DATABASE successfully processed 490 pages in 0.613 seconds (6.242 MB/sec)
.
Succeeded
Copy file C:\Documents and Settings\All Users\Application Data\Sophos\TempData\S
ophosSecurity.bak successful.
Build succeeded.
Thank you,
This thread was automatically locked due to age.