Backup file can’t be accessed

If you try to restore a database from a backup (using T-SQL, not the UI) and get the following error, this post may be for you. The media family on device ‘D:Test\Test.bak’ is incorrectly formed. SQL Server cannot process this media family. If you see…

Keyboard shortcuts with SSMS

SQL Server Management Studio allows you to set up custom keyboard shortcuts. These are a huge help, especially if you try out a few examples I’ve listed below. Firstly, you can get to the Keyboard menu from Tools > Options. SELECT TOP 100 If you…