Yes, even on a new server you can install a named instance. You don't need
a base instance first if you don't want one.

Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************

-----Original Message-----
From: Mangual Janet A. (WASD)
[mailto:mssqldba-ezmlmshield-x465619.[Email address protected]
Sent: Friday, May 27, 2005 8:51 AM
To: LazyDBA Discussion
Subject: RE: How to restore instance on a new server?

The server only has the SQL Server software installed. No instances are
created yet on the new server.


-----Original Message-----
From: Jon [mailto:mssqldba-ezmlmshield-x97753073.[Email address protected]
Sent: Friday, May 27, 2005 9:51 AM
To: LazyDBA Discussion
Subject: Re: How to restore instance on a new server?

As long as you have the Band Width between the Source and Dest. SQL
Servers and no down throttling on your ntwk, you could quickly setup Log
Shipping thru the DB Maint. Wizard.

Jon Brewer
SunGard Availability Services
MidRange DBA Group
(856) 866-4018

To "LazyDBA Discussion" <[Email address protected]
Subject : How to restore instance on a new server?


Hi Gurus!!!


It is possible to restore a named SQL Server 2000 instance into a new
server? If so which will be the best practices for accomplish this task.
Any help is greatly appreciated.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

-----------------------------------------
Confidentiality Note: The information contained in this message, and any
attachments, may contain confidential and/or privileged material. It is
intended solely for the person or entity to which it is addressed. Any
review, retransmission, dissemination, or taking of any action in reliance
upon this information by persons or entities other than the intended
recipient is prohibited. If you received this in error, please contact the
sender and delete the material from any computer.


MS Sql Server LazyDBA home page