SQL Server 2008 Backup
Overview SQL Server 2008 has come up with inbuilt compression for backups. Until the release of SQL Server 2005, compression was only available via third party backup software such as SQL Lite Speed, SQL Zip, etc.
Exercise Following is the simple example that demonstrates how to take [...]
Continue reading about BACKUP Compression in SQL Server 2008
Just a day before working on one of the projects, I had to take a backup of one database of 30 GB. My hard drive lacked sufficient space at that moment. Fortunately, I had two 16 GB USB Drives with me. Now, the question was how to take a backup in two equal sizes, each [...]
Continue reading about Split Backup Files while Backup and Restore SQL Server Database
Once you are started using SQL Server database for your application, you need to start taking database backups regularly. If it may be a development database or production database, you should take backups in a timely manner. Because if your information get loss, that brings you in loss. We cannot prevent the data loss due to disk failure, file corruption, code bugs, external factors, etc.
The best practice is to take database backup and store it in an external media like tape drive and keep it in a safe place. The easiest way to take database backup is by using SQL Server Management Studio (SSMS).
Continue reading about Backup SQL Server Database using SSMS
