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 |
|
kash_maddy
Starting Member
1 Post |
 Posted - 2008-09-18 : 08:51:00
|
| Can we detach .ldf file without detaching .mdf file from the database because the .ldf file size exceed 10 GB & it will make problem of disk space for the logical drive. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-18 : 09:06:51
|
| Why you need to detach ?This has been discussed so many times?Check this out:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110865 |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-09-18 : 11:50:47
|
| The transaction log's not an optional component of a database. It's essential and is used for data integrity. Delete it and you may very well get a suspect database.What recovery model is your database in? Are you taking log backups?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
CLEARING .LDF file