Best Way to migrate databases

Hi all,
What is the best way to migrate all databases from one sql server to
another?
We are buying a new hardware for the database server and we need to move all
databases to the new machine.
Thanks in advance,
Fabio
I like BACKUP and RESTORE, but sp_detach_db and sp_attach_db also work.
Here are some KB articles for you:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Fabio" <fabio@.glb.com.br> wrote in message
news:ugv$2CF6EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move
all
> databases to the new machine.
> Thanks in advance,
> Fabio
>

Best way to migrate databases

Hi all,
What is the best way to migrate all databases from one sql server to
another?
We are buying a new hardware for the database server and we need to move all
that new hardware.
Thanks in advance,
Fbio Augusto
First option I would go about is backup/restore. You can consider
detach/attach also.
Thanks
GYK
"Fabio" wrote:

> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move all
> that new hardware.
> Thanks in advance,
> Fábio Augusto
>
>
|||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/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Fabio" <fabio@.glb.com.br> wrote in message
news:%23ZYDHJg4EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move
> all
> that new hardware.
> Thanks in advance,
> Fbio Augusto
>