Discussion Locked

Tape backup of Sequel 2000

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is it better to run your tape backup at night after your sequel daily and backup jobs have run? Is the database better optimized then? We have no nightly transactions happening.

2 replies

by vinnyd

If your SQL Daily backup procedure exports the Data out to a file (most of my customers do it this way), then the tape backup needs to run after the SQL Daily backup has finished!

by srippey

The Daily job that runs tunes the database, and the backup job that runs creates a .bak file (although i'm sure it truncates logs and re-sizes a certain amount of data).

It just seems like a good idea to run the tape backup after both of these are done...

This discussion is closed to new replies.