As i said MSDTC is the OS level so troubleshoot there

either\or not both

Lookup DBCC SHRINKDATABASE and DBCC SHRINKFILE. You'll see this a million times on here, why do you want to shrink the database or its files?

They'll likely only grow...

To use Log Shipping in a workgroup see my article at this link[/url] 😉

Could be anything, this is outside of SQL Server, have you checked the event logs and cluster logs for more detail?

are the servers in different domains or a workgroup?

So how can you state that the servers "cant see" each other.

The access you are describing requires Netbios ports to be opened!!!

If you can...

SQLSACT (10/8/2012)

---

Is it safe to say that when a page is requested and it's not in the buffer pool, 2 reads are happening, 1 Physical(To bring the page into memory)...

The way i am understanding what you have said above is that on server...

Quite right, SBS runs Exchange, SQL server, IIS and domain controller. Its mainly about performance, which is why the min spec for an SBS server is so high for such...

Jeff Moden (10/8/2012)

---

Have you got an...

Sure, no problem

DBA_Learner (10/8/2012)

---

I am thinking of these steps to determine. Please correct if there is any mistake. Thanks

1)If Primary Server Fails, then on Mirror Server execute

ALTER DATABASE <database_name> SET PARTNER...

Books Online just being cautious then:-D

Lessons from a pro

you would have thought so Gail, but BOL still states that forced service is possible with safety on and no witness but at the risk of possible data loss. In...