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 |
|
snarayan
Starting Member
10 Posts |
 Posted - 2004-01-08 : 16:06:12
|
| HiUsing full Backup Model. At the end of backup ( database and log files) say atleast 4 hours later, do a shrink of the log file using enterpirse manager.The current size of log file is 705 MBSpace in use is 207 MBI am setting the shrink size to 500 MB but the current size is not changing. The enterprise manager reports "The shrink was successful' but if you check the log file size - the current size is still 705 MBSuggestions welcomeThanksSanjay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-08 : 16:18:50
|
| Have you tried DBCC SHRINKFILE? Run it from Query Analyzer.Tara |
 |
|
|
|
|
|
Shrink Transaction Log File