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 |
|
oreckvhon
Starting Member
2 Posts |
 Posted - 2007-12-19 : 20:06:45
|
hi there! can anybody help me do this, i can't make make a tape back-up in SQL Server 2000, the tape destination is not visible to select, i can only back it up through drive D:. What suppost to be the problem?! thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-19 : 20:32:47
|
| Never backup your database directly to tape. Always back it up to disk, then copy that backup file to tape.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
oreckvhon
Starting Member
2 Posts |
Posted - 2007-12-21 : 19:34:53
|
| hi! may i know why you don't want me to backup my datas directly to the tape drive? i'm just a bit curious, thanks alot! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-21 : 20:14:07
|
| You need attach tape drive to sql server directly. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-21 : 22:46:22
|
quote:
Originally posted by oreckvhon
hi! may i know why you don't want me to backup my datas directly to the tape drive? i'm just a bit curious, thanks alot!
Because when you need to restore the database, you typically just need yesterday's or a recent backup. It's much easier and faster if that file was on disk rather than on tape. You should only have to go to tape if the backup needed is old.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
can't make a tape back up in SQL server 2000