AK1516 (3/31/2011)

---

We have the SQL SERVER 2008 fail over Cluster installed on the Windows Server 2008 r2.There is Power outage to upgrade the system inn data center i.e The boxes...

what port numbers have you assigned to the mirroring endpoints on the principal and mirror instances

Brandie Tarvin (3/30/2011)

---

Perry,

I appreciate the help you're trying to give me, but you're giving advice based on incorrect assumptions about my setup. This might be because I'm not stating it...

A database that is set as read_only is exactly that, can only be read no backups may be rstored. To write to the database you would need to perform

ALTER DATABASE...

yes and that wil be fine, the service account is only disabled for use inside the sql server instance...

launch the service pack installer and install on each passive node. Once this is done, Fail over the active node so it becomes passive and patch that.

Hi

i use BCP to dump syslogins to a file, copy it to DR server and then import

annasql (3/30/2011)

---

but I see it will also disable the old service account.

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

But we do want to keep the old login for other server's access. How can we make this...

i noticed issues with MDW while testing 2008, i personally wouldn't touch it at present

Bob Giuliani (3/31/2011)

---

A cluster with 3 nodes, Node 1 with an instance of SQL 2000, node 2 an instance of SQL 2005 and Node 3 with an Instance of SQL...

i would restore the full backup weekly and restore the diffs daily. Restore the logs in the event of a DR switch (minimal work).

yes but the MSDTC group is only active on the one node

the only option you have here is the use of the /3GB switch in the boot.ini

AWE support is for memory over 4GB which...

It's wizard...

How much RAM do you have on the server?

Which edition of server 2003 do you have?