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 |
|
Kleber
Yak Posting Veteran
67 Posts |
 Posted - 2004-01-30 : 14:59:23
|
| Hi AllI have a database presenting a problem when i try to do a full backup.Statment:backup database dtbXMO to tape = N'\\.\tape0'WITH FORMAT, MEDIANAME = 'BKBF01feb', NAME = N'dtbXMO Backup', DESCRIPTION = N'Salva completa do banco dtbXMO'Return error on query analyzer:Server: Msg 3229, Level 16, State 2, Line 1Request for device '\\.\tape0' timed out.Server: Msg 3013, Level 16, State 1, Line 1Backup or restore operation terminating abnormally.The database has 28Gb and the backup must be done at a DAT (DDS2)TapeO.S - Windows NT4.0 Sp6aSQL 7.0 I have ohters databases with more than 20Gb and backup works fine. I found an article on Microsoft (KB244513) That show this error, gives me an workaround, but it does not work.Any help will be appreciated.Kleber Brazil |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-01-30 : 15:11:04
|
| This may not be much help, but I wonder if a backup of this DB to disk (not tape) would run with or without error? |
 |
|
|
Kleber
Yak Posting Veteran
67 Posts |
Posted - 2004-01-30 : 15:24:38
|
| To disk it works fine. But I don't have available space to do it usually.KleberBrazil |
|
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2004-01-30 : 16:09:18
|
| Its reccommended that backups are done to disk and then dumped to tapes or some other backup media. Is there a network volume you could store it on? or could you try shrinking the database before your back it up. HTH- Eric |
|
|
|
Kleber
Yak Posting Veteran
67 Posts |
Posted - 2004-01-30 : 16:29:34
|
| Ok. SQL Server should ask for new tapes, if necessary, right? And it isn't happening! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-30 : 17:03:57
|
| Is the tape device attached to the SQL Server? SQL Server can not backup to a remote tape device.What do you mean SQL Server should ask for new tapes?Tara |
|
|
|
Kleber
Yak Posting Veteran
67 Posts |
Posted - 2004-02-02 : 08:08:40
|
| Yes, the tape device is attached to the SQL Server. And I mean that when a Tape Media is full, the SQL Server should ask for a new empty media to continue the backup, shoudn't it? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-03 : 12:14:51
|
| It doesn't mention that anywhere in SQL Server Books Online. So I'd say no.Tara |
|
|
|
|
|
|
|
|
Backup Error