August 29, 2007 at 2:21 am
Hi,
I schedule a backup job for one of my database every night. The database fails whenever a cluster failover of the server takes place.
This is the error in the History Details:
10 percent processed. [SQLSTATE 01000] (Message 3211) 20 percent processed. [SQLSTATE 01000] (Message 3211) 30 percent processed. [SQLSTATE 01000] (Message 3211) 40 percent processed. [SQLSTATE 01000] (Message 3211) 50 percent processed. [SQLSTATE 01000] (Message 3211) 60 percent processed. [SQLSTATE 01000] (Message 3211) 70 percent processed. [SQLSTATE 01000] (Message 3211) 80 percent processed. [SQLSTATE 01000] (Message 3211) A nonrecoverable I/O error occurred on file "I:\MSSQL\MSSQL.1\MSSQL\DATA\DB.mdf:" 170(The requested resource is in use.). [SQLSTATE 42000] (Error 3271) Write on "J:\MSSQL\Backups\CIRIS_backup_Daily.bak" failed: 170(The requested resource is in use.) [SQLSTATE 42000] (Error 3202) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Is there perhaps a workaround for this. I am getting real tired of changing the schedules.
Regards
IC
August 29, 2007 at 3:41 am
Imke
If your SQL Server cluster resource fails over in the middle of the backup, then the backup is bound to fail, since the resource will go offline momentarily. Why is the failover occurring so regularly?
John
August 29, 2007 at 3:52 am
I don't know, i was told by the sysadmin it happens at any time automatically.
August 29, 2007 at 8:31 am
It shouldn't do. If it fails over it's because there's a problem with one of the cluster resources... you should ask the sysadmin to investigate this.
John
August 30, 2007 at 9:50 am
Look into the System and Application event logs then the cluster.log file immediately after a failover. The take this information to the sysadmin. If he does nothing then take it toi a supervisor. This is inexcusable.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply