MS SQL Server - Initial size for a DB

Author

Initial size for a DB

SalamElias

2006-10-24, 6:28 pm

Hi, how can I know the initial size of a database when it was created. I
thionk when we look in the properties page it is the current DB size and not
the initial size

Thanks

Tibor Karaszi

2006-10-24, 6:28 pm

SQL Server does not store that information anywhere.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"SalamElias" <eliassal@online.nospam> wrote in message
news:8FC5E1A1-43D1-43B0-A091- 6A82023107C8@microso
ft.com...
> Hi, how can I know the initial size of a database when it was created. I
> thionk when we look in the properties page it is the current DB size and not
> the initial size
>
> Thanks

Peter Yang [MSFT]

2006-10-24, 6:28 pm

Hello,

As Tibor mentioned, SQL Server does not store this information. You could
run sp_helpdb or sp helpdb '<database name>' to get information about
databases stored in SQL. You could find the date the database was created
but there is no initial size inforamtion.

If the database is created by using the deafult options from SQL Server,
its initial size is 2 MB (1M for data file and 1M for log file). You may
want to create a new database in EM to see the size on your server.

Also, I'd like to know why you want to get this information and see if we
could find any workaround. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
====================
====================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
====================
====================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.

SalamElias

2006-10-24, 6:28 pm

Because I am setting up a new sql 2005 cluster (consolidation of several
exisiting SQL 2000 servers) ,no doc exist and want to check what initialywas
used for the differnet DBs

Thanks

"Peter Yang [MSFT]" wrote:

> Hello,
>
> As Tibor mentioned, SQL Server does not store this information. You could
> run sp_helpdb or sp helpdb '<database name>' to get information about
> databases stored in SQL. You could find the date the database was created
> but there is no initial size inforamtion.
>
> If the database is created by using the deafult options from SQL Server,
> its initial size is 2 MB (1M for data file and 1M for log file). You may
> want to create a new database in EM to see the size on your server.
>
> Also, I'd like to know why you want to get this information and see if we
> could find any workaround. Thank you.
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ====================
====================
==========
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscript...ault.aspx#notif
> ications
> <http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ====================
====================
==========
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

Peter Yang [MSFT]

2006-10-24, 6:28 pm

Hello,

If you just want to migrate databases from existing 2000 servers to the new
2005 instance, I think the initial size is not so important. You may
consider use detach/attach or backup/restore method to migrate the database
directly. Usually you shall consider transfer logins/passwords before
migrating database:

314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546

224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/?id=224071

240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872

HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/kb/246133/

If you don't want to use data on existing database and need to use new
database, you may want to check the database load and use 1/4-1/2 size of
the current database size and then increate by a fixed size in mb, for
example 100 MB.

Also, please rest assured your feedback on this feature is routed to the
product team. I also encourage you submit via the link below

http://lab.msdn.microsoft.com/produ...ck/default.aspx

If product team hear same voice for the same furture, they may consider
improve/add this new feature. If you have any concerns or questioins on
above information, please feel free to let's know. Thank you!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

====================
====================
=============

This posting is provided "AS IS" with no warranties, and confers no rights.
====================
====================
==============

Sponsored Links