Solved

Databases dupliacate it

Posted on 2009-06-29
5
175 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now