How many types of backup in sql server? Example.

Where to Backup : Shared Drive , Storage Server,Cloud, Tapes, Dat Drives ,Logical

1: Normal Backup (Whole Backup) Full Backup once in week or month
2: Incremental Backup  (After Changes)
3: Differential Backup
4: Copy Backup (Full Backup)
5: Daily Backup (Creation or modification date of current date)

Files : Archive Bit (Off)
Change :  On after changes
Share:

No comments:

Post a Comment

Saturday, 31 August 2019

How many types of backup in sql server? Example.

Where to Backup : Shared Drive , Storage Server,Cloud, Tapes, Dat Drives ,Logical

1: Normal Backup (Whole Backup) Full Backup once in week or month
2: Incremental Backup  (After Changes)
3: Differential Backup
4: Copy Backup (Full Backup)
5: Daily Backup (Creation or modification date of current date)

Files : Archive Bit (Off)
Change :  On after changes

No comments:

Post a Comment

Popular

Total Pageviews

Archive