Tag Archives: Backup

SQL Server Backup and Restore Interview Questions

SQL Server Backup and Restore Interview Questions   Here are the list of SQL Server Backup and Restore Interview Questions which are asked in SQL Server DBA interviews. 1. How does the database recovery model impact database backups? Ans: First the … Continue reading

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , | 14 Comments

SQL Server database backup automation using T-SQL

SQL Server database backup automation using T-SQL I have gone through a request as a part of daily maintenance. Found a backup maintenance plan has been failed due to low disk space.  “SQL Task     Description: Executing the query “BACKUP DATABASE … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , , | Leave a comment

Backup Compression in SQL Server 2008

Backup Compression in SQL Server 2008 Backup Compression in SQL Server 2008  is really a amazing feature. Earlier we used to use litespeed to compress the backup. As we are dealing with the backups that are in 2 GB to … Continue reading

Posted in SQL Server DBA | Tagged , , , , | Leave a comment