This is likely the last in a series of three posts about backups and restores. My aim with this series has been to give you an idea of the options available and a basic start on using those options. I’m not trying to go in-depth on the subject of backups and restores.
Today will be about getting you going on the concept of restoring databases in SQL Server. I’m using a local install of SQL Server 2017 on my desktop PC to demonstrate these techniques.
In an earlier post I listed three tips for using the SQL Server Management Studio user interface. I want to offer three additional tips for SSMS. I think you will find that these ideas will bring additional efficiency and functionality to your use of the interface.
The first tip is related to getting more viewing space after running a query. Query results obviously take up the bottom portion of the SSMS editor window. I have often found myself then clicking in the query editor window and scrolling to view various parts of my query, all the while the results portion of the screen is using a good portion of the window. Some time back an associate told me how to easily address that annoying issue. Simply click CTRL and R to collapse the query results so that the full page is again used for viewing the query text.
You’ve been using SQL Server Management Studio for a long while now, but you mostly only using the New Query window to write T-SQL and the Object Explorer to do management tasks for an instance. You know it can do more, but you are a busy data professional. You don’t have a lot of time to poke around in the options and you’re not sure where to look or what else it can do to make your life easier. In this post I will cover three SQL Server Management Studio options that will save you time and make you more efficient.