Re: [Networker] SQL Recovery to a Box of a different name

Here is the process for recovering to a server of a different name
backing up with individual db backups.

1.    Install SQL on recovery server, installing to the same locations
as the server that you will be recovering.
2.      Install all service packs, and hotfixes as the server you will
be recovering. You can use this link to verify what is needed for the
specific version you have - http://www.tacktech.com/display.cfm?ttid=60.
3.      Make a list of all non-standard db's from the server to be
recovered. Create those db's on the recovery server.
4.      Recover master db on recovery server. Here is a sample command
line: nsrsqlrc -f -s camebrp2 -c beavertn-svr-r6 -t "04/27/04 10:00:00"
-S normal MSSQL:master
5.      Recover remaining db's one by one, or can be scripted. 


-----Original Message-----
From: Anuj Mediratta [mailto:anuj AT ace-data DOT net] 
Sent: Friday, April 23, 2004 11:03 AM
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU; Leiss, Jeffrey
Subject: Re: [Networker] SQL Recovery to a Box of a different name

Yes,

I ran into this but there is no resolution.

They claim it to be an SQL issue. You cannot restore master databases to
a server with different host name.

Regards,
Anuj

On Fri, 23 Apr 2004 09:47:05 -0700, "Leiss, Jeffrey"
<Jeff.Leiss AT NWDC DOT NET> wrote :

>         Has anyone played with this? The problem I have is that when 
> you restore to a different box, you can only restore a copy, and 
> cannot replace any of the system db's such as master, msdb, etc.. 
> Anyone ran into this and have a solution?
> 
> --
> Note: To sign off this list, send a "signoff networker" command via 
> email to listserv AT listmail.temple DOT edu or visit the list's Web site at 
> http://listmail.temple.edu/archives/networker.html where you can also 
> view and post messages to the list.
> =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
> 
> 
> 

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=