SQL Server Database Backups and Recovery Models – (Part 2) Author: Basit A. Farooq Editor Notes: This is the three part article series on SQL Server Database Backups and Recovery Models. In the first part, you learned about basics of SQL Server backup process and database recovery models. In this second part, you’ll learn about various SQL Server backup types,...
Tag: restore
SQL Server Database Backups and Recovery Model – (Part 1)
SQL Server Database Backups and Recovery Models – (Part 1) Author: Basit A. Farooq Editor Notes: This is the three part article series on SQL Server Database Backups and Recovery Models. In the first part, you will learn about basics of SQL Server backup process and database recovery models.In the second part, you will learn about database backup and transaction...
Tips for using SQL Server 2012 backup and restore
Tips for using SQL Server 2012 backup and restore Consider using page restores. SQL Server Management Studio supports page restores in SQL Server 2012. Now you can check database pages for corruption and restore selected corrupt pages from a database backup and subsequent log backups. Use the Database Recovery Advisor to construct restore plans that implement optimal correct restore sequences....