x

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

more ▼

asked Mar 30 '10 at 08:41 PM in Default

Chris 3 gravatar image

Chris 3
11 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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

more ▼

answered Mar 30 '10 at 09:42 PM

sp_lock gravatar image

sp_lock
9k 24 27 30

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
Apr 05 '10 at 06:03 PM Chris 3
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered May 26 '10 at 07:16 AM

David Wimbush gravatar image

David Wimbush
4.7k 28 29 31

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1933
x186

asked: Mar 30 '10 at 08:41 PM

Seen: 1092 times

Last Updated: Mar 31 '10 at 04:00 AM