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 |
|
bserrato
Starting Member
1 Post |
 Posted - 2011-04-28 : 22:16:04
|
| Hello, my problem is roughly the same as "Need to Restore from .mdf and .ldf" at http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119505 I restored from three .mdf and .ldf by simply reinstalling the application which required sql server, taking SQL server down, then replacing the .mdf and .ldf files (same names and location in directory as before), and replacing the one directory which held data used by the application but indexed, err indicated, This worked fine...Am I at risk of corruption or can I go on to treat this new install the same as before the crash?Background: The laptop runs an application which runs on SQL 2005 Express. The laptop received a virus which messed up the boot sector so after I asked the user to restart in safe mode it wouldn't boot. Then I imaged the drive, wiped the drive, reinstalled and did as outlined above. Is there any relevant information that I have failed to leave out?Hmm, your newsletter you say. Would you consider rss instead? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-29 : 01:50:38
|
| If the files were corrupt before you attached them, the DB will be corrupt. If the files were fine before the attach, then the DB will be fine.--Gail ShawSQL Server MVP |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-29 : 08:45:30
|
| >> Am I at risk of corruptionYes - but what other option do you have? What you are doing doesn't affect the risk as long as sql serever is the same version.The files contain all the information about the database and you could do this via a detach and attach.You might have to remap logins and make sure the server has the same collation as before.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
|
|
"Restored" from mdf & ldf, Is corruption possible?