SQK Server 2000 Database Size

pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • MisterMac
    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.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following