If you can get a list of the files you could load them into a table, then use a looping DTS package, populating global variables based upon the contents of...

So you have a public facing IP address (out in a DMZ for example), would this be through a NAT or via a switch that routes traffic from the public...

In the SQL Server log what does it show as IP's, Ports and Protocols that SQL is listening on?

0.0.0.0 in the netstat generally means that it is listening on all...

Of course.

An advantage to Idera is the cost, you could do an extended trial for a very reasonable cost to one instance.

I am running on the same currently.

I am a version behind on the tool, but currently it connects, runs queries and disconnects. The data is displayed in a dashboard,...

I believe that the replicated data is also compressed, however that you would have to turn on compression on the replicated table manually in order to get the benefits on...

Do you get a list of the files that are sent?

I had the issue when going to a new domain, unfortunately they would not set up a trust between the two (actually it was different forests), and so had to...

What version of SQL are you running?

I know that they run a large number of queries against the servers to produce data, you can adjust the refresh interval (thus the...

If you will be using different domain logins you should change those in the script before runing on the new box.

SQL logins would not be affected.

Have Diagnostic Manager currently. Dropping it. Looking for something else, even with a higher price point.

Speaking to the Idera reps there have been major improvements in the latest release. Just...

scb (12/2/2008)

---

Nice! Forgot about the ole log shipping. You can do a similar function with mirroring, but log shipping is probably a bit easier.

Actually you wouldn't even need...

RAID50 is really only useful as it would allow for 3 drives to fail before you would lose your data on the third, rather than losing data when 2 drives...

A tad cunning, but it does work and allow for the minimum downtime.

Defining database as DB_A