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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-26 : 11:04:35
|
| Sam writes "I'm having a strange problem with my production server. The server is running on SQL2k-- SP2 on WIN2k-- SP2 Compaq DL 760's (8 way processors). The database size is 16GB. We run Full backup every night @ 9PM and tlog backup every hour between 11:30PM - 8:30PM.Now the question is.... Daily after every full backup the first tlog backup is very huge almost the 16 GB and the next subsquent tlog backup are few megs.There is basically no user transactions or any Jobs running between 9PM to 11:30PM. How come my first tlog backup grows very huge?? Thus we have a space issues on the server.The size of last TL at 8:30PM is 7MB.Please help Sam" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-26 : 12:41:28
|
| Are you doing reindexing in your maintenance plan along with the full backup? (I think it is called optimzation in the wizard)This will cause a lot of trasaction log activity.-Chad |
 |
|
|
|
|
|
Administration