This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DataBackupRestore failed

Hi,

I've searched a few querires like this on here but couldn't find the solution.

I'm migrating to a new server (from Windows 2008 to Windows 2012)

I have installed the new console and taken backup of the old 2008 server. I've gotten to point 10 on the Sophos Enterprise Console Server to server migration guide. (http://www.sophos.com/en-us/medialibrary/PDFs/documentation/sec_52_mgeng.pdf )DatabackupRestore backup is failing on the new server with the below message:

C:\Program Files (x86)\Sophos\Enterprise Console>DataBackupRestore.exe -Action=b
ackup
Microsoft (R) Build Engine version 4.0.30319.33440
[Microsoft .NET Framework, version 4.0.30319.34014]
Copyright (C) Microsoft Corporation. All rights reserved.

Build started 16/04/2015 18:18:37.

C:\Program Files (x86)\Sophos\Enterprise Console>sqlcmd -E -S "(local)\SOPHOS" -
b -Q "BACKUP DATABASE SOPHOSENC52 TO DISK = 'C:\ProgramData\Sophos\TempData\SOPH
OSENC52.bak'"
Processed 240 pages for database 'SOPHOSENC52', file 'SOPHOSENC52' on file 1.
Processed 2 pages for database 'SOPHOSENC52', file 'SOPHOSENC52_log' on file 1.
BACKUP DATABASE successfully processed 242 pages in 0.100 seconds (18.867 MB/sec
).
Succeeded
Copy file C:\ProgramData\Sophos\TempData\SOPHOSENC52.bak successful.

C:\Program Files (x86)\Sophos\Enterprise Console>sqlcmd -E -S "(local)\SOPHOS" -
b -Q "BACKUP DATABASE SOPHOSPATCH52 TO DISK = 'C:\ProgramData\Sophos\TempData\SO
PHOSPATCH52.bak'"
Processed 47888 pages for database 'SOPHOSPATCH52', file 'SOPHOSPATCH52' on file
1.
Processed 2 pages for database 'SOPHOSPATCH52', file 'SOPHOSPATCH52_log' on file
1.
BACKUP DATABASE successfully processed 47890 pages in 5.239 seconds (71.413 MB/s
ec).
Succeeded
Copy file C:\ProgramData\Sophos\TempData\SOPHOSPATCH52.bak successful.
The requested operation requires elevation

Build FAILED.

Time Elapsed 00:00:07.02
Process 'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\msbuild.exe "C:\Program
Files (x86)\Sophos\Enterprise Console"\BackupRestore.proj /t:backup /clp:NoSumm
ary /p:SubSystem=all;DataSourceType=all;ExcludeDB=False;LocationSpecific=False;S
lientMode=False;DBServerInstance=' returned Error 1

C:\Program Files (x86)\Sophos\Enterprise Console>

Thanks,

Brian

This thread was automatically locked due to age.

Parents

0 QC over 9 years ago

Hello Brian,

when I run it it looks like this:

Processed 4 pages for database 'SOPHOSPATCH52', file 'SOPHOSPATCH52_log' on file 1.
BACKUP DATABASE successfully processed 52196 pages in 13.409 seconds (30.410 MB/sec).
Succeeded
Copy file C:\ProgramData\Sophos\TempData\SOPHOSPATCH52.bak successful.
Warning: Cannot find registry key HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\Patch
The requested operation requires elevation

Build FAILED.

Note the (originally) yellow line. The key does exist for sure so this can only be a permissions error and the next (red) line confirms this and actually tells you what's needed: Some of the operations only succeed when you run it from an elevated CMD prompt.

Christian

Reply

0 QC over 9 years ago

Hello Brian,

when I run it it looks like this:

Processed 4 pages for database 'SOPHOSPATCH52', file 'SOPHOSPATCH52_log' on file 1.
BACKUP DATABASE successfully processed 52196 pages in 13.409 seconds (30.410 MB/sec).
Succeeded
Copy file C:\ProgramData\Sophos\TempData\SOPHOSPATCH52.bak successful.
Warning: Cannot find registry key HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\Patch
The requested operation requires elevation

Build FAILED.

Christian

Children

No Data