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/

Who is Participating?
PIERCGGConnect With a Mentor Commented:
back it up and then restore it under a different name
i agree with piercgg....
RomacaliAuthor Commented:
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?
chapmandewConnect With a Mentor Commented:
there should be a 2nd tab where you specify the new name....or you can just do it through tsql

restore database newdatabasename
from disk = 'c:\backupfile.bak'
with move 'DatabaseName_Data' to 'c:\newfolder\databasename_data.mdf',
move 'DatabaseName_Log' to 'c:\newfolder\databasename_log.ldf'
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.