An FCI can participate in an AlwaysOn availability group, could you detail a little more about the set up of the clustered nodes servicing the FCI and the node you...

pdanes

---

I don't do backups as often as I should - Express doesn't have the ability to schedule jobs, so I do them by hand whenever I see some activity on...

I would follow this KB article 😉

kenneth.holm (6/25/2012)

---

One way would be

1. Backup objects/ login and so on...

2. Pause Node 2

3. Put Sqlservice (resource)...

ScottPletcher (6/25/2012)

---

The advantage of RAID1 here is not likely speed -- atlhough you could see some speed up -- but in recoverability. With RAID1, a single drive failure does...

As Jon has rightly pointed out before impeding the built in admins group you must add the cluster service account and the SQL server service account as logins

See this link[/url]

durai nagarajan (6/21/2012)[hrIn our environment we have two domain users one for SQL services and another for cluster.

i am planning to revoke the access and configure the same with SQL...

whichever way you look at it your disk config is limiting, as is the RAM capacity.

Anthony is spot on here, all communications are essentially triggered from the secondary server. Just a note to bear in mind, the backup folder for the primary server does not...

Are the mirroring instances on the same server or separate servers? Have you checked the mirror endpoints status?

Michael Valentine Jones (6/20/2012)

---

You could just make things simple and execute this in your database every night:

execute sp_updatestats

sp_updatestats (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms173804(v=sql.105).aspx

"...sp_updatestats updates only the statistics that require updating based on the rowmodctr...

Roust_m (6/20/2012)

---

Perry Whittle (6/20/2012)What on earth makes you think that? It's no different to any other node failure in a cluster, the instance will restart on a partner node. Where...

at what point is the installation at, are there any services installed?

That is correct, remember though that sysindexes is provided for...

ran.ovadia (6/20/2012)

---

Hi,

I currenty have in my Prod env. SQL2005 SP3 + GDR (9.0.4053) and in test env I have SQl2005 + Sp3 (9.0.4035).

Now i need to upgrade my Test env...

🙂 it's even...