Re: Migration from existing database server 2005 to new database server 2005

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Sun, 23 Mar 2008 16:08:01 -0700

(Bigserver@xxxxxxxxxxx) writes:

Can we do online database migration from existing database server 2005
to new database server 2005, plz help me in this regard how to do it

Could you be more specific? You want to move a database from one machine
to another, but you want users to be online as much as possible during
the process?

How big is the database?

Are the two machines connected over fast LAN?

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

References:
- Migration from existing database server 2005 to new database server 2005
  - From: Bigserver

Prev by Date: Migration from existing database server 2005 to new database server 2005
Next by Date: RE: Problem with SQL trusted connection.
Previous by thread: Migration from existing database server 2005 to new database server 2005
Next by thread: Re: Migration from existing database server 2005 to new database server 2005
Index(es):
- Date
- Thread

Relevant Pages

RE: WSS install locked into MSDE DB - Can not install for SQL Serv
... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
(microsoft.public.sharepoint.windowsservices)
Re: How to Replicate an SQL Server 2000 Database
... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
(microsoft.public.sqlserver.replication)
Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
... I have had quite a number of clients that used a SAN for a database server and suffered significant performance problems because their underlying SAN infrastructure was a huge stripe across many drives. ... By application files I mean the binn folder which contains the sql server executable among other things. ...
(microsoft.public.sqlserver.setup)
Re: Where can I find my detached database
... The data file should be in your SQL Server Data folder. ... No chance SSMS to drop a database when you detach it. ...
(microsoft.public.sqlserver.server)
Re: FCB::RemoveAlternateStreams: Operating system error (null)
... Thanks for all your help Ekrem, even if your sugestion does not solve the ... in this edition of SQL Server the ... database so it's opened again and you get this error somehow. ...
(microsoft.public.sqlserver.setup)