Interested to Buy Any Domain ? << Click Here >> for more details...
Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?
- 3 Answers
- 6647 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
What are dml (data manipulation language) statements in ms sql server?
Difference between group by clause and having clause in SQL?
Explain the types of indexes.
What is the significance of null value and why should we avoid permitting null values?
What is difference between temp table and cte?
What are the types of indexing?
What is bcp? When does it used?
Find columns used in stored procedure?
What is 2nf normalization form?
How do database indexes work?
Explain what are page splits? : SQL Server Architecture
What is a raid and what are different types of raid configurations?
Why use cursor in sql server?
What is "scheduled jobs" or "scheduled tasks"?
What is the difference between grant and with grant while giving permissions to the user?
