January 12, 2012 at 11:34 am
We have a production server which is 2 node cluster. DR is proposed to have stand alone machine, with SRDF solution for SAN replication.
I'm not sure how these 2 system tables will react if system databases is copied over to standalone machine
sys.dm_io_cluster_shared_drives
sys.dm_os_cluster_nodes
Do you see any issues if SRDF copies system database from clustered to standalone machine?
Please suggest.
SK.
January 12, 2012 at 11:51 am
csuresh79 (1/12/2012)
We have a production server which is 2 node cluster. DR is proposed to have stand alone machine, with SRDF solution for SAN replication.I'm not sure how these 2 system tables will react if system databases is copied over to standalone machine
sys.dm_io_cluster_shared_drives
sys.dm_os_cluster_nodes
Do you see any issues if SRDF copies system database from clustered to standalone machine?
Please suggest.
SK.
Here is my understanding about it...
sys.dm_io_cluster_shared_drives and sys.dm_os_cluster_nodes are actually views (not tables) that should return nothing if running on a not clustered instance.
http://msdn.microsoft.com/en-us/library/ms188930.aspx
http://msdn.microsoft.com/en-us/library/ms187341.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 12, 2012 at 12:00 pm
Thanks.. Do you see any other issues in copying system databases from Clustered to Standalone.?
January 12, 2012 at 12:34 pm
What about servername, instance name for your standalone server ?
Are they equal to the original servername ?
If not, you may have some issues with msdb (sqlagent), and master sysservers
have a look at http://msdn.microsoft.com/en-us/library/ms190190.aspx
how about external usage of things from within your sqlinstance on the local box ?
if you need to grant windows auth on folders, you'll need to do that too if these folders do not reside on the luns to be migrated.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 12, 2012 at 12:45 pm
csuresh79 (1/12/2012)
Thanks.. Do you see any other issues in copying system databases from Clustered to Standalone.?
Well... I do not know.
I been told it works fine between two standalone instance where everything including Master database gets replicated.
May be is not a bad idea to ask/involve EMC or even Microsoft.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 12, 2012 at 2:08 pm
csuresh79 (1/12/2012)
Thanks.. Do you see any other issues in copying system databases from Clustered to Standalone.?
Copying system databases from any server to another will always lead to some issues, and SQL2005 is the worst for this.
the local ids created by SQL server on install will all be orphaned
linked server will not work
encryption would fail
maintenance plans will not work - best to avoid these in this scenario
SSIs packages will not work unless configured to use external connection strings (an XML file for instance)
always a chance SQLagent jobs will not work if any server hardcoding involved.
You will need to amend sysservers
I have a feeling there are more but I cannot think of them right now.
Personally, unless you have the luxury of boot from SAN, I would not copy system databases but script out objects required and treat SAN replication like log shipping or database mirroring, replicating only the drives supporting the user databases and backups.
As you have SAN replication, if you have windows 2008, have you considered geo-clustering?
---------------------------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply