Posted by Erland Sommarskog on 11/06/07 07:55

(agnesroz@gmail.com) writes:
> I have sql server 2005 express edition installed, i have to
> 2 registered instances sqlexpress1, sqlexpress2 within this server, i
> wanted the exact copy of databases in instance sqlexpress1 to instance
> sqlexpress2, Is it possible to have something like this.. if yes how
> can i do this... guide me with proper links, documents... please help
> me..

For a one-off, or should they constantly be equal?

For the first case, use BACKUP-RESTORE, for the second case, use
replication.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

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

[Back to original message]