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 |
|
ganapathybabu
Starting Member
1 Post |
 Posted - 2009-09-02 : 01:54:34
|
| Are .ldf files optional or mandatory for SQL Server Databases? In case if it is optional, what is the difference between DBs with ldf and without ldfs.Thanks in Advance!!Regards,Surendrababu |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2009-09-02 : 01:58:35
|
they are mandatory.
elsasoft.org |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-02 : 04:10:14
|
| The ldfs are the transaction logs, they are an essential part of the database and are what SQL uses to ensure consistency of the databases at all times, no matter what happens. They are also used for transaction rollbacks.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Regarding LDF Files