• we have a PROD DB which is about 300Gig, however we are only using 50%.

    Shrinking the DB will probably have some slight benefit to our backup process, but more importantly will make it easier to restore the DB on local servers

    we need a script that will shrink a small amount of the DB, and schedule it to run every night so that we can see period decreases in size