Re: Copy entire sql server
From: Mike Labosh (mlabosh_at_hotmail.com)
Date: 01/11/05
- Next message: Juraj Rojko: "Re: Permissions question..."
- Previous message: Chris, Master of All Things Insignificant: "Monitor Query's that come through SQL 2000"
- In reply to: Bob: "Copy entire sql server"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 Jan 2005 17:33:34 -0500
> What is the best way to COMPLETELY duplicate a SQL 2000 server? Im
> thinking:
>
> 1: detach all the dbs
> 2: copy all dbs to new server
> 3: somehow copy logins and jobs etc over (how?)
>
> if i can copy users over and they are in a domain, will i have any SID
> problems?
Could you software RAID mirror it and then break the mirror set?
--
Peace & happy computing,
Mike Labosh, MCSD
"(bb)|(^b{2})" -- William Shakespeare
- Next message: Juraj Rojko: "Re: Permissions question..."
- Previous message: Chris, Master of All Things Insignificant: "Monitor Query's that come through SQL 2000"
- In reply to: Bob: "Copy entire sql server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
