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 Read More
Category: SQL
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 Read More