Have a read at this ...

http://sqllearnings.blogspot.com/search/label/Distributed%20Transaction%20Coordinator%20(MSDTC)

Might be similar solution ...

Thanks.

Mohit.

John an errors in the SQL Server error log? Can the two servers communicate? Firewall issue? Port issue?

Thanks.

larry Hennig (3/13/2009)

---

[p]Our IBM Tivoli server backups do not pick up the system database files, so after recovering a server, there is no master.MDF, so I cannot start SQL Server...

It will be easier for us to help you if you can provide us the table structure of the three tables in question; with sample data.

Thanks.

Have a read of http://www.sqlservercentral.com/articles/65804/.

But I think Paul or Gail might have to step in here ;-).

Thanks.

Longest the database stays on 2005; and you are just...

SQL Noob (3/13/2009)

---

i keep getting these questions wrong when studying for the 70-431

situation is you do full backups on the weekend, diffs on the weekdays and log backups every hour...

Doesn't look like it, I checked alerts.

It uses sp_add_alert which calls sp_add_alert_internal in msdb; neither store proc actually writes any kind of an audit record. Only thing it does...

SQL Noob (3/13/2009)

---

mostly depends on your hardware and I/O

on the old SCSI drives it took a long time. i have an archive db on the new SATA drives with one...

Index rebuild is a very expensive operation; on small databases it is fine. On larger databases doing full index rebuild can take very long time. So unless you...

glemke (3/13/2009)

---

Why would the logs not reduce in size on their own but do when I manually run the shrink - file - log file process?

Is there a "best practice"...

simon.letts (3/13/2009)

---

Hi thanks, but my question was whether I can remove it. I appreciate what its for but dont understand the point in removing accounts from sysadmin only to...

1. Download the MSI from the Link I gave.

2. Execute, it will extract files in C:\Program Files\Microsoft SQL Server\..... Folder make sure you note down the path.

3. Go in to...

I use scripts for setting up mirroring because setting up over 40 databases mirroring...

Double post, Link.