Restore SQL 2000 database
Posted on 2013-06-16
I have a SQL 2000 server running one database. This database is for historical data only so there are no changes made since the last backup. The database was showing suspect.
I couldn't fix that so I thought I had a brilliant idea.
I stopped SQL and renamed the MDF an LDF files. I thought I would be able to restore the backup but in 2000, it looks like you have to have an existing database to restore to.
Now I can't re-attach the suspect database, it says the file you've specified is not a valid SQL server database file.
How can I restore a backup to SQL 2000 when the database is no longer attached?