Solved

Find  SQL Server Database  unused  space , data used & Log used

Posted on 2014-03-05
2
866 Views
Last Modified: 2014-03-31
How to find a space information for SQL Server Database

Unused Space:
Data used:
Log Used:
0
Comment
Question by:Varshini S
2 Comments
 
LVL 4

Assisted Solution

by:ravikantninave
ravikantninave earned 250 total points
ID: 39907701
EXEC sp_spaceused
0
 
LVL 2

Accepted Solution

by:
ssmith81 earned 250 total points
ID: 39912088
Hi Rubha,
To check log space, DBCCSQLPERF should work fine.
To check used/unused space, Disk usage summary report would be helpful for you.


*Advertising removed by Netminder 31 Mar 2014*
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video discusses moving either the default database or any database to a new volume.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now