How to copy Database from existing to new database sql script using sql server 2008 R2?

Question

i need sql script for copy database with data in sql server 2008 r2.I tried the below script but not working in sql server 2008.

DBCC CLONEDATABASE ('MyDatabase', 'MyDatabase_Copy')

you cannot do a backup and restore?

Hooman Bahreini
– Hooman Bahreini

2017-11-04 09:11:25 +00:00
Commented Nov 4, 2017 at 9:11 — Hooman Bahreini
– Hooman Bahreini, Commented Nov 4, 2017 at 9:11

Alberto Martinez · Accepted Answer · 2017-11-04 12:18:39Z

2

If you want to make a copy of the full database to another one you can make a full backup of the existing one and restore it as another database.

To perform a backup you can do doing something like this:

BACKUP DATABASE MyDatabase TO DISK='C:\Backup directory\MyDatabase.bak'
  WITH INIT, FORMAT, SKIP

Then you restore that backup in the destination database (either overwriting an existing database or creating a new one):

RESTORE DATABASE MyDatabase_Copy FROM DISK='C:\Backup directory\MyDatabase.bak'
  WITH REPLACE

If the destination database already exists you could need to use the MOVE option in the restore step (or perform a DROP DATABASE MyDatabase_Copy before restoring).

answered Nov 4, 2017 at 12:18

Alberto Martinez

2,6804 gold badges25 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to copy Database from existing to new database sql script using sql server 2008 R2?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related