up vote 1 down vote favorite
share [g+] share [fb]

It is perhaps a bit stupid question, but I must admit I have very limited experience with MSSQL and yet has to accomplish this:

  1. Take a snapshot of the database and create and exact duplicate on another server?
  2. Take a snapshot of(the same) database and create a duplicate on the same server under a different DB name...

Help!!! :(

Additional info:

Origin DB server: SQL Server 2000

DB server on another machine: SQL Server 2005

link|improve this question
89% accept rate
feedback

1 Answer

up vote 3 down vote accepted
  1. backup the database
  2. restore the database under a new name and/or on another server

Both these operations can be performed from Enterprise Manager (SQL2000) or its replacement SQL Management Studio (SQL2005+), or the TSQL commands BACKUP and RESTORE.

Note: you can restore a database backed up from SQL2000 on SQL2005 with not issues in most cases, but not the other way around.

link|improve this answer
Thank you David. How do I restore DB under a new name on another server though? – Alex N Sep 5 '09 at 14:03
Backing up the database produces a backup file (or extends an existing one). Transfer this file to the other server then use Management Studio (or a RESTORE command issued some other way) to restore a database from that file. The restore process offers you the opportunity to dictate a name for the database once it is restored. – David Spillett Sep 5 '09 at 23:32
Thank you David, it worked well! – Alex N Sep 8 '09 at 4:30
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.