Re: Disaster Recovery question
From: ChrisR (ChrisR_at_NoEmails.com)
Date: 10/26/04
- Next message: Stacy Hein: "Re: Transaction Log Maintenance"
- Previous message: Mike Epprecht (SQL MVP): "RE: corrupt index"
- In reply to: Tom Moreau: "Re: Disaster Recovery question"
- Next in thread: Tom Moreau: "Re: Disaster Recovery question"
- Reply: Tom Moreau: "Re: Disaster Recovery question"
- Reply: Tibor Karaszi: "Re: Disaster Recovery question"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 08:18:01 -0700
Tom I appreciate your reply. To clarify, you are referring to a box with
another name, correct? Ive made several attempts at this and have yet to do
it successfully. I restore it fine, but then the service doesnt start and
doesnt report an error either. Says it can be an internal Windows problem.
All the KB articles I can find on moving db's makes no reference to whether
or not the box has the same name.
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:OSDMax2uEHA.200@TK2MSFTNGP11.phx.gbl...
> You can restore master to another box. Just keep in mind that if you
don't
> have your app DB's in the exact same folders, you will have a bunch of
> suspect DB's. Here, you can do one of two things:
>
> 1) Drop the suspect DB's and simply restore from backup. IOW, you've
> restored master and the other DB's don't even exist (physically) on your
> server yet. When master is restored, it thinks they're there (since
they're
> in the sysdatabases table) and it then marks them as suspect. Dropping
them
> sets the record straight and you can just restore them at that point.
>
> 2) Restore the app databases first. Make sure they are in the exact
same
> folders as on your original server. Now, restore master and everything is
> in synch.
>
> --
> Tom
>
> ---------------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
>
> "ChrisR" <ChrisR@NoEmails.com> wrote in message
> news:eRF8sr2uEHA.228@TK2MSFTNGP10.phx.gbl...
> Ive been doing a bit of digging lately about Restoring the Master db to a
> box with another name and Im a bit confused. Near as I can tell this
action
> isn't supported. At least not by people in these types of forums. My
> Disaster Recovery pobbibilities are very limited @ the moment. I don't
have
> a spare server. Probably won't have one anytime soon. Yes, yes, Ive
brought
> this up to everyone but got nowhere. The reply I got was if the server
dies
> we would resotre from backup over to the Reporting box. So now my
question.
> I take backups of the Master, MSDB, and user db's regularly. They are put
> onto tape. But, since Master cant be restored to a box with another name,
> what good is the backup of it for someone like in my scenario? That being
> said, how would I ever get back my logins/ passwords, etc. I know I can
get
> the jobs from MSDB, but not the logins. All ideas appreciated.
>
>
> --
> sql2k sp3
>
> TIA, ChrisR
>
>
- Next message: Stacy Hein: "Re: Transaction Log Maintenance"
- Previous message: Mike Epprecht (SQL MVP): "RE: corrupt index"
- In reply to: Tom Moreau: "Re: Disaster Recovery question"
- Next in thread: Tom Moreau: "Re: Disaster Recovery question"
- Reply: Tom Moreau: "Re: Disaster Recovery question"
- Reply: Tibor Karaszi: "Re: Disaster Recovery question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
