Some tips for using backup and restore in SQL Server 2016 Consider using the simple recovery model to minimize the backup/restore time and minimize administrative overhead for the transaction log. Under the simple recovery model the transaction log is not backed up. So, the data is recoverable only to the most recent backup of the lost data and the point-in-time […]
Tag: backup compression
Tips for using backup and restore in SQL Server 2014
Tips for using backup and restore in SQL Server 2014 Consider using SQL Server backup (restore) to (from) URL. In SQL Server 2014 you can use SQL Server Management Studio to backup to or restore from Windows Azure Blob storage service. This new option is available both for the Backup task, and maintenance plans. Use SQL Server 2014 backup encryption....
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
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....
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here