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 |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2007-05-02 : 12:17:08
|
| Hi folks,I have setup a re-indexing job on a sql2005 server.It runs great. But...in the morning the first Transaction log backup equals almost the size of the entire database. Am I missing something here.I am looking at a similar job on SQL 7 and the transaction logs are not changing much from normal.RegardsParesh MotiwalaBoston, USA |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-02 : 14:08:28
|
| Possible, you may need backup log more frequently. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-02 : 16:41:08
|
| "in the morning"Why is there an interval between the re-indexing and "the morning"?Please backup your TLog every 10~15 minutes, regardless of Day or Night, so that your Re-index job is backed up at least as often as during normal working - in fact the re-index will almost certainly be generating more transaction traffic than normal usage.Kristen |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-05-02 : 19:28:39
|
| Thank You.RegardsParesh MotiwalaBoston, USA |
|
|
|
|
|
|
Re-Indexing Jobs