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 |
|
honoredfrank
Starting Member
4 Posts |
 Posted - 2010-09-07 : 05:24:51
|
| Dear All, my server is telling me back up tracsaction logs b/cos it is full. i have back it up. but this morning the error message appeared again. Do i have to delete/empty transaction logs after backing up?How do i delete/empty transaction logs after backing them up?how Frequent should i back up Transaction logs.pls help as this is urgent. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-07 : 08:46:59
|
| >> how Frequent should i back up Transaction logs.Every 15 minutes is a good interval to start with.And then set the growth on the file to Unlimited to stop it giving an error message. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-09-07 : 09:17:44
|
| Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Transaction Log Backup