Migration Question Again...
From: Ed (Ed_at_discussions.microsoft.com)
Date: 07/28/04
- Next message: Herman: "Major problem with MSSQL 2000 personal"
- Previous message: Allan Hirt: "loading SQL server 2000 with windows xp"
- Next in thread: Hari Prasad: "Re: Migration Question Again..."
- Reply: Hari Prasad: "Re: Migration Question Again..."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 06:39:06 -0700
Sorry to ask a stupid question again since this is the first time that i do migration.
I've got response from Andrew. But I would like to know that --
If I migrate SQL Server from one machine to another machine, I know I need to transfer all user databases, login, but do I need to migrate (Copy) the databases of Master, Model, MSDB, too?? If so, which method is more preferable? I stil don't see how I am able to transfer all the DTS Pakages?
Many Thanks
Ed
Personally I prefer to just restore a full backup in most cases but these
should give you all you need to know and more<g>::
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 "Ed" <Ed@discussions.microsoft.com> wrote in message news:EF9B462B-C58C-4541-ADF0-C68881D7E3A5@microsoft.com... > Hi, > Right now I will be migrating a development server from an old machine to a new machine. I am not sure if I should use Copy Database Method to move all the objects or use sp_attached/sp_detached. If I use Copy database method/sp_attached method, do I get all the loginID copied, too... how about all the Master, MSDB, Model, and how about all the DTS... > Thanks very much > Ed > p.s. I really appreciated if some can also provide any web links, too... >
- Next message: Herman: "Major problem with MSSQL 2000 personal"
- Previous message: Allan Hirt: "loading SQL server 2000 with windows xp"
- Next in thread: Hari Prasad: "Re: Migration Question Again..."
- Reply: Hari Prasad: "Re: Migration Question Again..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
