Do you have profiler running all the time??

In addition to what has been mentioned, I would definitely try to make sure that you can have the sql servers mail you. And if jobs are failing on...

You are in a tough spot but my suggestion is to step back and do some cost analysis. Find out the total cost of the infrastructure they are going...

Nicholas is probably the better approach to follow here and you can also use the GUI to do the work for you. It will do the move commands as...

I think the bigger question to ask here is why are you going to be managing 200 + SQL Servers? Do you have 200 different databases?

Why is this happening?...

I have also noticed similar behavior when using maintenance plans. It was the eventual reason(besides a number of bugs in maintenance plans) I have switched to individual jobs to...

I would also check your pagefile and make sure it has enough room and is not full. The other thing is how big are you keeping your logs and...

The resolution was to drop and rebuild the Full-Text index. The database had been moved and then restored periodically. The Full-Text index probably broke at that point and...

you can also restore a copy of the database and pull the jobs out of it. and then put them into the new sytem.

We are getting a warning on a successful server restore:

Warning: Wordbreaker, filter, or protocol handler used by catalog 'ftMYDB' does not exist on this instance. Use sp_help_fulltext_catalog_components and sp_help_fulltext_system_components check...

We are going in as full Admins of the disk and SQL Server. I did catch SQL not fully showing the files once but that has been the rare...

Also review what your backup commitment is. Full backup with transaction logs are best but it may be that your backup commitment has to be much less and you...

The Service Pack is not an issue any longer.

We have found that the restore is working on different Servers at different service pack levels both pre and post SP2 and...

The new piece of information to add is:

Production server is SP2

Development servers are SP2(Restores will not work here)

Staging server is SP1(Restore will work here)

Testing a development server at SP1 to...

The next piece of information I have is the one server we are able to do the restore on is Service Pack 1. I am currently going to find...