HOW to BACKUP SQL ?
How to backup SQL Server Database ?
Ensuring reliable backups of corporate data is one of the most important roles for database administrators. Full database backups can be made using the BACKUP DATABASE command in T-SQL or using the GUI in SSMS.
This Video describes /covers
- WHY Database backed is required ?
- Ways to Take SQL Server Database Backup
- Different Types of Backup
- DEMO : How to Take Backup
- Taking SQL Server FULL Database backup Manually using SSMS – Graphically
- Taking SQL Server FULL Database backup Manually using TSQL CODE
- Schedule a Database Backup
- Compress SQL Database Backup
- DEMO : How to Enable Backup Compression
- How to Enable Database Compression
- Explicitly compress on demand backup
This Video describes /covers
- WHY Database backed is required ?
- Ways to Take SQL Server Database Backup
- Different Types of Backup
- DEMO : How to Take Backup
- Taking SQL Server FULL Database backup Manually using SSMS – Graphically
- Taking SQL Server FULL Database backup Manually using TSQL CODE
- Schedule a Database Backup
- Compress SQL Database Backup
- DEMO : How to Enable Backup Compression
- How to Enable Database Compression
- Explicitly compress on demand backup
What is Backup Compression and how to enable them ?
Backup compression was introduced in SQL Server 2008 , which reduces the size of backups and the time that it takes to create them.
Please check my previous post, Backup Compression Video Tutorial for more details.
How to get a report for all Database backups, which are being done in last seven days ?
Please check my previous post, http://www.sqlserver-training.com/database-backup-report/- for details.
How to convert LiteSpeed backup to a native SQL backup ?
Please check my previous post, convert LiteSpeed backup to a native SQL backup, guide.
