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 |
|
jorolas
Starting Member
4 Posts |
 Posted - 2008-12-16 : 05:35:40
|
| I everybody, I am trying to create a new backup device, with a tape as the destination. I already have a prepared tape, which is already available for other applications (ex: windows backup utility), and is working fine. Problem is that I can not add tape as the destination for a new backup device which I am trying to create from management studio Server Objects. I am using SQL 2005. Thanks in advance, Jorge |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-12-16 : 08:42:09
|
| Personally I wouldn't back up straight to tape anyway, I would back up to disk and then to tape, but I would say that your problem is either permissions over the network to see the tape or drivers to allow SQL to see the tape.Are you getting an error at all or is it just not seeing the tape? |
 |
|
|
jorolas
Starting Member
4 Posts |
Posted - 2008-12-16 : 10:00:13
|
| Hi, Just not seeing the tape. No errors, nothing at all. Tape is not available from SQL. So you do not recommend backing up directly to tape, do you?Thanks a lot Jorge |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-16 : 10:03:52
|
| No.It will take time while restoring from tape. You should have recent backups in disk and dump files older than1 week(depending on Business principals)to tape. |
|
|
|
|
|
|
Problems adding tape as new backup device