Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sherrys
Starting Member
37 Posts |
 Posted - 2003-09-30 : 09:54:18
|
| We run SQL 2000 on Datacenter 2000. We have a 2-node cluster in active-passive mode. We are hooked up to our SAN through 1GB fiber channel. We are running 3 instances of SQL..We use backup devices formatted as <database>_A and <database>_B (Logs are <database>_A_LOGS, differentials are <database>_A_DIFF, with appropriate B sets), as such:select @command = 'backup database ' + @db + ' to ' + @db + '_' + @dayweek + ' with init'The devices point to a file share on the SAN that is backed up to tape every night.Here is the problem: without rhyme or reason our backup files seem to get corrupted. They pass the ‘restore verify only’ step of the job, but the next cycle we cannot over write the file and receive the following error:The backup data in 'wslogdb50_B' is incorrectly formatted This problem randomly happens on all three instances, in various databases.Is this a known problem? Any advice would be appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-30 : 12:46:30
|
| It is not necessary to post your question/problem in multiple forums:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=29516[/url]Tara |
 |
|
|
|
|
|
corrupt backup