devxlogo

Database’s Recovery

Database’s Recovery

Question:
From a previous version of SQL Server 7.0 I saved only contract_Data.MDF and contract_Log.LDF.

How can I insert this file in my current SQL Server 7.0?

Answer:
Here are the magic words:

sp_attach_db @dbname @filename

After you name the database, point the stored proc to the pfiles and you’ll be fine.

devx-admin

Share the Post: