Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?
- 3 Answers
- 5963 Views
- Apple, I also Faced
- E-Mail Answers
Answer Posted / morenobelm3
Their original SQL Server was 2008, with SP unknown, but installed on D: and C: drives. The power spike corrupted their O/S on the C: drive and someone reinstalled both the O/S and the SQL Server, which is now SQL 2008, SP4. They have intact files for all system databases, both .mdb and .ldf. Is there some way they can reconnect with the user databases using the intact copies of the previous system databases?
I have heard that if the SQL Server is stopped, previous Master and Msdb .mdb and .ldf files moved into place and the server restarted, that any previous user database .mdb and .ldf files can be accessed by the SQL server.
Is this the case, or are there details missing?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Give me any three differences between Truncate and Delete.
Explain transaction server explicit transaction?
What is read uncmmited?
How do I view a stored procedure in sql server query?
how many bits ip address consist of? : Sql server database administration
please differentiate between delete and truncate?
Tell me what is difference between view and materialized view?
What is ddl and dml commands?
Why use “pivot” in sql server?
Define compound operators?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Can one drop a column from a table?
Do you know what is a with(nolock)?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the difference between left and right outer join?
