there's not a lot we can do without the error messages, please provide them as Anthony has advised

thunderousity (7/23/2012)

---

Ah, Yes I've read the original quote again and what you say makes more sense GilaMonster.

I was reading it incorrectly.

Thanks I'll set it and monitor it.

Will 64bit SQL Server...

Yes so it does. Apologies for that, been a long day

http://www.sqlservercentral.com/articles/Database+Mirroring/72294/[/url]

You don't need to break mirroring at all. Pause the mirror and then perform a backup on principal and restore with move to mirror then resume mirroring. It's all in...

You should only run checkdb once with data_purity on a pre 2005 database to invoke the flag, this is not necessary on 2005 on as the checks are automatically completed.

Try...

Has this database ever produced a clean CHECKDB result?

Yes it can.

dbasql79 (7/20/2012)

---

2. Can current working...

thanks for posting back,

thunderousity (7/20/2012)

---

I've been given a VMWare Virtual Machine with the following:

Windows Server 2008 R2 64bit

8GB Ram

I have installed SQL Server 2008 R2 Enterprise 64bit.

What is the best practise relating to...

As I said in my response to your post...

Since this is SQL server 2005 and theres no mention of clustering, the service account will already be a member of the SQL server local groups on the machine and...

No, databases that are part of an AlwaysOn availability groups are already synchronised so recovery should be fairly quick. AlwaysOn is basically database mirroring on steroids 😉

ken.schilstra (7/19/2012)

---

I shutdown all SQL services and ran the converter but still have the same issue.

If I run a full backup, how do I restore it to the instance...

Bobby Glover (7/19/2012)

---

Bringing this up again.

Is it as I have suggested below.

2 Types of always on

FCI and AO Groups

FCI, modification of clustering which already exists, needs shared storeage or can...