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,

    I'm new to Sophos and need to backup the database but getting error BACKUP DATABASE permission denied in database. Investigating that this was due to account use during the setup of SEC already left the company. I'm upgrading SEC 4.5 to 5.1 but having issue with account permission.

    Is there a possible way I can upgrade SEC?

    Thanks in advance

    :46071
Reply
  • Hi,

    I'm new to Sophos and need to backup the database but getting error BACKUP DATABASE permission denied in database. Investigating that this was due to account use during the setup of SEC already left the company. I'm upgrading SEC 4.5 to 5.1 but having issue with account permission.

    Is there a possible way I can upgrade SEC?

    Thanks in advance

    :46071
Children
No Data