rcheneyjr (4/17/2013)

---

' It is not possible to establish a heartbeat connection between the two virtual servers in OVM as we have it configured now. If you need that functionality,...

You will likely need changes to your network infrastructure and shared storage infrastructure but you should be able to relocate the once you have the above sorted

Whatever you use whether it be

• Log shipping
• database mirroring
• Backup\restore
• some wierd and wonderful concoction of your own

Remember that server level objects such as logins, agent jobs, etc, etc need to be replicated...

This thread is nearly 2 years old!!

A schema is used to collectively identify set objects, the schema can also be used to control permission lists defining access to the collective objects. Users create objects under schemas...

You could also use

SELECT *

FROM sys.objects

WHERE is_ms_shipped<>1

vishalsurya50 (4/19/2013)

---

Hi,,

In sql server 2012 creating a cluster , i had added servers and the next step is Access point for administering the cluster which i need to...

Have you checked the maintenance plan history?

Up to the last differential backup actually, as long as you're taking diff backups of course 😉

TheSQLGuru (4/18/2013)

---

Given the really basic nature of the questions you are asking I feel you should REALLY get someone experienced and knowledgeable to help you determine what your HA/DR/read-only scale-out...

The whole point of AlwaysOn is that you don't have shared storage. There's nothing to say that the disks cant be SAN based but they're not shared across the windows...

Are you getting this...

It's something you see time and time again and you're right it's a futile\costly exercise.

This was only really necessary under Windows 2003 clusters. Windows\sql 2008 have...

the reason for removing the passive node as a possible owner on the networkname resource is to avoid the situation where you're patching the passive node and half way through...