Link to home
Start Free TrialLog in
Avatar of Romacali
Romacali

asked on

Databases dupliacate it

hello I have to duplicate a database with a different name in MS 2005.

How can I do it in a easy way/

thanks,
ASKER CERTIFIED SOLUTION
Avatar of PIERCGG
PIERCGG
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chapmandew
i agree with piercgg....
Avatar of Romacali
Romacali

ASKER

I backup using SQL Server Enterprise manager all task backup.. the restore there is no option to restore with a new name. How can I restore it under a different name?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you use the SQL Server Enterprise manager you can actually TYPE the new name in the field that says: "To Database:"   You don't have to use the drop-down list if you don't want to.  You can just type in any name you want.