Home > IT Answers > SQL Server > SQK Server 2000 Database Size
Oradba13
0 pts.
 SQK Server 2000 Database Size
SQL Server
I am an Oracle DBA starting to learn SQL Server (as I am sure many are). I have databases that show a lot of free space when I look at Taskpad view. I read that a database cannot be shrunk below it's original creation size, how do I find that original creation size?

Software/Hardware used:
ASKED: May 19, 2004  4:17 PM
UPDATED: June 4, 2004  1:12 PM
RELATED QUESTIONS
Answer Wiki:
One cheap way: in Query Analyzer, right click the database name -> Script to New Window -> Create. Wow, that's really cheesy, but it does work. I'm sure there's a sys table with this info though.
Last Wiki Answer Submitted:  May 19, 2004  4:40 pm  by  Hopkihc   0 pts.
All Answer Wiki Contributors:  Hopkihc   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

If the db option has been set to automatically grow, you can’t really determine the original size (unless the original DDL was saved somewhere, or you have access to the db’s first backup–the latter would be a rough estimate).

In any event, the original size is irrelevant; a defragmented db can’t be shrunk below the total size of its used data pages.

MisterMac
 0 pts.