Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-09-04 : 06:37:59
|
| Dear All,how can we know the exact size of the database?by using sp_helpdb, my database is showing 83 gb, but the backup of the database is 19 gb.sp_space used is the correct one to get the exact database size? or there is any other best way?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-04 : 06:43:54
|
| http://blogs.techrepublic.com.com/datacenter/?p=292 |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-09-04 : 07:06:42
|
| This script will show you the size of the database files in the database with used and unused space, and show a detailed breakdown of the size of each table in the database.Script to analyze table space usagehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762CODO ERGO SUM |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-04 : 08:26:56
|
| Backup of database will be always less than original db size.You can use sp_databases for it as well. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-09-05 : 02:54:00
|
| thank you very much allArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
database size