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
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.