Solved

SQL 2005 Can you run shrink on the master database

Posted on 2013-11-07
2
586 Views
Last Modified: 2013-11-07
SQL 2005
Can you run shrink on the master database

someone moved some tables in there by mistake we have moved them out but still shows at 8gig  I am pretty sure just white space

Thanks
0
Comment
Question by:cmcdonald007
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Accepted Solution

by:
dannygonzalez09 earned 500 total points
ID: 39631461
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 39631757
you need to figure out why your masterdb is so big ? it shouldn't growing so big unless the developers by mistakenly creating the db objects and populating them..
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question