question

Chris 3 avatar image
Chris 3 asked

Error on SQL 2005 tape restore after upgrading to 4GB RAM

We recently updgraded a standby sql 2005 server from 2GB to 4GB. (The production sql 2005 server has 2GB RAM) Then we started getting the following error after a tape restore:

BackupTapeFile::ChooseCurrentBlockSizes: SetTapeParameters (SET_TAPE_MEDIA_INFORMATION) failure on backup device '\\.\Tape0'. Operating system error 87(error not found).

It seems we could do tape backups and restores on the standby server but not a restore from the production server.

We have since reverted back to 2GB and it works ok again.

Has anyone else seen this error? Do we need to specify the blocksize in the backup and restore?

Thanks, Chris

sql-server-2005backup
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
sp_lock avatar image
sp_lock answered

Are you using a 3rd party to backup the DB?

If you are using SQL Server can you send the t-sql you are using? If you are using SSMS to restore have you tried t-sql?

Rgds

JL

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Chris 3 avatar image Chris 3 ·
Here is the sql syntax we are using, we backup 2 databases to tape and then restore them, here is the syntax for one: BACKUP DATABASE [mydatabase] TO [externalDAT] WITH NOINIT , NOUNLOAD , NAME = N'tape backup', SKIP , STATS = 10, NOFORMAT, CHECKSUM, CONTINUE_AFTER_ERROR restore database mydatabase from externalDAT with file = 2, nounload, stats = 10, replace, CHECKSUM, STOP_ON_ERROR, standby = 'd:\mssql\backup\standby.ldf' Thanks, Chris
0 Likes 0 ·
David Wimbush avatar image
David Wimbush answered

DOS error 87 is Invalid Parameter. You might want to Google that. It's sometimes connected with LPT (printer) ports, so that suggests it's something to do with devices.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.