1

I need to copy database from production to development instance in SQL Server 2012 as I don't want to mess up the production server database.

Can someone suggest how I can do this ?

4
  • 1-Take backup from production and restore it on development server or 2-Use copy database built in feature Oct 27, 2014 at 18:55
  • I don't have a permissions to restore database. is it safe to use copy database ?
    – user51060
    Oct 27, 2014 at 18:58
  • Be sure to remove any sensitive information, such as credit card numbers or phone numbers etc. Oct 27, 2014 at 18:59
  • when i am trying to restore i am getting this below error ."NO Backupset selected to be restored"
    – user51060
    Oct 27, 2014 at 19:05

1 Answer 1

3

Backup from PROD with COPY_ONLY, compression and restore it on DEV server is the best option.

Make sure to enable Instant File initialization to cut down the restore time.

Edit:

I don't have a permissions to restore database. is it safe to use copy database ?

This might imply that you are not authorized to do such operation. You can ask your DBA to help you out once you have put in a proper support ticket.

Also, its quiet important to wipe out PII information when you do a restore on a NON PROD system - as @MichaelGreen pointed out.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.