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

Large master database Expand / Collapse
Author
Message
Posted Wednesday, December 05, 2012 8:41 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 1:01 PM
Points: 643, Visits: 3,695
Hello All,

SQL Server 2000 SP4. My master database file is over 1 gigabyte. This seems excessive. I am trying to create some additional disk space. Is this size normal? Can anything be archived or purged?

Thanks
Post #1393056
Posted Wednesday, December 05, 2012 9:18 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 1:01 PM
Points: 643, Visits: 3,695
I found the problem. It looks like user tables were being created in the master database accounting for the large size of master.
Post #1393070
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse