SQLCrazyCertified (11/21/2012)

---

You should also see next to the principal db says "synchronized"

Since you have witness server, I am thinking, you configured with synchronize...

you could build your own using my handy guide at these links

Part 1[/url]

Part 2[/url]

Part 3[/url]

😉

Are you...

yes you would think, but its not uncommon actually 😀

GilaMonster (11/19/2012)

---

Only add multiple backup destinations if you have multiple separate IO paths (so 32 cores, 32 destinations on 1 LUN isn't a good idea. 32 cores, 32 destinations across...

SQLCrazyCertified (11/20/2012)

---

Hi All,

I was troubleshooting a connectivity issue for a cluster server.

SQL 2k5 on Windows 2k3.

Found an instance is down, manually brought back online. However, I am wondering howcome...

Commonly a network error, what testing did you perform to ensure the default of 10 secs was sufficient to mitigate potential issues on your network?

what is the timeout value you are using for this database?

select mirroring_connection_timeout from sys.database_mirroring

where database_id = DB_ID('yourdb')

Jeetendra (11/19/2012)

---

Hi All,

I am trying to install Multiple instances of SQL Server 2008 R2 on a Windows Cluster in a Active / Passive Mode.

I have installed the Default Instance of...

That's exactly what it is, a secondary replica.

The ghost cleanup is a periodic background task....

Sql server version may be the issue, check for any patches that...

sqlnyc (11/19/2012)

---

Hi Perry,

Yes, we have recently deleted a large amount of rows. In fact I was just in touch with Paul Randal about this, and he suggested that it...

Have large amounts of data been dropped on the source database from this table at all.

arkiboys (11/19/2012)

---

1- if the backup of transaction log is scheduled to run say every 15 minutes then how can I "write to a new file each time with a unique...