Re: can you restore msdb to a new server?

From: ch (ch_at_dontemailme.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 14:44:36 -0600

i've looked at all of those and none of them talk about moving system
databases to a new server that has the exact same name and ip as the old
server, i.e. a server upgrade.

my big concern is that i want msdb on the new server with everything
from the old server, especially the job history. there is apparently no
kb article that describes moving msdb and/or master to a new server.

i'm going to try this
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in
new server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
   It is a must that you should copy the folders to same folders as in
old server
4. take old server off network
5. bring new server onto network (has same hostname and ip as old
server)
6. Start MSSQl Server service in new server
7. see if everything still works.
8. change configuration options since new server has more ram and 2
additional processors (logical).

the above steps come from newsgroup postings and not a knowledgebase or
technet article though. it would certainly be nice if microsoft would
give an "official" way to do this in a kb article. if it doesn't work,
then i'll do what i've done before and script logins, script jobs, save
dts packages to intermediate server, detach all db's, attach all db's,
fix login problems, etc, but i lose my job history that way.

"Andrew J. Kelly" wrote:
>
> Have a look here:
>
> http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
> --
> Andrew J. Kelly SQL MVP
>
> "ch" <ch@dontemailme.com> wrote in message
> news:41E57CC9.80C55A39@dontemailme.com...
> > is it possible to take a backup of msdb and restore it on another server
> > or to detach it and then attach it to a new server?

Relevant Pages

  • Re: AS2005 ... what is wrong with it?
    ... What I have seen is that the dev server is *faster* than the prod server ... And does your dev server also have all 6 databases with all these roles? ... When I restore the "PROV" i got approx 20 sec. ... Starting from an empty data folder should show if this theory is true ...
    (microsoft.public.sqlserver.olap)
  • Re: Copying WSS to another Server
    ... the data in sync I back the SQL databases up and restore them to the replica ... It already has WSS installed. ... > on one server and copy it to another for dev/test purposes, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: AS2005 ... what is wrong with it?
    ... I have 6 OLAP databases on the server. ... When I restore the "PROV" i got approx 20 sec. ...
    (microsoft.public.sqlserver.olap)
  • Re: Exchange DR, what to do
    ... setup blank databases on theDRexchangeserver, ... data out of the RSG, it tries to restore it to the original server, ... the cluster exchange virtual server name was, ...
    (microsoft.public.exchange.admin)
  • Re: Off-Site Duplicate Server Setup
    ... the normal process for databases is backing up the ... backup the backup files to tape/disk/offline/whatever. ... Which is good until restoration when you need to restore the original, ... likely have a live replicated server available. ...
    (microsoft.public.windows.server.general)