Solved

Databases dupliacate it

Posted on 2009-06-29
5
178 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

739 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