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

having trouble backing up sophos database

Hi

I trying to back the sophos database before I update to enterprise console 5.2  but i get this error

C:\Program Files\Sophos\Enterprise Console\DB\Core>sqlcmd -E -S "[ucrxsql01\mssq
lserver]" -b -Q "BACKUP DATABASE [sophos51] TO DISK = 'C:\temp\sophos_DB_backup\
sophos51.bak'"
HResult 0xFFFFFFFF, Level 16, State 1
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFF
FF].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in
stance-specific error has occurred while establishing a connection to SQL Server
. Server is not found or not accessible. Check if instance name is correct and i
f SQL Server is configured to allow remote connections. For more information see
 SQL Server Books Online..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

Failed

i am using command backupdb C:\temp\sophos_DB_backup ucrxsql01\mssqlserver sophos51

any help would be apppracted

My sophos database is on another server  using  sqlserver 2008 r2 on server 2008 r2

:37649


This thread was automatically locked due to age.
Parents
  • Hi Christian,

    Thank you for your response. Unfortunately, I cannot recover the account which has access to the database and installed during the initial setup. What worries me now is the current policies that will not be migrated when I upgraded to 5.1. 

    It's hard to say that we will be using the older version 4.5 until any possible solution will come. 

    :46227
Reply
  • Hi Christian,

    Thank you for your response. Unfortunately, I cannot recover the account which has access to the database and installed during the initial setup. What worries me now is the current policies that will not be migrated when I upgraded to 5.1. 

    It's hard to say that we will be using the older version 4.5 until any possible solution will come. 

    :46227
Children
No Data