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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-04-18 : 06:18:46
|
| One of the .ldf files in sql server 2005 is about 2 GBHow can I delete this?This is to free up the disck space.Thanks |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-04-18 : 09:15:52
|
| You never delete a log file. Never. Have a look at this article: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56434 |
 |
|
|
mallesh
Starting Member
7 Posts |
Posted - 2007-04-24 : 05:57:30
|
| the .ldf files in sql server 2000 was about 1.5 GB so I deleted that one. Now Database is not working.What shall I do now?and How to recover the .ldf file? I don't have the back-up. |
|
|
|
mallesh
Starting Member
7 Posts |
Posted - 2007-04-24 : 06:16:20
|
| sorry yar... |
|
|
|
craig79
Starting Member
33 Posts |
Posted - 2007-04-25 : 02:11:51
|
| Hi,Try following.Stop SQL Server Services on ur Server.Then copy the .MDF file of ur Database to a server on another location(Avoid ur current server).Then u can use sp_attach_single_file_db [ @dbname = ] 'dbname' , [ @physname = ] 'physical_name'command to attach only ur .MDF.The new LDF will be created in that same path.Mention the whole path of ur copied .MDF file while attaching. |
|
|
|
|
|
|
log files delete