SqlBak Blog - Page 15 of 17 - Backup and monitor SQL Server databases from the web

Learn SQL #4: How to write a SQL query (1)

February 22, 2024March 8, 2014 by Omelchenko Alexander

So, in our previous articles, we introduced you to what is SQL, for what it is used, how it stores data in databases and tables, and how it works through commands (SQL query), and how the commands are different based on what SQL type you use.

Now that we have the overview, we are going to dive into writing our first SQL command, which in technical terms is called a query, as you might already know.

Partial Backups

February 28, 2024March 5, 2014 by Omelchenko Alexander

Partial backups are a type of backup which was first introduced with SQL Server 2005.

These types of backups were designed for use with the simple recovery model in order to improve flexibility in terms of backing up very very large databases that can contain at least one read-only filegroup.

Recover deleted data in SQL Server

February 29, 2024March 5, 2014 by Omelchenko Alexander

If you ever have the misfortune of having data deleted from the production database, don’t get upset as there is a way you can recover most of the missing data with the aid of Transaction Logs and LSNs (Log Sequence Numbers).

Here is a step-by-step solution on how to achieve this.

Back up files and filegroups

February 28, 2024March 1, 2014 by Omelchenko Alexander

This article will go over the topic of how to back up files and filegroups in SQL Server using either SSMS or T-SQL queries.

Continue reading in order to find out why and when you should backup files and filegroups.

Backup History for SQL Server databases

February 29, 2024March 1, 2014 by Omelchenko Alexander

Having a complete backup history of all of your backup and restore operations can become quite useful at times.

All the data that you might need to be related to this, like who created the backup, at what time, on what media, and many other details are stored in the system databases of the SQL Server instance.

SQL Server 2014 for backups

March 1, 2024February 27, 2014 by Omelchenko Alexander

So, SQL Server 2014 CTP2 has been released and now we can have a look at some of its new features before its official commercial release later this year.

What we’re mostly interested in is, obviously, improvements related to backups and restores. Here is a shortlist with improvements.

At the time this article was written only SQL Server 2014 CTP2 was available, so information related to this subject is limited to only what was known from the perspective of the CTP2 edition.

How to schedule a backup cleanup

December 23, 2021February 27, 2014 by Omelchenko Alexander

This post is a continuation of a previous post where we explained how to do a maintenance plan which will take care of creating backups via a schedule. Now that we have a schedule that consistently creates backups, we might want to create a backup cleanup schedule to remove older backup files.

Scheduling SQL server backups: a comprehensive guide

March 4, 2024February 26, 2014 by Omelchenko Alexander

Scheduling the backup operations should be one of the elements that are imperative in the work of any DBA.

This simple action will save you lots of time and effort in the future. Scheduling backups can be done through the visual interface of SQL Server Management Studio (SSMS) as we will see next.

What databases to backup?

February 22, 2024February 23, 2014 by Omelchenko Alexander

Doing backups might become a repetitive and reflex action if done for quite a long time. But due to this, you might skip a few things at the beginning and never add them to your checklist schedule when doing backups.

The following article presents a list of databases to backup and reasons why you should do it.

How to export SQL table to Excel

December 23, 2021February 23, 2014 by Omelchenko Alexander

This article shows three ways of how to move your data from SQL Server table or query to Excel or CSV file.