I'd say that is the best way to go, drop and recreate. The key is doing it in the correct order. When dropping the indexes, drop all the...

Would you want the same level of performance if you had to fail over to the mirror?

How long do you expect to be running on the mirror in a failover...

It is not easy to understand what you are trying to do without examples. Please review the article that I link to in my signature on how to post...

right-click on the maintenance plan and view history - all steps and the duration of each step is in there.

Verify that you have enabled remote connections to this instance of SQL Server. Also verify that you are connecting to the right instance.

larry Hennig (3/13/2009)

---

I hadn't thought of calling the maintenance plan from the hand-written SQL Agent job that calls the script. That just might fit the bill. Thanks!

Unfortunately, powershell...

larry Hennig (3/13/2009)

---

[p]SS Champion, you can't start SQL Server with the master files, so most of that posting did not apply to this situation. As suggested in one message,...

larry Hennig (3/13/2009)

---

[p]Thanks for the quick feedback. especially the tip about using RESTORE HEADERONLY on the master database!

[/p][p]

I do backup the system databases and recovery them as part of...

What is the error you are getting?

The only real option you have is to use a SQL Agent job to run your script, and in the next step call your maintenance plan.

The other options are xp_cmdshell...

Most likely the reason it is taking so long is that it has to pull all of the data in the remote table locally to perform the filtering, before the...

You have to setup EM to include indexes when scripting - has that been done?

In a disaster recovery situation, we re-install SQL Server back to the appropriate version (all service packs/cumulative updates). Once installed, we then restore the databases from our backups up...

You can't - the only time you will get an error in the maintenance plan is if the job cannot be started.

I agree with Lynn - I prefer the second method just because it is clearer what you are doing.