Backing up to tape isn't ever risky. Restoring from tape is. And when it's risky, so is your reputation, job, etc.

I store one day on disk, the rest on tape....

Thanks for the comments. This was an update of something I'd written a few years back, but it still applies.

Fillfactor and your indexing is something that needs regular maintenance. If...

I think both are needed. I use both, backup to disk because it's faster. Not necessarily the speed of the tape these days, but the speed of mounting, moving, changing,...

Haven't used them, but protegrity was at PASS and it was a pretty good looking system. A little $$$ for me, but it seemed to be setup right, key escrow...

Both might be the best choice. We had some complaints about this for people that don't want to go back. However if I answer 1 question right, is 100% the...

Some things have changed in v2000, so depending on what it's doing, it's possible it doesn't work.

Ta-da!

It's Instant Forum, a rev or two behind the current one.

http://www.instantasp.co.uk/products/instantforum/default.aspx

Sounds like you have a problem creating the database. Does go.mdf exist already? Can you create another db?

SQLAgent needs to connect to SQL Server. It can use it's startup account (and windows auth) or it can use a SQL Server account (SQL auth) you specify.

Need some method to move the backup file to the test server. If you name it the same thing on the test server each day, it makes things easier.

Next...

Freddy,

What version of SQL? It tested out on SQL 2000 RTM and SP3.

Actually DATEDIFF will work for finding the different between two dates. See BOL for formatting.

For the programming, most C# books should show how to work with a result set. As far as stored procedures, try this: http://www.sqlservercentral.com/columnists/sburke/introductiontostoredprocedures.asp

For licensing, you can freely redistribute MSDE for...

Interesting problem. I think what you want to do is loop through a series of departments and call a DTS package to email the results. At least that's what I'd...