Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to find initial size of the database file and log file in sql server? Expand / Collapse
Author
Message
Posted Thursday, February 18, 2010 4:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 24, 2010 8:14 AM
Points: 1, Visits: 9
For SQL Server 2000, i want to find the initial size of the database file and the transaction log file. How do i find it?

In the enterprise manager-->DB properties the initial size label is misleading, it shows the current size of the db, but not the initial size.

I tried searching for answers on google and this forum but did not find anything.

Regards,
Ashish
Post #867903
Posted Friday, February 19, 2010 7:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 5:21 AM
Points: 428, Visits: 928
In SQL Server, each new database created is a copy of the model DB.
This applies to tables, stored procedures, and file sizes.

So if you want every new DBs to be 100 data / 50 log, set the model db to 100 data / 50 log.

P



Post #869063
Posted Tuesday, August 21, 2012 6:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:53 PM
Points: 5, Visits: 25
In views\systemviews for your database there is a sys.sysfiles view that contains that information.t in SQL Server 2008. Previous versions I'm not sure about.
Post #1348144
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse