January 17, 2005 at 1:32 pm
We are planning for a new production database server that we will migrate too.
Our current server uses the Standard edition and we plan to set up the new one with Enterprise. The current production server would later be rebuilt as with Enterprise and used as a standby server.
Our current system has DTS packages, jobs, and of course logins.
Any assistance as to the suggested steps to move to this new server would be appropreciated. Would the approach to stop both servers, copy over all .mdf and .ldf files be the simpliest or is this not possible when going from Standard to Enterprise? Assuming of course that the drive paths are the same.
Thanks for your time.
January 17, 2005 at 2:13 pm
IT seems most people that aren't experienced DBAs like the detach, attach method. I'd recomment that. (search detach on this site). For the logins, sp_help_revlogin from Microsoft (search technet) can help here. For the DTS packages, open and save them to the new server. Jobs can be scripted, then run on the new server.
January 18, 2005 at 1:32 am
See, if this helps:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 24, 2005 at 11:19 am
Thank you for the postings. I will try tem in a test run.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply