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 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply