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,
How can I do it in a easy way/
thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i agree with piercgg....
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.