Category Archives: Miscellaneous

SQL Server Health Check

The automatic SQL Server health check monitoring must collect crucial metrics to diagnose memory, CPU, I/O issues that are needed for proper SQL Server performance. It also has to have a good set of reliable, accurate configurable alerts that will tell us if the failure occurs. Of course, you can create your own set of scripts and run them every time you need to check the working state of your SQL server. But the easiest way is to use the SQL Server health check from SqlBak. It will make all crucial checks for you, collect the statistics, and, if something goes down, will send the email notifications immediately. Continue reading SQL Server Health Check

SQL Server Backup and Restore Tutorial

In that post, let’s talk about one of the primary sections in the daily life for each DBA this is SQL Server backup and restore tutorial. The greatest way to backup and restore your SQL Server database is to apply SqlBak. Using SqlBak, you can be sure that your SQL Server database is safe. Below you can find simple SQL Server backup and restore tutorial.

Continue reading SQL Server Backup and Restore Tutorial

SQL Server Restore Database from Backup

SQL Server restore a database from backup – how to do it? This is one of the crucial questions related to SQL Server. In this article, we are going to show you two ways how you can do it. The first and the easiest way to make the SQL Server database from a backup is to use SqlBak. And second – you can use standard T-SQL Commands to restore your SQL Server. Continue reading SQL Server Restore Database from Backup

How to Backup Database SQL

If you are looking for a way how to backup database SQL, then you can use SqlBak. SqlBak is a simple tool that will make SQL Server database backups and sends them to the selected destination. All you need is to spend a few minutes and create a SqlBak backup job. This backup job will do all the backup work for you. In this topic, we are going to discuss how to backup database SQL and what actually is SQL Server backups.  Continue reading How to Backup Database SQL

Backup and Recovery Best Practices

If you are looking for backup and recovery best practices, then this article is for you. The best and the easiest way to backup and restore your databases is to use SqlBak. If you are reading this article, it means that you already know the crucial role of SQL Server database backups. Scheduled backups are the best way to protect your SQL Server database from the disaster. Bellow, you can find a shortlist of backup and recovery best practices. Continue reading Backup and Recovery Best Practices

What is Differential Backup

In this blog post, we are going to discuss what is a differential backup and how to perform a differential backup with the help of SqlBak. It is well known that you can perform SQL Server database backups with the help of T-SQL Commands and SSMS (SQL Server Management Studio), but the easiest way to make full, differential, and transaction log backups are to use SqlBak. So let’s start from the definition of what differential backup is? Continue reading What is Differential Backup

Schedule Backup SQL Server 2008 R2

If you are looking for a way to make schedule backup SQL Server 2008 R2, then use SqlBak. This simple tool will make SQL Server database backups according to your schedule. Nowadays, there are three most common ways to make schedule backup SQL Server 2008 R2. You can create SQL Server backups with the help of T-SQL Commands or use SQL Server Management Studio. But the easiest way is to us SqlBak. All you need is a few minutes to create a SqlBak backup job. The backup job will make a schedule backup SQL Server 2008 R2. Continue reading Schedule Backup SQL Server 2008 R2

SQL Server Backup Schedule

You need to create SQL Server backup schedule with the help of SqlBak to keep your database safe and sound. From the beginning, let’s discuss what a backup is? Quite frankly talking, a database backup is a representative duplicate of data. When you lost your backups, you can use the backup to rebuild destroyed records. It duplicate contains crucial elements of your database, such as the managed file, archive logs, and datafiles-structures described later in this section. In the occasion of a media failure, your database backup is the key to properly recovering your information. Continue reading SQL Server Backup Schedule