I've seen quite a few people virtualize with success, quite a few more with Grant's experience.

If you virtualize, and I like the idea, you can't use the same level of...

Only by searching through your code. SQL Server doesn't know what isn't being called from other applications.

Once you get running, you can run Profiler and look for objects that...

In Management Studio, there are reports for various objects. Right click, select "Reports" and you'll see them.

A couple comments.

1. Don't overwrite yesterday's backup with today's. Use a new file everyday. Here's the reason. The overwrite occurs first and if the backup fails for some reason, you've...

Not in 2000. In 2005 there are DDL triggers.

I used to capture the output of various things, like sp_configure, every day and store it in a table. The compare it...

Grant has some good resources, but before you ask a question, you need to do some research and some work. We are happy to help, but we don't want to...

Concur with the above.

Rebuilding the clustered index will move the data to a new filegroup if you specify it.

From ASP you have two choices. The first is call DTSRUN with the dtsx file as a parameter, but if it takes any amount of time, you'll have a timeout...

The backup transfer time is less of an issue than the log backup sizes. You can easily FedEx the backup, or take 2 days to xfer it if in the...

You need to go into the SQL Agent properties and set a proxy account for xp_cmdshell. Looks like that account might not be properly set.

Some interesting notes here: http://www.sqlservercentral.com/Forums/Topic581432-263-2.aspx

Interesting comments and good to hear from someone that uses it. I definitely don't think there's a 0 cost to the product, but if you have the skills, I think...

SOX tends to require separation of dutires, so having someone handle the infrastructure makes sense. The problem is you have multiple parts (network, OS, DB, app) and often that means...

I'm not sure here what control you have. The idea here usually is to raise a semaphore of some sort to prevent the data from being used, usually you mark...

Rob,

The thing you have to understand is you're not doing the backup. You submit a command to the server and it does the backup. So the service account running SQL...