SQL Server Database Recovery

5 Main Functions of the Transaction Logs in SQL Server

In this article we look at the key functions of transaction logs in SQL Server Transaction Log, as the name suggests, keeps a log of all the transactions that are taking place; along with the database modifications it’s making each day. It is one of the most crucial element in your database, in case of any system failure it brings back database to a consistent condition. You should never opt for deleting or moving your transactions log unless you are not completely sure of its...

Read more »

Understanding the Types of Failovers in SQL Server AlwaysOn Availability Groups

In this article, we look into failover options present in AlwaysOn Availability groups in MS SQL Server In layman’s terms, AlwaysOn Availability Groups can be considered as a form of disaster recovery solution which also helps in increasing the availability of database. Availability Groups support failovers in SQL Server. And it is important to note that failovers are not caused due to any issues with database, such as corruption or unavailability. The failover environment is supported by...

Read more »

How to Implement SQL Server with a Private Cloud – A Primer

In this article we check out why it makes sense to implement SQL Server with a private cloud solution Using disk storage, off-site premises, or even Azure Cloud for storing SQL Server data is old school. Private Cloud for storing SQL Server data is the new storage trend. There is now a distinction being created between a public cloud and a private cloud. This is currently what the IT industry is clouded by. Although the trend of private cloud storage hasn’t really gained momentum yet, it...

Read more »