SQL Server 2012

The specified cast is not valid. (sqlmanagerui)

In this post, we’re gonna solve the specified cast is not valid. (sqlmanagerui) error that occurs when you trying to restore a database from SQL Server 2012 to an earlier version. You might also like to read Database was backed up on a server running version 13 The specified cast is not valid. (sqlmanagerui) In …

The specified cast is not valid. (sqlmanagerui) Read More »

Rename SQL Server database: The database could not be exclusively locked

In this post, we’ll learn how to fix “The database could not be exclusively locked to perform the operation” error that you may encounter when renaming a database in SQL Server. You might also like to read Database is not accessible due to a Single User mode The database could not be exclusively locked to …

Rename SQL Server database: The database could not be exclusively locked Read More »

Download and Install SQL Server 2012 Upgrade Advisor

In this post, we will learn how to Download and Install SQL Server 2012 Upgrade Advisor? What’s SQL Server 2012 Upgrade Advisor? Perhaps the most important tool of the tools typically used for upgrade planning is SQL Server 2012 Upgrade Advisor. Upgrade Advisor smooths the transition to SQL Server 2012 by predicting issues in your …

Download and Install SQL Server 2012 Upgrade Advisor Read More »