Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-16 : 06:56:18
|
| Oscar writes "My user erased my mdf and ldf files from the pc y used as a MSSQL 7 server, of course he didn't told me about it except that he no longer can access his data. I discovered what he had done and recovered with unerased both files. The problem now is that when i try to attach this files it generates an error, i also tryed with attach a single file and again an error. The messages are : that the files aren't valid database files. How i can use this files in order to restablish this database? thanks in advance." |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-11-16 : 08:34:53
|
| Just restore the database from the database backups that you made.CODO ERGO SUM |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-16 : 15:48:28
|
| Use DBCC CHECKDB command after reattach, or restore, to check that the "recovered database" is in good shapeKristen |
|
|
|
|
|
|
i want to reuse a mdf file that my user erased!!