george sibbald-364359 (11/12/2009)

---

this would be slightly better as the log chain is not broken by going to bulk-logged, you just lose point in time recovery for log backups with a...

So seeing as how the database activity is next to nil in the early morning hours. Would it be alright to take the following steps?

- set the recovery mode to...

OK, so I must have been smoking something. The log file does NOT shrink when I run my maintenance jobs. Not sure what I saw earlier, but I am not...

george sibbald-364359 (11/11/2009)

---

yes you could do this if space for the log file is a problem or run time for the reindex is a problem.

Bear in mind you lose point...

Thanks for the reply. How do I keep the transaction log at 13GB when the next tlog backup I do automatically shrinks it back down to about 9MB?

Sorry, I'm pretty...

I did read about an idea that says to switch the recovery mode to bulk-logged before the rebuild and then switch back to full afterwards. Is this a good idea?

thanks!

You can link servers by going into security in the enterprise manager for 2000. I'm not sure if you can link a 2005 from 2000 though. You may have to...

Thanks for all your replies. I mainly wanted to know how to determine how busy my database is not the server. So I guess the correct question that I should...

Thank you, I will give that a shot.

I know there is two places to set it. There is SQL Mail and also for the SQL Server Agent. If you're looking to receive mails from jobs that your...

I'm in the same boat where I would like to learn how to become a better DBA. I'm still pretty green. So I'm going to take a shot and start...