TSQL Backup
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
This article covers the basics of Transaction Log backups and restores in SQL Server. The examples are from SQL Server 2008 however it applies to SQL Server 2005. If a database uses either the full or bulk-logged recovery model, you must back up the transaction log regularly enough to protect your data and to keep the transaction log from filling.
Continue reading about Backup and Restore Transaction Log in SQL Server
From Long time SQL Server DBAs and Professionals are awaiting for a automatic compressed backup utility for SQL server, But It became true only with SQL Server 2008. For too long, if you wanted the benefit of compressed backups, you had to look at a third-party tool. Now, backup compression is built right into SQL Server 2008, and what’s even better is that it’s easy to use.
Continue reading about Automatic Backup Compression in SQL Server 2008
