Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1353
  • Last Modified:

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?  
0
Blim2
Asked:
Blim2
  • 2
1 Solution
 
Raja Jegan RSQL 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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now