Microsoft SQL Server has become one of the most popular relational database management systems for small and large businesses alike.

Review the list of server database files in the query execution results:.

JOIN (SELECT * FROM sys.master_files WHERE type_desc = 'LOG' ) ldf Log_size = CAST((ldf.size * 8.0 / 1024) AS DECIMAL(8,2))įROM (SELECT * FROM sys.master_files WHERE type_desc = 'ROWS' ) mdf

Upon connection, click “ New Query” and paste the following script into the query field:ĭb_size = CAST((mdf.size * 8.0)/1024 AS DECIMAL(8,2)),.

If you do not want to re-type the password every time you connect to the server, tick Remember password.

In the Authentication list box, choose your SQL Server Authentication method and specify the user credentials.In the Server name text box, type the name of the SQL cluster server.In the Server type list box, select Database Engine.On the File menu, click Connect Object Explorer.Start Microsoft SQL Server Management Studio (MSSMS).How to View SQL Server Database File Locations.

Database visual studio 2017 sql server