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