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 |
|
schary08
Starting Member
2 Posts |
 Posted - 2012-12-29 : 09:09:14
|
| hi,can you please help me on this query.How to shrink log files below the initial size.thanks in Advance,SreeniSreenivasa Chary.T |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-29 : 10:34:26
|
| There are lots of post for shrinking log file. Search for it. It is not a good idea to shrink below initial size as it will again grow. |
 |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-06 : 03:21:23
|
| DBCC Shrinkfile (Filename, 10)Filename represents the name of the log file and 10 represents the size in MB (In this case it will shrink to 10MB) |
|
|
|
|
|
|
Shrinking Log files