Re: can you restore msdb to a new server?
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/12/05
- Next message: Brad Feaker: "RE: Loading a variable"
- Previous message: Bob: "Re: sql 2k log files"
- In reply to: ch: "Re: can you restore msdb to a new server?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 12 Jan 2005 16:16:10 -0500
Sorry, I could have sworn one of them talked about the system dbs.
BooksOnLine has a section about resorting MSDB "msdb database, restoring" .
As long as you don't have replication issues that may complicate tings a
simple restore will give you the history etc as it was from the backup.
-- Andrew J. Kelly SQL MVP "ch" <ch@dontemailme.com> wrote in message news:41E58C34.37AC8A2D@dontemailme.com... > 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?
- Next message: Brad Feaker: "RE: Loading a variable"
- Previous message: Bob: "Re: sql 2k log files"
- In reply to: ch: "Re: can you restore msdb to a new server?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
