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...

Good luck and while I don't think I'll be a guest speaker, I'll see if we can point people your way.

If you have been running log backups, you need to add more space. Your log needs it.

I think you're right for CRTs. Seems like so many people in the US use LCDs now I'm forgetting there are lots of CRTs still out there.

I've seen it multiple ways. Typically when there are two teams, usually larger environments, the production people do the infrastructure everywhere. That keeps environments coordinated and ensures the dev guys...

Yikes! Must have picked up the wrong clipboard :w00t:

I've corrected the link.

And write an article! :hehe: