SQL Server Database Recovery

Why You Need to Safeguard Data Present in Your SQL Server Backups

Learn about the common risks and problems that your backed up data is facing, and how to deal with them. Backing up data in SQL Server is surely something that you should do unfailingly, but that is not all that you need to do to keep data safe. Ensuring the safety of data in the backup is also an important point to consider. For all the different backup options that are available to you in SQL Server, you also need to keep in mind that they are being stored in clear text format, which can...

Read more »

6 Real World Tips to Keep Your MS SQL Server Database Healthy

Learn how to maintain the health of your SQL server database with these quick and simple tips. As a SQL Server DBA, you need to make sure that your database is always in the best of health. This might seem like something challenging, but is technically something that does not take up too much time and energy, provided you perform certain activities regularly. Much like we as humans monitor our health regularly, we also need to monitor the health of our database regularly. This can be done...

Read more »

In-depth Study on Compressed Backups in SQL Server and Its Storage Needs

In this article we learn about compressed backups in SQL Server and compare them with Trace Flag In SQL Server 2008 and all its later editions, users are given access to what is called the compressed backup. Meaning once you backup your database you can also compress it to reduce the amount of space it occupies. But this is something a lot of SQL users or DBAs would already know, in this article we would be discussing how exactly are compressed backups created with a predefined initial...

Read more »