Solved

Databases dupliacate it

Posted on 2009-06-29
5
176 Views
Last Modified: 2012-05-07
hello I have to duplicate a database with a different name in MS 2005.

How can I do it in a easy way/

thanks,
0
Comment
Question by:Romacali
  • 2
  • 2
5 Comments
 
LVL 6

Accepted Solution

by:
PIERCGG earned 250 total points
ID: 24738943
back it up and then restore it under a different name
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 24738959
i agree with piercgg....
0
 

Author Comment

by:Romacali
ID: 24739052
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?
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 250 total points
ID: 24739140
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'
0
 
LVL 6

Expert Comment

by:PIERCGG
ID: 24739268
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.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question