Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Copy database and rename in SQL 2008

Posted on 2013-06-23
3
Medium Priority
?
313 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 2000 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

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, …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

876 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