Tips for using backup and restore in SQL Server 2019 Use separate storage for the database backups. Ensure that you place your database backups on a separate physical location or device from the database files. You can use backup/restore of memory-optimized files on Azure Storage. In SQL Server 2019 memory-optimized filegroup files can be stored on Azure Storage. Backup/Restore of...
Tag: restore
Some tips for using SQL Server 2019 file and filegroups
Some tips for using SQL Server 2019 file and filegroups Consider placing the tempdb log files on other physical disk arrays than those with the data files. Because logging is usually more write-intensive, it is important that the disk arrays containing the tempdb log files have sufficient disk I/O performance. Set the maximum size of the data and log files....
Troubleshooting SQL Server 2017 backup/restore problems
Troubleshooting SQL Server 2017 backup/restore problems If you have problems with SQL Server 2017 backup/restore, review this troubleshooting checklist to find potential solutions. 1. Check that you have appropriate permissions to make backup/restore. To backup database or transaction log, you should have BACKUP DATABASE or BACKUP LOG permissions granted to you, or you should be a member of the sysadmin...
Tips for using backup and restore in SQL Server 2017
Tips for using backup and restore in SQL Server 2017 Consider storing the backup files on physical disks on another computer. Storing the backup files on the same computer where the databases stores may cause problem with restoring databases if the physical disks were damaged. Try to separate your database to different files and filegroups to backing up only appropriate...
Troubleshooting SQL Server 2016 backup/restore problems
Troubleshooting SQL Server 2016 backup/restore problems If you have problems with SQL Server 2016 backup/restore, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 backup/restore bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article...
Some tips for using backup and restore in SQL Server 2016
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 […]
Troubleshooting SQL Server 2014 backup/restore problems
Troubleshooting SQL Server 2014 backup/restore problems If you have problems with SQL Server 2014 backup or restore, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 backup/restore bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]
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....
Troubleshooting SQL Server 2012 backup/restore problems
Troubleshooting SQL Server 2012 backup/restore problems If you have problems with SQL Server 2012 backup or restore, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 backup/restore bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
SQL Server Database Backups and Recovery Models – (Part 3)
SQL Server Database Backups and Recovery Models – (Part 3) 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 the second part, you learned about various SQL Server backup types,...