SQL Server Database Recovery

SQL Server Error 26: There is more to it than what meets the eye

In this article we dwell in to the possible causes behind SQL Server error 26 The SQL Server database, despite being counted amongst the best software in its class is hardly perfect. As with other software application, it too can falter and throw out error messages. One such error message that you may encounter while working on SQL Server application is error 26. It typically is accompanied by a message which mentions an error in locating the server instance. This error is likely to occur...

Read more »

3 reasons why you should prefer SQL server over MS excel for your small business

In this article we look at 3 key reasons which make SQL Server an apt choice for small businesses over Ms Excel Some small business owners, especially those working in the traditional economy, are usually wary of technology. They are skeptical not only about investing in technology but also in using technology in their businesses. Most of them prefer using it to the minimal extent and prefer sticking to old technology wherever possible. In contrast, majority of small business owners are...

Read more »

Log Shipping in SQL Server – A Primer

In this article we look at the concept of Log Shipping and how it works in SQL Server SQL Server 2016 comes with many high availability options and Log Shipping is one such option. This is actually a technique that incorporates two or even more instances of the server to copy a transaction log file from one server instance to another. As a user, you must note that this unique feature involves not only transferring the log files but also restoring it automatically on different servers. Learn...

Read more »