Home > Articles > Data > SQL Server

  • Print
  • + Share This

Miscellaneous Tape Considerations

If you choose to back up to tapes, you should be aware of the following:

  • SQL Server writes to tape using American National Standards Institute (ANSI) tape headers. This means that SQL Server can share tapes with Windows NT or Windows 2000 backups.

  • SQL Server uses the console program to notify an operator when a tape needs to be changed (if the program is running).

  • As you might expect, you can store more than one backup on a single tape.

  • If you plan to take advantage of a particular tape drive's special features, such as hardware compression, make sure that the same model will be available when you need to recover using the tape. This is particularly true if you plan to keep the tapes around for a long time. Are you sure that you'll still have that brand of tape drive available in five years?

  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.