Rename logical & physical MSSQL files

This post will provide guidance on how to amend the logical and physical file names of a MSSQL database.When a copy of a database is restored as a new database, the logical file names will remain the same as the source database.Firstly, check the current logical and physical file names: USE master GO SELECT name AS [Logical_name], physical_name AS [File_Path], […]

Value cannot be null

After issues with my laptop not being able to find critical files this morning I managed to boot to the last know good configuration. This seemed to have got me past all the errors I previously had, however, I noticed that things weren’t quite right. When attempting to open SQL Server Management Studio (SSMS) 2012 I received the error “Value […]

SQL Server Central Management Server (CMS) Intro

Introduction Central Management Server (CMS) was first introduced in SQL Server 2008, it enables simplified management of multiple MS SQL database servers and instances. My screenshots are taken from SQL Server 2012 but should be relevant in SQL 2008 and 2008 R2 as well. If you are managing more than a couple of SQL instances you’ll already be aware of […]