1) Yes, SQL Server is listening on port 1433.

2) TCP/IP is enabled.

3) Firewall is not blocking.

MS troubleshooting had me validate all of these. I will take a look at...

I went through Microsoft's trouble shooting guide and still cannot get mirroring to work.

For logins and passwords. My company does not like the idea of having to maintain the logins and passwords in two sites.

That is what I ended up doing. However, I am interested if someone out there knows of a way to restore master from a cluster server backup.

1) I did issue the file move from S:\ and L:\ to D:\ for the master files (.mdf and .ldf) during the restore process. SQL Server restore of master...

According to BOl, you can alter the logical file name and I just did it by putting my database in SINGLE USER mode first. Then I executed my ALTER...

My plan, see my May 3 posting, worked and my database appears to be in log truncate mode, which means the log is maintaining a small size without my assistance....

I think http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=275242&p=1 is exactly what I am experiencing.

My database was in FULL recovery model and sometime ago I changed it to SIMPLE. I thought...

When a database is in SIMPLE recovery mode, the transaction log space is suppose to automatically be reclaimed to keep space requirements small. I should not have to shrink...

I just used Lumigent's Log Explorer product to look into the current transaction database log. The majority of the log is old, committed transactions. I see dates of...

I guess removing this functionality is one way to handle the unwanted side-effects but another way is to fix the problem. This makes for another option other DBMS have...

The issue has been resolved.

The link was on a over utilized development server. Once I moved the link to another development server, it worked perfectly with a 3 seconds...

I was thinking /S would run my package on whatever server I labeled after /S. If I understand correctly, one cannot use the dtsrun.exe on one server to execute...

Thanks for all the info.

I need to add that this data is being BCPed to staging tables. These are the tables I want to drop the indexes on and...

Thanks for the information but I am looking for something deeper. I failed to mention that I want this to work in a batch mode. Therefore, EM will...