Category Archives: misc

SQL Server Health Check

The automatic SQL Server health check monitoring must collect crucial metrics to diagnose memory, CPU, I/O issues which are needed for proper SQL Server performance. It also has  to have a good set of reliable, accurate configurable alerts which 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 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 notification immediately. Continue reading SQL Server Health Check

SQL Server Backup and Restore Tutorial

In that post let’s talk about one of the primary section 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 in 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 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 SQL Server database from backup is to use SqlBak. And the 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 the way how to backup database SQL, then you can use SqlBak. SqlBak is the simple tool which will make SQL Server database backups and sends them to selected destination. All you need  is to spend few minutes and create a SqlBak backup job. This backup job will make all 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 short list 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 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 is to use SqlBak. So let’s start from the definition what is differential backup? Continue reading What is Differential Backup

Schedule Backup SQL Server 2008 R2

If your locking 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 make SQL Server backups with the help of T-SQL Commands or use SQL Serve 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 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 lets discuss what is a backup? 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