General discussion

Locked

SQL 7.0 Backups fail.

By kahlich ·
I have: Dell 2300, NT 4.0, SQL 7.0 sp 1, SEAGATE STD224000N(Reported as a Archive Python by NT) drive, SCSI setup all terminated correctly, brand new SONY DAT DDS3 tapes using the SQL Agent Scheduler to Dump as a back up. Backing up over 30 DB job runs for 5 hours. My jobs will intermintly succeed but moslty fail, like 4 nights in a row, then a good one, then a string of bad ones. Any ideas? Thanks

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL 7.0 Backups fail.

by kahlich In reply to SQL 7.0 Backups fail.

Poster rated this answer

Collapse -

SQL 7.0 Backups fail.

by Tony Hogan In reply to SQL 7.0 Backups fail.

Short term solution: To work around this problem, dump databases, transaction logs and tables to disk devices, and then use the Windows NT Server Backup utility (located in Administrative Tools group) to back up the disk devices to tape [you can also schedule this backup]. Doesn't resolve the actual SQL issue but it at least gets the data backed up.

What type of error are you getting in the error log re: the failed backup?

-tony

Collapse -

SQL 7.0 Backups fail.

by kahlich In reply to SQL 7.0 Backups fail.

Poster rated this answer

Collapse -

SQL 7.0 Backups fail.

by kahlich In reply to SQL 7.0 Backups fail.

This question was closed by the author

Back to Windows Forum
5 total posts (Page 1 of 1)  

Related Forums