Solved

database size in sql2005

Posted on 2006-10-24
6
304 Views
Last Modified: 2012-08-13
Hi,
I would like to know how can I checking the database size and also unallocated space in sql2005? I don't see the indicator exits in studio mgmt as like EM does, I know that we can use sp_spacedused but this will only result with databse size and unallocated space  in general,
what I want is specifc database size on verey data file or log file create
0
Comment
Question by:motioneye
  • 2
  • 2
6 Comments
 
LVL 20

Expert Comment

by:Sirees
Comment Utility
<<what I want is specifc database size on verey data file or log file create>>

Rightclick on database->Properties->Files
0
 
LVL 20

Expert Comment

by:Sirees
Comment Utility
Contd..

Under intial size column you get the file size

When you click the button in the Autogrowth column, you get more info
0
 

Author Comment

by:motioneye
Comment Utility
sorry sirees,
U are not answering my questions.

OK if let says in sql2000 EM I right click- view-taskpad and there I can see the db properties and there is an indicator showing data size on every specific data file with used space and unallocated space. I had try ur solution and its only show me whther the file is autogrowth enable or not and it doesn't show any unallocated space at data file
0
 

Author Comment

by:motioneye
Comment Utility
Hi,
I've got it, the indicator is actually reside in Summrary, click at respective db - scroll down summary -- disk usage.
0
 
LVL 1

Accepted Solution

by:
kodiakbear earned 0 total points
Comment Utility
Closed, 500 points refunded.
kb
Experts Exchange Moderator
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL Bulk load data error 5 33
SQL Server 2016 Developers Edition Install 4 55
SQL Date Retrival 7 21
Test a query 23 10
Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

763 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

9 Experts available now in Live!

Get 1:1 Help Now