WeChat-Image_20210412111831

6 Ways to Check the Size of a Database in SQL Server using T-SQL

If you’re using a GUI tool, such as SSMS to manage your databases, you can easily check the size of your database by clicking your way through the GUI (right-click the database, point to Reports, then Standard Reports, and then click Disk Usage). However, if you prefer to use T-SQL to manage your databases, you’ll need to run a query that returns this […]

WeChat-Image_20210412111831

Backup and Restore a SQL Server Database On-premises

In this quickstart, you will create a new database, take a simple backup of it, and then restore it. Prerequisites To complete this quickstart, you will need the following: SQL Server SQL Server Management Studio (SSMS) Create a test database Launch SQL Server Management Studio (SSMS) and connect to your SQL Server instance. Open a New Query window. Run […]