August 12, 2009 at 11:53 pm
Comments posted to this topic are about the item Ten steps to migrate databases between servers in a .Net environment
August 17, 2009 at 4:27 am
Pretty interesting approach! This seems like it would work smoothly.
Did you run into any snags along the way?
August 17, 2009 at 5:04 am
Hi Mark, The process is pretty straight forward.
The thing that really helped was getting backups restored on the new server and getting a test copy of the site working with that to make sure all the users were in place with the correct passwords etc. It certainly meant I was more confident when it came to failing the databases over.
ed
August 17, 2009 at 10:35 am
Just a suggestion on step 3 i've found that using the transfer login task and setting copy sid's = TRUE is easier if you have multiple logins to copy.
August 17, 2009 at 6:17 pm
Brilliant article on a good technique. I am going to have to try this out before I actually need it.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
August 17, 2009 at 7:39 pm
Awesome article. I have to migrate a replication databases on 2000 servers to 2008 servers. Will it be possible in this case too?
August 18, 2009 at 3:44 am
Very nice way to tackle the issue of hardware replacement !
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
August 18, 2009 at 5:08 am
Hi,
Thanks for the comments!
greggoble2 - your right using the transfer logins task can definitely help here.
tushkieeeee - unfortunately you can't mirror a sql 2000 instance, you can go from 2005 to 2008 though.
ed
August 19, 2009 at 12:13 am
The process diagram looks very nice. May I know you are using which tool ? Is it vision 2007?:-)
August 19, 2009 at 12:31 am
not quite that advanced, visio 2003!
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply