SHRINK Master database - is this a good idea

We have an old (but very important) production database that has recently started failing. The job history for the backup shows that the problem was with the Master database on that server, which gets backed up at the same time and took 2 days to backup. The Master database is currently 740Mb. We have truncated and dropped a table from the Master database that we know should have been in one of the non system databases. We now think we should shrink the master database. Is there any reason not to do this?  
Blim2Asked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Yes.. You can in case if it occupies more space.
Follow the steps below to shrink your Master database:
1. Right Click Master database in SSMS.
2. Choose Tasks --> Shrink --> Database
3. Specify the target output size of your master db.

Its done. No Issues at all in shrinking a master db.
0
 
Blim2Author Commented:
Thanks, that's reassuring.
How do we estimate/calculate a target output size? Is it better to overestimate or underestimate?
0
 
QPRCommented:
it will tell you the minimum size it can be shrunk to.
best to overestimate growth (if disk space allows) as db growth can be resource intensive and can slow down performance at critical times. Do you have any idea of it's growth pattern over time?
Also good to specify a groth in MB rather than percentage.
10% of 250mb today can become 10% of 1GB in the future.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
There is no definite method to calculate the Master database size.
Install your application along with all sets of Server configurations and find out the size of the Master database and have it as a benchmark.

Here after, shrink the Master database to a size which we have obtained with + 25% tolerance to have an optimarl size.

This size varies for each and every application based on their configurations.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.