Skip to main content

Posts

Showing posts with the label How to Backup a Database using Management Studio

How to Create a Differential Database Backup and Restore in SQL Server 2012 online training clip

This is an Example of differential backup in SQL server 2012 . Following is the Step-by-Step Approach to Differential Backup for database. 1.let us create one database 2.Now create  one single table 3.You need to Insert  two line records in table 4.Take full backup of data base as mentioned on clips Right click on the database name Select Tasks -> Backup  Select "full" as the backup type for taking full backup Select "Disk" as the destination folder and select path of folder  Click on "Add." to add a backup file and type  and click "OK" to start backup Click "OK" again to create the backup .  5.Now insert one more line in table. 6.Then take differential backup   as mentioned on clip Right click on the database name Select Tasks -> Backup  Select "Differential" as the backup type for taking full backup Select "Disk" as the destination folder and select path of folder  Click on "Add.&q