Yearly Archives: 2013
Enable MS-SQL server to listen on IP addresses
Open SQL server configuration manager Click into “Protocols for <SQL_INSTANCE>” Right-click TCP/IP and choose Properties (ensure it’s set to enabled) Click into the “IP Addresses” tab There will be a section for each IP address that the machine has – … Continue reading
How to enable TCP/IP on MS-SQL server
Open the “SQL Configuration Manager” Expand “SQL Server Network Configuration” Click into “Protocols for <SQL_INSTANCE>” Right-click “TCP/IP” and choose “Properties” Choose “Enabled” Click OK Restart the SQL server instance – this can be done from the “SQL server services” item … Continue reading
How to add a dedicated SQL backup service account
Open SQL management studio Connect to the session as an appropriate admin user (this can be done using either Windows or SQL authentication) to the SQL instance Expand Security->Logins Right-click Logins and choose “new Login” Add the backup service account … Continue reading
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE permission denied in database ‘XXXX’.
Error [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE permission denied in database ‘XXXX’. Cause The user connecting does not have appropriate SQL permissions to access the database (scheduled backups use SQL authentication NOT Windows authentication). TCP/IP is not enabled on the … Continue reading
No database file found for ‘Microsoft SQL Server\SERVER\INSTANCE\Database’
Error No database file found for ‘Microsoft SQL Server\SERVER\INSTANCE\Database’ Cause This means that the database was attempted to be backed up but the backup file does not exist. It can be caused by the spooling location holding previous SQL backup … Continue reading
SQL Server Driver][SQL Server]Cannot open backup device XXXX Operating system error 3(error not found)
Error [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device ‘XXXX’. Operating system error 3(error not found) Cause This is likely due to corrupted/incorrect data within the spooling location. Resolution Ensure CyberSecure Advanced is on the latest version. Clear the spooling … Continue reading
CExBackup::backupService:HrESEBackupSetup: Error Number 0xc80001f9: Backup is already active.
Error CExBackup::backupService:HrESEBackupSetup: Error Number 0xc80001f9: Backup is already active. Cause The exchange server is busy in the process of being backed up. Resolution Check that other backup software is not scheduled to backup exchange on a conflicting time to CyberSecure. … Continue reading
How to recover/migrate the locally cached config
This procedure would be performed if the encryption key needs to be retrieved from a previous computer or working installation. Open the “home.txt” file, which is located under the CyberSecure program files folder (eg: C:\Program Files\CyberSecure Advanced for advanced edition … Continue reading
How to change the backup schedule
Open CyberSecure Standard edition One the main console loads, click on the backup schedule settings icon Alter the backup schedule as desired Choose OK to go back to the main console Save settings to the offsite servers
No *.chk found for database ‘XXXX’
Error No *.chk found for database ‘Microsoft Exchange Server\Microsoft Information Store\XXXX\Mailbox Database’ Cause This error suggests that the checksum file was not correctly uploaded during the most recent backup. Resolution Run another Exchange database backup, which should resolve the issue.