SQL Server - How to create shadow of Database in another location (Disk)

Asked By bhanupratap singh on 14-Feb-17 01:29 PM
I want to set shadow copy of my database in sql server 2008. So that I could recover data from shadow database in case of any mishappening. How to do it. 

Robbe Morris replied to bhanupratap singh on 15-Feb-17 09:32 AM
Replication is the term you want to search for if you are making a real-time accessible fail safe for your database.  If not, then look at incremental backups and full back-ups by right clicking your database name/node in the object explorer or SQL Server Management Studio to find the options for this.