Database Recovery

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 »

How to Deal with Database Context Error 208 in SQL Server

In this article we explain about ERROR 208, why it occurs and how to deal with it. We often come across situations which seem to be very complicated and challenging but are actually very easy to get out of; provided we think logically. One such situation a lot of SQL Server DBA’s come across is the SSMS error 208, i.e. the ‘Invalid Object Name’ error. This is a very commonly occurring error which ends up confusing a lot of DBAs. So today, we will not only provide you with a solution to...

Read more »

How to Run SQL Server 2017 on Linux

Learn more about SQL Server’s extension to Linux Platform and how was it done! SQL Server 2017 has extended its availability for Linux Platform recently and it has become the talk of the town since the day it was announced. Microsoft’s move to integrate Linux platform with SQL proves that Microsoft is sincere on its front for being an open source oriented company and according to the company the move was however essential as they no longer wanted to limit their customers to windows for...

Read more »