you would have to un-install, re-install the SQL instance.

The short answer is yes, those types of replication that use the transaction log will not truncate the log until transactions marked for replication are transferred to the distribution database.

It...

In most cases no. BOL will tell you which options require a restart.

Shane Osborne (7/19/2009)

---

Yeah,

OK so back to thelog shipping question, with the following 2 scenarios.

Unplanned failure - What happens when you bring the failed server back up ? What...

Theres some discussion on this on the discussion thread for the mirroring QOTD from the 16th july

http://www.sqlservercentral.com/Forums/Topic753931-1598-1.aspx

database files not cleanly detached might not attach properly as the files might not be consistent.

I certainly would not feel comfortable relying on this as a DR method.

I have never applied a SP to a multi node cluster so I won't comment on that, but if this is a two node cluster leave both nodes UP and...

A quick google search brings up this

http://www.microsoft.com/downloads/details.aspx?FamilyId=851C39EE-6F9D-47D9-8ECC-44AC1E9DC182&displaylang=en

process basically the same.

apply the SP to the active mode, use cluster admin if you want to stop SQL, run the SP from a...

yes, the service pack puts the SQL instance in single user mode as part of the upgrade as it is updating system catalogs.

Procedure:

Stop all connections to the databases(s), i.e turn...

going to...

As your database files are on a SAN the option of SAN based replication may be available to you.

thats good to know steve. I am sure I have seen threads on this site where people have said they are mirroring quiete high numbers of databases. I don't believe...

good timing steve, I was thinking about checking up on this very question this afternoon!

the article says 32bit system so I presume 32 bit SQL on a 64bit OS would...

We've got it deployed on 3 SQL clusters backing up over 7000 databases on a nightly basis.

quote]

7000? wow. I'm sold, now to convince the management and a client who wants...

sounds to me like the basic problem is the fact the sql server i/o is shared with i/o from other types of servers. the i/o patterns for SQL are radically...