Using T-SQL

ALTER DATABASE yourdb SET RECOVERY SIMPLE

[/CODE]

Or using SSMS GUI, right click the database and select properties. On the database properties select...

GSquared (8/13/2012)

---

GilaMonster (8/10/2012)

---

Late, and I have...

no, standalone is completely different, it mentions this in the link i posted 😉

i only recommend changing the network name if you really have to

http://msdn.microsoft.com/en-us/library/ms178083.aspx

network name for the windows cluster or the clustered sql...

robert.baird 2778 (8/10/2012)

---

1. I'm having to adjust my naming convention, due to the requirement to needing separate Network names. As an example, HQSQL05/Instance1 is the first one I installed. I...

This is bugging me :ermm:

but why do you want the present publisher...

no worries. You're bang on the money about the cure\fix, I hope the OP realises what a mammoth task they have if they want to change the dist database.

you only need 1 quorum disk resource, period. There are other quorum models available and depending on the number of nodes and geographical location, you could probably do away with...

This is incorrect.

A distributor may have multiple distribution...

No, networknames, like computernames, must be unique...

tilew-948340 (8/9/2012)

---

The restoring process gives me an error: "the tail of the log for the database XYZ has not been backup up"

The database works fine (except that users makes errors...

Failover the group before attempting to join or remove the database

alanspeckman (8/9/2012)

---

So,

Browser service needed:

1. If connecting using only the instance name with a non-standard port

2. If connecting to an instance that uses dynamic ports, such as a named instance because...