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 |
|
sridharsridhar
Starting Member
21 Posts |
 Posted - 2013-07-22 : 06:16:45
|
| Hi Can we delete SQL Database log file . i want to delete is there any problem if we delete it ?sridhar |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2013-07-22 : 06:24:56
|
Not a good idea!Why do you want to delete it?
Too old to Rock'n'Roll too young to die. |
 |
|
|
sridharsridhar
Starting Member
21 Posts |
Posted - 2013-07-22 : 06:32:15
|
| its in c drive the memory for c drive is only 50 GB in that the SQL DB occupied upto 20 GB thats y ?sridhar |
|
|
|
sridharsridhar
Starting Member
21 Posts |
Posted - 2013-07-22 : 06:35:04
|
| the database we created and configured is having 20 GB Log file thats why we want to delete itsridhar |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-07-22 : 06:41:32
|
What is your recovery mode? If FULL, please backup database and the shrink logfile.However, this is a workaround because there is a reason the log file has grown to the current size.You should investigate why the log file need this size in the first place.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
sridharsridhar
Starting Member
21 Posts |
Posted - 2013-07-22 : 09:56:49
|
| We had restored Previous Database in to newly installed SQL server 2008 While restoring we had selected full only this is how the log file created and the log file is not in LDF format it saved in database name with no extension .sridhar |
|
|
|
|
|
|
Deleting SQL Database Log File