I don't know the state it was before the disaster test. I was involved after, when everything was back up again and working.
Can I check that afterwards?

Thanks, but this happened a few days ago so I can't see the status from then. The dbs and AGs are up and running right now.
I'm troubleshooting the incident.

Thanks for the tip but it is already set to automatic.

So the questions are:

-  When the server goes down, the AG fails over to  node 2.

Hi,

Thanks for your input.

I'll check it out.

For now I set it up with sp_foreachtable as an sql task which truncates the tables and then the transfer sql objects. It works...

xxdbxx (6/4/2009)

---

Yes you must have windows clustered first before clustering SQL as the SQL install steps you run to cluster it are different and run many checks to ensure the...

Thanks Ahmed!

This link was exactly what I was looking for. Especially the correlation between spid and thread ID.

I will save all these links so I can return to...

Gordon (6/9/2008)

---

Are you referring to having the SQL server...

Hi Gordon,

Thanks for your reply.

Actually, we're setting this up for a customer. I don't know about the advanced file types since I'm not the one doing the backups.

They don't have...

Thanks Steve,

The links were helpful.

The sql cluster installation was successful. I had some issues with Service Pack 2 on one instance. But finally it went through. So I'm pretty satisfied.

Thanks...

Thanks for your contributions!

On your suggestion, Strommy, how do I deny the 3 first permissions that are shown in the properties for security admin?

- Add member to security admin

-...

Try searching the web for "oracle import" or similar.

A good start for import/export is http://orafaq.com/faqiexp.htm

/ricardo