Database Recovery

Using SQL Server Express Edition as a production server – completely feasible and ideal for small to many mid sized firms

In this article we explore the possibility of using SQL Server Express edition as a true production server and contemplate its limitations The SQL Server database has different editions designed for different needs. Of these the Express edition is specifically tailored for smaller workloads. The fact that it is completely free makes it immensely useful for many small to midsized firms. While there is a reasonable limit on database size, the application can be safely used for commercial...

Read more »

Understanding Database Mirroring available in SQL Server in Depth

In this article we dwell on the concept of database mirroring in Ms SQL Server and understand the different available modes. When it comes to databases that are accessed by thousands of people, it is very critical to build in redundancy and facilitate continuous availability. In SQL Server, database Mirroring is used to achieve the same by using two database instances simultaneously. The first instance, also known as the principal has its data mapped into a backup instanced called the...

Read more »

SQL Server Backup Options: A Quick Roundup

In this article, we take a quick look at the several options available in MS SQL Server The SQL Server database is today counted as one of the best applications in its class. One of the key reasons behind its popularity is its robustness and backup features which enable business continuity.  Data backups are necessary to protect loss of data from many hazards like hardware malfunction, natural calamities or flaws related to media. Prominent backup options available in SQL Server Full...

Read more »