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 |
|
Abid
110 Posts |
 Posted - 2011-02-17 : 21:37:14
|
| hi, when we create database so two files which created are .ldf and .mdf. Suppose if one them has been deleted so what will happen and how can we get it back? |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-02-17 : 21:42:45
|
Hopefully you have a backup. Otherwise, you are not having a good day.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-02-18 : 06:14:41
|
Just a note because you are asking in the form of: "Suppose if ...If the SQL Server is running and the database is not detached then the mdf and ldf can't be deleted because the files are in use.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
what happends if i lost .ldf or .mdf file