SQL Server backups are an essential part of every good disaster recovery strategy. That is good. But setting up such backups to run effortlessly, is the goal. In this article, we’ll review the types of backups, recommended practices and three different methods for automatically setting up SQL Server backups on a schedule. Note: these solutions can also be used in combination with one another
Read more »Robert Seles
Robert is a SQL Server and IT enthusiast with many years of experience as a computer repair technician.
He has a great passion for new technologies, science, video games, and medieval history. He also likes reading, writing, and learning new languages.
Robert is currently working for ApexSQL LLC as Software Sales Engineer where he specializes database backups and indexes.
View all posts by Robert Seles
He has a great passion for new technologies, science, video games, and medieval history. He also likes reading, writing, and learning new languages.
Robert is currently working for ApexSQL LLC as Software Sales Engineer where he specializes database backups and indexes.
View all posts by Robert Seles
Latest posts by Robert Seles (see all)
- Multiple methods for scheduling a SQL Server backup automatically - July 17, 2018
- Ola Hallengren’s SQL Server Maintenance Solution – Index and statistics maintenance - January 23, 2018
- Ola Hallengren’s SQL Server Maintenance Solution – Database integrity check - January 10, 2018
Ola Hallengren’s SQL Server Maintenance Solution – Index and statistics maintenance
January 23, 2018This is the third article in Ola Hallengren’s SQL Server Maintenance Solution series. The article will cover the IndexOptimize stored procedure in more detail, along with the index optimization jobs created by Ola Hallengren’s scripts.
Read more »
Ola Hallengren’s SQL Server Maintenance Solution – Database integrity check
January 10, 2018This is the second article in Ola Hallengren’s SQL Server Maintenance Solution series. It will cover the jobs for database integrity, backup history cleanup and job history cleanup. The installation of Ola Hallengren’s Maintenance Solution is covered in the first article in the series: Ola Hallengren’s SQL Server Maintenance Solution – Installation and SQL Server Backup solution
Read more »
Ola Hallengren’s SQL Server Maintenance Solution – Installation and SQL Server Backup solution
December 5, 2017Database administrators tend to use various scripts or applications, to make the daily SQL Server database maintenance task easier.
Some more experienced administrators prefer to design and use their own scripts for these tasks. The scripts are usually designed to fit the requirements imposed by the specific environment. After the scripts are thoroughly tested, they often get included in a maintenance plan, or SQL Server agent job to automate their execution. Such solution is usually optimal for some demanding environments like high traffic servers or databases that are still in development. Designing these solutions usually take time, and require an experienced DBA skilled in T-SQL or PowerShell scripting.
Read more »Installing SQL Server 2016
June 7, 2016Introduction
Microsoft SQL Server 2016 provides faster transactions and queries, deeper insights on any device, advanced analytics, new security technology, and new hybrid cloud scenarios. Along with these features, comes the new installation setup. Although it is similar to the installation of SQL Server 2014 and other older versions, there are few notable differences:
Read more »