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 |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2008-11-17 : 13:04:00
|
| Hi,I've SQLSERVER Maintenance job which take transaction log backup jobs every 3 hrs interval.Time to time I've been noticing transaction logs were growed upto 70Gb.I took manual backup and run DBCC Shrinkage TO SHRING AND BACKUP TO 3Gb. Is there any guidelines how big would be transaction log for any Database? How to determine Database X need transaction log size Ygb? What will happen if I restrickt size of transaction log file?Please advice. |
|
|
karthickbabu
Posting Yak Master
151 Posts |
Posted - 2008-11-17 : 23:26:56
|
| http://msdn.microsoft.com/en-us/library/ms365418.aspx==================================================== you realize you've made a mistake, take immediate steps to correct it. |
 |
|
|
karthickbabu
Posting Yak Master
151 Posts |
Posted - 2008-11-17 : 23:28:26
|
| http://www.dbforums.com/archive/index.php/t-1072984.html==================================================== you realize you've made a mistake, take immediate steps to correct it. |
|
|
|
|
|
|
Transaction log growth