Moving SQL Server Named Instances

#1

Hello,

Is it possible to migrate an entire instance of SQL Server 2000 (or 2005) to
another server? And if so, how?

Thanks,

Blair

#2

Blair,

I suggest you use backup / Restore of all databases. For user databases you
could use Copy Database Wizard as well.

--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com

"Blair" <Blair (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hello,

Is it possible to migrate an entire instance of SQL Server 2000 (or 2005)
to
another server? And if so, how?

Thanks,

Blair

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Moving SQL Server Named Instances

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

Moving SQL Server Named Instances - 12-01-2005 , 11:54 AM

Re: Moving SQL Server Named Instances - 12-02-2005 , 12:44 AM