Re: Migration Question Again...
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/28/04
- Next message: Ed: "Re: Migration Question Again..."
- Previous message: Hari Prasad: "Re: Developer to Enterprise"
- In reply to: Ed: "Migration Question Again..."
- Next in thread: Ed: "Re: Migration Question Again..."
- Reply: Ed: "Re: Migration Question Again..."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 22:18:40 +0530
Hi,
You have to migrate the system databases too, specifically Master and MSDB
databases. As soon as you restore the Master and MSDB all your
Logins, DTS packages , parameters , ... will be transferred automatically to
new server. FYI , all DTS packages wil be in MSDB database.
>From the Andrews post, to copy the User and system databases use the below
link :-
http://www.support.microsoft.com/?id=224071
Thanks
Hari
MCDBA
"Ed" <Ed@discussions.microsoft.com> wrote in message
news:184047BD-DFF3-44CD-B696-198B764EC60E@microsoft.com...
> 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: Ed: "Re: Migration Question Again..."
- Previous message: Hari Prasad: "Re: Developer to Enterprise"
- In reply to: Ed: "Migration Question Again..."
- Next in thread: Ed: "Re: Migration Question Again..."
- Reply: Ed: "Re: Migration Question Again..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
