July 24, 2007 at 1:30 pm
hi
i am using sql 2000 and i have to migrate my production database which is quite large from one server( my location) to another sql server in another state. what approach should i take. do you think its efficient to do through DTS, or backUp and restore.or any other method.
i do not know much on this stuff. can you give me some idea.
July 24, 2007 at 2:36 pm
I would use backup and restore, then sync up the users, etc. This article covers just about any problem you'll have:
http://support.microsoft.com/kb/314546/en-us
Greg
Greg
July 24, 2007 at 9:19 pm
Derek -
The article referenced is a good start, but may or may not fit depending on your situation.
A couple of questions that may help us provide a little more help:
(1) How big is "quite large"?
(2) What type of database (e.g. OLTP)?
(3) Maintenance window or "live" switch over? Other SLA/concurrency issues that need to be considered?
(4) Type of connectivity available between sites?
(5) Is this a one time move or a DR situation?
Thanks,
Joe
July 25, 2007 at 12:00 am
Better option is to detach, copy to the other server and attach there. Then move the logins to the new server by scripting them and then remove the orphan users if there are any.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
August 15, 2007 at 12:42 pm
hey Sugesh, before detaching should i have to keep the mode as single user and not to allow other users to log in.
if there are more thing to consider b4 detaching and attaching DB.
appreciate ur feedback. Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply