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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 master db maximum size

Author  Topic 

phani.m
Starting Member

2 Posts

Posted - 2010-07-28 : 06:54:26
can any one tel me the master db maximum size??

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-28 : 07:02:27
500 000 TB or so, same as any other database. Since nothing should be created in there, it should never grow to more than a few hundred MB.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-07-28 : 10:54:41
"Since nothing should be created in there ..."

<BaitedBreath>
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-28 : 11:51:24
I heard once of a vendor system that installed all its objects in master and had no user database.
Ran away screaming.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -