Activity overview
Latest activity by ScottO
Forgot to mention:
windows server 2008 x64
sql server 2005 x64
red-gate Version 5.4.0.55 / comments
Forgot to mention:
windows server 2008 x64
sql server 2005 x64
red-gate Version 5.4.0.55
Issue Backing up 90+ databases
I have a while loop that goes through and backups over 90+ databases to a data domain device.
Some nights it works perfect and other nights it misses some databases. No errors within SQL Logs ect.....
Here is a run down of our set up,
Cluster
DB1
DB2
The backup drives that are on each server are a raid 5 config, on a SAN shown within Cluster admin as a SQL resource.
O/S Windows 2003 Server sp2 32bit1
16GB of ram
SQL Server Enterprise Edition 32 bit SQL is on SP2 / comments
Here is a run down of our set up,
Cluster
DB1
DB2
The backup drives that are on each server are a raid 5 config, on a SAN shown within Cluster admin as a SQL resource.
O/S Windows 2003 Server sp2 3...
petey wrote:
What is the error that you are experiencing?
Is this link (http://support.microsoft.com/kb/934396) applicable to you?
here is one of the errors trying to restore:
BackupIoRequest::WaitForIoCompletion: read failure on backup device 'SQLBACKUP_F3B72B14-9EF6-4C08-81AD-935ECDA81F37'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.) / comments
petey wrote:
What is the error that you are experiencing?
Is this link (http://support.microsoft.com/kb/934396) applicable to you?
here is one of the errors trying to restore:
BackupIoRequest::...
Problems Backing up a 2TB+ Database
Ok, I've been on the phone a few times with support, still looking for answers.
We had red-gate sqlback up 5.2, we were able to backup a 1.8 TB DB with no problem but over the past couple months we...