Restore SQL "data" folder for testing

[CGehlhausen]

I was given a backup of a database - actually I was given the "data" folder - is that the same as a backup?. I need to know how to take that backup and load it up into SQL Server 7, so that I can write import code for this DB. I don't need the database for any other purpose than testing.

I was told to create a new database and then do the restore database and select the backup, but i dont seem to have any way to select that backup to restore. It appears you can only restore an old version of the new database that was created and not a backup of another database.

Does anyone know how to restore the backup i was given?

Thanks.

 

[LFCfan]

The "data" folder should have a ".mdf" file in it.

Without creating a new database first, you can Attach the file into a new database (right click on Databases in Enterprise Manager, All Tasks/Attach Database... and follow the steps.

This will create a new DB for you, which should be identical to the original one.

Hope this helps.