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.

Scott, that is an awesome explanation.

Or there are mitigating...

You have to create something specific to...

My advice is two-fold.

First, don't try to shrink while other people are using the database. Find a maintenance window. Change the db to Single User if you have to. Keep...

This sounds somewhat like homework. But since you've posted what you've tried...

Break down your problem. Don't do it all at once.

Let's start with the first concern. Here we need...

Sysaltfiles is also a SQL 2000 deprecated table included only for backward compatibility. If you answer Gail's question, we may be able to assist you with an alternative.

Hey, guys, we have a language conversion question over here. Can anyone assist with this?