0

Since i started to work as a DBA, i'm making normal backups ( with scripts, ad hoc and etc ).

What would be the better solution for a backup? lets say I need to migrate a 2tb database to development environment and not affect the production environment.

I can't find much information about VSS backups. I'm trying to think now as a microsoft DBA and not like a normal DBA anymore.

I Just found This good site about VSS backups

What is the difference between a shadow copy and a backup?

In the case of a hard disk drive backup, the shadow copy created is also the backup. Data can be copied off the shadow copy for a restore or the shadow copy can be used for a fast recovery scenario—for example, LUN resynchronization or LUN swapping. When data is copied from the shadow copy to tape or other removable media, the content that is stored on the media constitutes the backup. The shadow copy itself can be deleted after the data is copied from it.

  • So is your question about migration strategy or preferred backup solution ?. – Shanky Jul 13 '16 at 11:20
  • It's about preferred backup solution. I'm trying to understant better better pratices. I'm reading some microsoft books and I just can't understand if i'm doing stuff wrong, or there's just a betterway to do stuff. And I'm preparing myself to do the 70-462 test tomorow. It will be good to know things like this. It's my first certification so i need to think bigger. – Racer SQL Jul 13 '16 at 11:22
  • There are two backups which take help of VDI/VSS. 1. Snapshot backup which is not preferred one. 2. Backup using third party tools. The 2nd option is good one and if it suits your environment you can use it. Most TP backups tools today have ability to perform full,diff and trn log backups. – Shanky Jul 13 '16 at 11:50
  • 1
    Yes using 2nd party tools looks better. if i'm not wrong, VSS backups are used to back up databases while applications are still running and altering the database, right? so this way, it doesnt affect production enfironment. When I use a manual full backup, it breaks the backup chain right? So, using a 2nd party tools with VSS backup would be the best solution to migrate a database to another sql server? – Racer SQL Jul 13 '16 at 11:55
  • 1
    FYI... Doing a backup alone will not break the log chain. VSS is not a replacement for backups but it gives you some backup redundancy but it alone should not be used in place of good backups to disk (there are gotchas with VSS). As the article explains, In the case of a hard disk drive backup, the shadow copy created is also the backup. Data can be copied off the shadow copy for a restore or the shadow copy can be used for a fast recovery scenario. So the shadow copy can be where the backup occurs once the snapshot is created and once the backup from it is complete, then you can delete it. – Pimp Juice IT Jul 13 '16 at 12:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.