Tag Archives: microsoft sql server

Evaluation On SQL Server Database Backup Retention Periods

Introduction SQL Server is a database management system with the primary aim of storing and retrieving data from the databases. The data stored in the database are not safe always, can be lost either due to virus infection, bad sector … Continue reading

Posted in Risk Management | Tagged , | Leave a comment

Difference Between Deadlock And Blocking In SQL Server

Introduction Deadlock and Blocking in SQL Server are two familiar terms seen in SQL Server. But, many are getting confused with these terms in the SQL Server. The users get messed up with these though they are not the same. … Continue reading

Posted in Error directory | Tagged | Leave a comment

SQL Server 2014 Health check DMV queries Day 2

This gallery contains 1 photo.

Hi guys in the Previous post i explained How we can get the SQL Server instance version and How we can know the installed date for SQL Server instance put today is DAY 2 and i will show new DMV in … Continue reading

Gallery | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Preview Release of the SQL Server PHP driver

Preview release of the SQL Server Driver for PHP is now available. Find out how it will help developers access Microsoft SQL Server and Microsoft Azure SQL Database. Get it now! http://cic.ms/NzhI9z

Gallery | Tagged , , , | Leave a comment

High Availability in Microsoft SQL Server 2012

This gallery contains 1 photo.

Down or Up the ? Is. The main goal of a high availability solution is to minimize the impact of downtime. A sound strategy for this optimally balance business processes and SLA (Service Level Agreements) with technical capabilities and infrastructure … Continue reading

Gallery | Tagged , , , | Leave a comment

Download the Evaluation: Microsoft SQL Server 2014

To download SQL Server Evaluation Ms SQL Server 2014 click here Microsoft SQL Server 2014 Evaluation Resources

Posted in SQL Server 2014 | Tagged , , | Leave a comment

Alter failed for Database – Unable to open the physical file

This gallery contains 1 photo.

Alter failed for Database ‘MFA’.  (Microsoft.SqlServer.Smo) —————————— ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————— Unable to open the physical file “F:\databases\MFA.mdf”. Operating system error 5: “5(Access is denied.)”. Unable to open the physical … Continue reading

Gallery | Tagged , , , , | Leave a comment