Activity overview
Latest activity by schoogie
We are using MS Cluster service but only the active node is in the cluster. The passive node is not defined at this time. The plan is when we decommission the old production server we will add it as a passive node to this cluster. / comments
We are using MS Cluster service but only the active node is in the cluster. The passive node is not defined at this time. The plan is when we decommission the old production server we will add it a...
Problems with cluster install of 5.2 backup
I have a cluster of one server (eventually will be more) and I’m having problems installing Red-Gate Backup 5.2. I have the front end installed but the install through the GUI fails saying master...
Deactivation of SQL Backup
I will be moving the database to a new server and want to recover the licenses used on the old server. I currently have a licence for 10 server copies of SQL Backup. If I deactivate on this server ...
Error on backup
Started receiving this error with last night's backup. Any ideas on where the problem may be. The DB seems to be fine.
12/10/2007 12:00:11 AM: Backing up BizTalkMsgBoxDb (full database) to:
12/10/2...
Here is the log of the error message generated during the problem. The backup that produced this file to restore was complete almost half an hour before the restore started. Rerunning the job in the morning when I came in the office and it worked fine. Any idea why this error is occuring? I'm assuming since I can restore the exact same file later in the day it's not a problem with the backup file.
SQL Backup log file
10/24/2007 12:40:02 AM: Restoring DevDB (database) from:
10/24/2007 12:40:02 AM: \\productiondb\Backup\PRODUCTIONPROD\FULL_(local)_PRODUCTIONPROD_20071024.sqb
10/24/2007 12:40:02 AM: RESTORE DATABASE [DevDB] FROM DISK = '\\productiondb\Backup\PRODUCTIONPROD\FULL_(local)_PRODUCTIONPROD_20071024.sqb' WITH RECOVERY, MOVE 'DCRef_Data' TO 'F:\Microsoft SQL Server\MSSQL\Data\DEVDB_Data.MDF', MOVE 'DCRef_Log' TO 'L:\Microsoft SQL Server\MSSQL\LOG\DEVDB_log.LDF', REPLACE
10/24/2007 12:52:43 AM: Thread 0 error:
File read error for 152135 bytes (balance 15694 bytes). Backup file is incomplete or corrupted.
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3241: SQL error 3241: The media family on device 'SQLBACKUP_AF9725EF-D653-4ED6-8683-C5BCABF016E4' is incorrectly formed. SQL Server cannot process this media family. / comments
Here is the log of the error message generated during the problem. The backup that produced this file to restore was complete almost half an hour before the restore started. Rerunning the job in th...
Problems with Restore
I have a database that is backed up each night at 12am. After the backup (on server 1), the backup is restored to a test server (server 2). Sometimes it fails and I’m not sure as to why. Rerunnin...