Re: Moving databases between servers

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 08:18:12 -0400

In addition to the others, if you are moving user databases, I like
sp_detach and sp_attach... It is faster than backup/restore. 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"CC&JM" <anonymous@discussions.microsoft.com> wrote in message
news:218d801c45a99$64bd24f0$a001280a@phx.gbl...
> Hello,
>
> I need to move all databases from one Server to another.
> Can anybody tell me some steps that i should not forget
> when migrating my databases?
> Is there any information on Master database that i need to
> migrate?
>
> Best regards

Relevant Pages

  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: get All Databases
    ... The reason for this ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > what is the query to select all the databases, or where is the information stored about all the databases. ...
    (microsoft.public.sqlserver.programming)
  • Re: Moving SQL Server 2000 from NT4.0 to Windows 2003
    ... Detach your existing user databases, ... user databases (or RESTORE) to the new server. ... > Hey Steve, ... Windows 2003 will not allow SQL Server SP less than 3. ...
    (microsoft.public.sqlserver.server)