topic Re: Sql Server 7 in Operating System - Microsoft

Sql Server 7

Ron Bromwell — Mon, 13 Aug 2001 19:34:27 GMT

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

Re: Sql Server 7

Kurt Matthies — Mon, 13 Aug 2001 21:51:06 GMT

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.

Re: Sql Server 7

Kurt Matthies — Mon, 13 Aug 2001 21:51:41 GMT

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.