Re: can you restore msdb to a new server?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 14:44:27 -0500

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: How to upgrade MSDE databases to SQL Server Databases
    ... First however we are going to permute the install sequence on a 'web ... farm' parameter and then permute a server target on the WSS Web Admin ... between Microsoft Access, MSDE, SQL Server Express and SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Backup issues after changing administrator name
    ... I set the relevant sql server databases to simple and ... You back up data from a volume that contains a Microsoft SQL Server ... > As creating the volume shadow copy failed, the open files shown in the log ... > CSS (Customer Support Service) for the following hot fix. ...
    (microsoft.public.windows.server.sbs)
  • Potential issue with DTS and Log Shipping
    ... My set up involves three SQL Server Databases. ... copy of first via log shipping. ... have a DTS packagage that that copys select ...
    (microsoft.public.sqlserver.dts)
  • Re: web services
    ... SQL Server databases are usually connected to using TCP/IP, ... ..Net Developer ... without web services, or I have to use web services? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL 7.0 to 2000 migration
    ... Use the "Copy Objects and Data Between SQL Server Databases" option in DTS ... > loose my primary keys and indexes. ...
    (microsoft.public.sqlserver.setup)