Hi,
Two of my hard drives went down yesterday. and with it went the Sql server database.The data recovery guys recovered the back up database (.bak) file.I have since reinstalled SQL Server 2000 and now when i try and restore the .bak file it says the Microsoft tape back up file set is not valid when i try and open the .bak file.
Whats the right way to add my databse to the SQl Server2000 using my .bak file and if anyone has come across the error they could help.
Thanks
LDid you apply all SPs that your old server used to have?|||what do u mean by sps|||what do u mean by sps
Stored Procedure|||It's "Service Packs", not stored procedures...how do you apply a stored procedure anyway?|||Restore the databases...which she can't do. DOH!!! :)
You should always verify your backups, especially if writing directly to tape. Any luck though after applying the service packs? Don't you guys have a DBA who can help with this?|||It's "Service Packs", not stored procedures...how do you apply a stored procedure anyway?
Yes. It should be Service Packs|||Hi Lohit,
hows was your process of restoring the backup?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment