Sql Server 7

[Ron Bromwell]

We had a problem with a virus. Had to reinstall our sql server database. I have the old mdf file and a backup done from enterprise manager. How can I get sql server to recognize the old database file?

the OS is NT 4.0

Thanks,
Ron

[Kurt Matthies · Accepted solution]

Yes, you have to restore both data and log files for a database using the sp_attachdb command in Query Analyser.

If your database name is myDB, and the files are myDB_data.mdf and myDB_log.ldf

then the command would be:

sp_attach_db @dbname=N'myDB',@filename1=N'C:\mssql7\Data\myDB_data.mdf',@filename2=N'C:\mssql7\Data\myDB_log.ldf'

assuming that SQL is in the C:\mssql7 directory on your server.

[Kurt Matthies]

Yes, you have to restore both data and log files for a database using the sp_attach_db command in Query Analyser.

If your database name is myDB, and the files are myDB_data.mdf and myDB_log.ldf

then the command would be:

sp_attach_db @dbname=N'myDB',@filename1=N'C:\mssql7\Data\myDB_data.mdf',@filename2=N'C:\mssql7\Data\myDB_log.ldf'

assuming that SQL is in the C:\mssql7 directory on your server.