January 1, 2003 at 2:08 am
Hi,
I want to schedule my full backup job to run at night and take it on
tape (my tape capacity is 20GB and my db size is about 50GB).
Everything is ok for frist tape but when it prompt me to insert the
next tape I got the following error message:
"BackupTapeFile::RequestDurable: WriteTapemark failure on backup device '\\.\Tape0'. Operating system error 1112(No media in drive.)."
and that job will be teminated. I want to know is it possible to do this without any problem or I should change my backup method?
any help will be appreciated.
SaNaZ
January 1, 2003 at 10:53 am
This should explain. http://support.microsoft.com/default.aspx?scid=KB;en-us;q244513
I suggest get a larger tape or a second tape drive to keep a mounted tape available.
January 1, 2003 at 3:18 pm
Always something to learn here. I always backup to disk so never encountered this, though it does make sense, wouldnt want your backup job to just sit there and no way to show the prompt when running as a job anyway.
You might look at SQLLiteSpeed to reduce the size of the backup.
Andy
January 2, 2003 at 10:22 am
2nd vote for disk backup. Look at Litespeed, reduced my backup file size from 40GB to 7GB with this product. My db size is 400GB, so check on the backup file size which may be smaller than the db
Steve Jones
January 7, 2003 at 4:57 am
Hi,
I have read that KB Article and scheduled following job :
BACKUP DATABASE db_name
TO TAPE = N'\\.\TAPE0',
TAPE = N'\\.\TAPE1',
TAPE = N'\\.\TAPE2',
TAPE = N'\\.\TAPE3'
WITH DIFFERENTIAL , FORMAT
GO
but I still got the following error messages:
BackupTapeFile:penMedia: Backup device '\\.\TAPE1' failed to open. Operating system error = 2(The system cannot find the file specified.).
BackupTapeFile:penMedia: Backup device '\\.\TAPE2' failed to open. Operating system error = 2(The system cannot find the file specified.).
BackupTapeFile:penMedia: Backup device '\\.\TAPE3' failed to open. Operating system error = 2(The system cannot find the file specified.).
What should I do? Is there any way to solve this problem?
SaNaZ
January 7, 2003 at 6:06 am
SaNaz,
No matter how you do it, it's looking for a second tape IMMEDIATELY. It's not going to wait for you to put one in. The only solutions, when you need to use more than one tape are 1) have an autoloader 2) have more than one tape drive.
I noticed others suggested this, but I am going to repeat it... have you tried doing your backup to the harddrive and then copying that .bak file to tape?
-SQLBill
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply