RE: Moving SQL Server 2000 to a new machine

From: Scott Yu (ScottYu_at_discussions.microsoft.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 11:15:04 -0700

More questions....

Should I restore the system databases in the new server in any particular
order?
Should I restore permissions before or after restoring user databases?
When I restore the system databases, will I detect all of the DTS packages,
Maintanence Jobs, Linked Servers, permissions, etc. or will I need to script
it out or recreate it?

Once I completed and tested the new servers. Do you have any advice on the
order I should start introducing the servers into the new domain.
As I mentioned I have five servers.
1. Production Server. Act as a Publisher/Distributor and Link Server with
Server 5
2. Development server
3. Gateway for user to adhoc and Subscriber to Server 1
4. Internet Development server
5. Remove server and Link Server with Server 1

Tons of questions right? Sorry, but your time and response are very
appreciated.
Thank you.
:)

Scott Yu

Relevant Pages

  • Re: test environment windows 2003
    ... an authorative restore after the demote and system state restore. ... Remove the physical cable for the new pc and build the member server ... At a command prompt type in NTBACKUP and do a system state backup saving ... Master Operation roles (FSMO and the File Replication service). ...
    (microsoft.public.windows.server.active_directory)
  • Re: Exchange Server Restore From Backup - Help Needed
    ... had to modify the backup so that the Exchange Server files were only ... when I come to do a restore the only option I ... get is to restore to the current machine or to another Exchange Server. ... Because the Travan Tape only holds 20GB uncompressed 40GB compressed, ...
    (microsoft.public.windows.server.sbs)
  • Re: Disaster Recovery with NTBackup
    ... Windows Update may ... Win2K3 SP1 only (if not integrated into your SBS CD) ... Restore the backup using the document from the link I mentioned ... size equal to greater than the original server). ...
    (microsoft.public.windows.server.sbs)
  • Re: Exchange Server Restore From Backup - Help Needed
    ... Set the database settings for public folders and information store to ... you would want to be careful not to restore the files from the tape ... overwrites/stuffs up my Exchange server as I do use that for collecting ...
    (microsoft.public.windows.server.sbs)
  • Re: backup solution for sbs?
    ... Restoring Your Server ... you can restore to the same computer or you can restore to new hardware. ... Before restoring your server, disconnect any external disk drives, such ... restore your server from the latest successful backup. ...
    (microsoft.public.windows.server.sbs)
Loading