how to copy/ duplicate a Database from sql 2005 express Edition

Question

0.00/5 (No votes)

See more:

hi,

can any body tell me how to make copy of database same as existing.
i can find copy database in database --> task. it is not present.

is another way to do it..

plz it's urgent...

Posted 28-Apr-10 0:10am

archana_Kalyankar

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tom Deketelaere · Answer 1 · 2010-04-28T00:14:00

Make a backup of the database.

Then make a new database (this is going to be the copy)

Then restore your new database (the copy) and use the backup of the original.

Make sure that in the options of the restore you mark 'overwrite existing database' and that you select the correct files (the ones from your copy database).

how to copy/ duplicate a Database from sql 2005 express Edition

1 solution

Solution 1

Add your solution here

Preview 0

how to copy/ duplicate a Database from sql 2005 express Edition

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us