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
  • Hello Romardy,

    BackupDB.bat - if this is what you are using - accesses the database with the credentials of the logged on user. In order to upgrade you must be logged on as an administrator and usually this account should be able to access the database on the SQL server to perform the backup.

    Could you please post all the output of BackupDB (or whatever command you are using)?

    Christian

    :46075
Reply
  • Hello Romardy,

    BackupDB.bat - if this is what you are using - accesses the database with the credentials of the logged on user. In order to upgrade you must be logged on as an administrator and usually this account should be able to access the database on the SQL server to perform the backup.

    Could you please post all the output of BackupDB (or whatever command you are using)?

    Christian

    :46075
Children
No Data