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:
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?
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?
answered Mar 30, 2010 at 09:42 PM
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.
answered May 26, 2010 at 07:16 AM