I agree with Adam. I knew that people would think the answer was wrong, but it isn't. This is a common source of problems in SQL Server, people see certain...

Profiler is probably your best bet.

We do run a monthly newsletter to summmarize everything that's come out.

At this point, we don't have a good way to give you an option and honestly if we went...

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.