My best advice is to suspend the mirror while doing the shrinks on the primary. There's nothing really you can do for the secondary. Unless you want to break the...

I have the simplest error-handling method in the universe:

Is there an error?

DROP DATABASE <problemDB>;

Done.

It's not just you. Though, to be fair, Try...Catch probably caught...

Any shrink is going to fragment indexes. Your issue seems to be that you want to see results sooner rather than later. Also, mini-shrinks do work on larger databases without...

Good catch, Sean. I didn't even...

My best suggestion would be to use a Data Flow task to insert various items to evaluate the final row, then used Derived Column tasks to add the final blank...

I don't know that it will continue where it left off.

But did you verify that SQL Server Agent is set to restart automatically (at the Agent & service level) when...

Luis, you are a better person than I am. I have no desire to keep encouraging the OP to ask for the query, so I am not answering at the...

IP addresses have nothing to do with the drive the files are on and everything to do with the NICs in the servers / assigned to the servers.

That being said,...

Sorry, I don't provide queries for homework. Please look at what I previously said about breaking down the problem and try it yourself.

You could write yourself a data dictionary report in SSRS that would pull all dependencies on each object. Then refer to that report every time you go to make a...

Check the windows events logs for errors and warnings around that time. Also look at the information messages. What is going on at the server / OS level during that...

Are DB1 & DB2 on the same server? If not, run a hardware check. I can't count the number of network issues we had because a NIC was going bad....

Jagdev, post a new thread and detail your issue a little more.

People don't tend to respond to older threads.

Have you seen this solution[/url] at Simple Talk?

I haven't used it myself, but it looks interesting.