|
|
Posted by agnesroz on 11/06/07 13:49
On Nov 6, 12:55 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (agnes...@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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Thanks Erland ,
Well i tried backing up the database using[rightclick database-
>Tasks->backup] i get a dbname.bak file, then i restored
the same .bak file using tools->restore->database but i am not able to
restore this way, i am getting the error "the backup set holds a
backup of a database other than the existing 'dbname' database.please
help me how to resolve this error... Or can i have a replica of a
database within same server... if yes, please tell me how can i do
this..
Navigation:
[Reply to this message]
|