Tuesday, March 20, 2012

Restore Database

Hello, him story my problem, we had a problem with the server where was installed the sqlserver2005, we do not have backups, nevertheless we could recover the files data.mdf and log.ldf of the database, like I can carry out a restore utilizing these files?

No, you do NOT need to RESTORE with those two files.

You need to ATTACH the files. Check in Books Online about using ATTACH.

No comments:

Post a Comment