I did think of that too. You could always have some kind of e-mail process at the end to give a notification of completion/failure.

Either that or just poll SQL...

I've not read all of the replies, so this may have already been said.

To create an effective solution the DBA and the SAN managers should be working side by side...

Sorry, for clarity, use sp_start_job from your application to start the scheduled job off.

Alternatively, create a scheduled job with the T-SQL code to backup and execute the scheduled job instead. This way you won't need to play around with timeouts. You...

Additionally, I would suggest that you take a little time to read BOL about backups and restores.

I appreciate this is a simple query and process for me, but if you...

I don't believe there is any impact. I've not experienced any problems personally.

Changing compatibility will open up SQL2005 only features though. I'd restore a version to a test...

Same as 2000.

Well kind of...I always used CTRL+R. I'm sure a button exists on a toolbar somewhere...

Well if the figures are identical, including rowcounts, then yes, you could assume that no reindexing was done.

If I were in your situation, I would let your boss know what's...

No problem. Actually on reading my post, I did play London down a bit. Yes, very expensive to live in on your own - best bet would be...

Also ask the admins who monitor the SAN to look at the disk allocation and any hot spots.

At a previous company, we had an issue on the SAN that was...

Well as painfull as it can be, downtime (even though it's not a complete server failure) can make management spend the money on a test environment.

I'm assuming there was no reboot after the patches were installed? If not, then yes, there is the possibility that a dependent DLL was updated and your dll can...

Anything in the event/sql server/av logs which may give a bit more information?

Have you tried re-registering the dll? Sysinternals has a tool thats lists DLL's being loaded up. ...

Nice...easier than the way I did it the other day!!!!!!!!!!!!!! :crazy:

Not that I am aware of.

You'd need to script the removal and creation of the constraints.