Thank you Ellis Remotedba.

I know you have said that the data files are on other partitions, however if any of your databases use Full Text Searching then the catalogues are stored in \Program...

We ended up with downtime for users which was unfortunate, as the cluster has the DBs for our web and email filtering software so the organisation lost connectivity while this...

Vivien Xing (8/13/2008)

---

I think answer "Yes" is also right. A simple/straightforward answer.

"Yes, with full table scan details" is just an answer with more details.

Reindex, of course, a full table scan....

Glad to see a clearer explanation from Simon, had a better understanding after that.

We use a NetApp solution to mirror data from the primary to a...

DMC,

As far as I am aware, and I have little knowledge of SANs, is that SAN replication is preformed by the filers, so the servers etc. are not aware the...

You can run this query:

xp_servicecontrol 'querystate', 'SQLSERVERAGENT'

I would also look at using an index, and not use *, however, with you mentioning deadlocking, maybe you could use:

SELECT *

FROM table_name

WITH(NOLOCK)

WHERE .....

There is a tool with SQL 2005...

Maybe you could use triggers to capture just the data changes (inserts, deletes and updates) only to another table and then bcp that file to the share?

siverson (7/22/2008)

---

I could but one detail I forgot to mention. Network A an B are in the same building but Network C is not. Transferring the entire table...

This may sound a bit random, but could you create a bcp file for the tables that are needed and copy from A to a network share on B and...

There is a free product by Idera called 'SQLsafe Freeware Edition' that allows compressed backups over the network. You can download it from http://www.idera.com/Products/SQLsafefree/Default.aspx

Maybe worth a look...

Cdyer - MSTDC is the Microsoft Distributed...

Maybe you could just write the backup directly to the other server?