The formula is fairly simple:

Set datefirst 7;

Declare @day int

,@today datetime

,@nextMonday datetime;

Set @day = 2...

No - and I really don't understand why they did not build that functionality into it. I...

Tara - what is the account that is running SQL Server Agent?

When in doubt, I review the following excellent articles:

http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx

You really need to identify why the transaction log backup job is failing. If you do not identify and correct that issue it is going to occur again.

Here is...

Review the transaction log backup job and identify why that job is failing. The error you are getting is fairly specific and is telling you that the transaction log...

Indianrock (2/6/2010)

---

Thanks, I'd forgotten about the copy_only backups. Based on what I've found in the way of Commvault forums dealing with sql server, it doesn't appear to be...

This document http://www.microsoft.com/sqlserver/2005/en/us/Special-Considerations.aspx#passive describes the different configuration possibilities and how they need to be licensed.

It also shows the various supported configurations for Reporting Services which your suggested configuration is included.

So,...

I have not used this agent before, but having used various third-party tools for backups my guess would be that the format is proprietary and can only be restored using...

Dixie - those parameters are not optional, the 137 parameters are required parameters - and from what I recall the next 255 are optional parameters that can be used to...

You have the function STATS_DATE - you can use that to identify when the stats were last updated. You can review the stored procedure sp_updatestats to see how this...

Also think about why you need to have an incrementing value for the ID in that table. Does it absolutely require an incrementing value with no gaps? Or...

Unless (!) ...now this is a really unlikely scenario, but what the heck: You are doing a Full backup, and even though you know it will take a very very...

For most cases, auto update stats or sp_updatestats is good enough. For those instances where you need more, you should schedule that separately and with the appropriate sampling rate.

I...

Great - glad I could help.