January 5, 2009 at 3:16 am
Hi All,
We are having a strange backup issue in one of our Servers. Backup successfully runs randomly and fails most of the times. Windows Event logs are of no use. After upgrading the support pack to SP2 (both windows and sql server 2005) the issue remains the same.
Environment:
Windows 2003 R1 SP2
MS SQL Server SP2
As the database size is around 1.4 TB we backup the database on to the tape directly. The backup progresses successfully for 3 to 4 hours and fails.
On machine 2 ( it also hosts SQL Server 2005 SP1) the backup happens without any issue.
As Machine 1 is critical, we are thinking of the following solution
Add Machine 1 Database to Machine 2 SQL Management Studio and use the tape drive on Machine 2 and fire the backup.
Would be of great help if you can let us know if this works ? If yes any special configuration required.
Thanks and Regards
Madhav
January 7, 2009 at 12:19 pm
Madhav,
If the tape drive is shared you should be able to write the backup to the other Server's device providing the account running the SQL Agent has rights to that device.
A different suggestion would be to backup the Database to disk and then copy that backup to tape, assuming that you have adequate space to do. In my mind this does a couple things a) It helps with redundancy, even if it is for a very short term b) recovering from disk is faster than from tape (although the difference may be negligible with 1.4 TB Database)
You might even try backing up the Database to disk as a troubleshooting step. Maybe there is some other activity occurring on the Server during the backup that is causing the issue.
Food for thought!
Regards, Irish
January 7, 2009 at 6:37 pm
Jeffery
Thanks so much.. It was like sailing alone against the currents all these days. Disk backup i found a space of 1 TB on a remote location and i am trying to fire the disk backup and then move it to tape. But it is terminating with access denied issue though the rights are given for everyone. I am trying to troubleshoot it and will keep u posted..
Cheers
Madhav
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply