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 |
manny.oliveros
Starting Member
4 Posts |
Posted - 2008-02-08 : 09:54:03
|
Just want to inquire on how to shrink my sql logs.My disk space is running and I suspect that sql logs is the causeof the problem..Kindly help |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-08 : 11:57:29
|
BACKUP LOG <database name> WITH TRUNCATE_ONLY will empty your log file (depending on recovery model) , but if you then want to make the log file smaller, you will have to use DBCC SHRINKFILEJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
Qualis
Posting Yak Master
145 Posts |
|
manny.oliveros
Starting Member
4 Posts |
Posted - 2008-02-11 : 04:40:31
|
Thank you for the info.Just want to confirm if Shrinking a Database won't affect my database and any related application.My problem is that my server is running out of space. My suspect is that the log filesof SQL server is not properly configured.I can perform this procedure but I'm afraid it might affect my database.Currently, I'm still on gathering informaation about this procedure.Any help will be greatly appreciated.. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-11 : 05:49:25
|
Have you checked to see if there are any procedures or transactions that are having an adverse affect on your disk space?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|