Solved

Copy database and rename in SQL 2008

Posted on 2013-06-23
3
293 Views
Last Modified: 2013-06-24
I have a database named CAPRegisters.  I would like to create a copy of this database with all the structure and data and rename the new database as CAPRegisters2012.

How can I do this?
0
Comment
Question by:al4629740
3 Comments
 
LVL 8

Accepted Solution

by:
didnthaveaname earned 500 total points
ID: 39270160
I had a post to a question about migrating from sql server '05 to '08 R2.  While the situation for you is different, the options are the same. Take a look here: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_28121746.html#a39148501 - you would just have a target db that is named why you want instead of the same as the source db. In your case, a backup/restore is probably going to be the simplest method.  Hope that helps!
0
 

Author Comment

by:al4629740
ID: 39270183
Should I backup the file first and then restore from device?

Or should I just restore direct from database?
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 39270314
Just Restore Database with Different name and Source is DAtabase not Backup file

OR

Copy database option is also there.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQl query 19 19
SQL Help - 12 59
T-SQL Using IN with a subquery 3 25
Sql Query Datatype 2 14
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

929 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

12 Experts available now in Live!

Get 1:1 Help Now