RE: How to restore instance on a new server?

RE: How to restore instance on a new server?

 

  

I think Janet is asking about a named instance of SQL Server, not a DB.

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


As long as you have the Enterprise Edition and the various schemas backup
option is set to FULL, the Log Shipping Wizard can create those schemas
NEW on the fly on the DEST. for you.


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



"Mangual Janet A. \(WASD\) "
<mssqldba-ezmlmshield-x465619.[Email address protected]
05/27/2005 09:51 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

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





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

MS Sql Server LazyDBA home page