I've taken an opposite tact. Often I've just tracked the file sizes of backups.

Either way works, just be consistent.

Didn't think of that, Greg, and it's not bad. It is maintenance if you change the job, though you could abstract things with stored procedures.

Adding/removing a day means just adding...

It fails in some places, with some keywords, but you are right. For the most part, SQL Server can figure it out.

However, it also messes up color coding, and confuses...

So the access used to work with people being members of Group1?

Are you sure it wasn't through some other method that got revoked?

I'm not enough of an AD guru to...

Jeffrey is correct, it isn't stored.

the closest thing is to check the backup file sizes. There is a size stored in msdb.dbo.backupset, which gives you an "idea" of data size....

Two simple ways from me. There might be more elegant, but off the top of my head.

1. control access to saving by removing insert for users on the tables, use...

That is interesting. Thanks for the link.

Reporting Services.

Do any of the items above matter to you? Limits on SQL Server? Windows only?

If not, what do you have more expertise in from a development standpoint?

This is a cross tab report. Search on that and make an attempt. We can help if you can't figure it out from examples.

When you read the feed, specifically make the data a parameter. Use stored procedures and don't ever take the chance that the data from your feed could ever get...

Sinanju, haven't read that in a long, long time.

Ah, sorry don't have a better way. Was thinking putting it in one step would help.

I've never heard of this type of scheduling. I guess you could simplify it by...

You are welcome.

Right, sorry, Flip to full, truncate to clear space, flip back.

I want to reset the space usage down and see what happens.