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 |
|
waterduck
Aged Yak Warrior
982 Posts |
 Posted - 2011-05-27 : 03:03:27
|
| Dear All,i tried shrink log file of a database but it completed very fast and have no effect on .ldf file. Therefore i try using (DBCC SHRINKFILE(fun, 0)) also completed in second and have no effect on .ldf.What is happening to .ldf? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-27 : 03:26:22
|
| Probably used blocks near the end of the file or open transactions==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2011-05-27 : 04:47:30
|
| errr....even so...u shrink it those thing will auto gone too rite? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-27 : 08:28:47
|
| No.--Gail ShawSQL Server MVP |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-05-27 : 09:35:09
|
| Have you backed up the transaction log? It will not shrink if you have transactions in the log that are not backed up...- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-05-27 : 16:08:56
|
| Why do you need to shrink the log file? What happened that it is now so large that you feel it needs to be made smaller? |
|
|
|
|
|
|
File Shrink not working