Hi All What are the different ways of gaining some space on production environment. 1.Shrinking databases when they are live is not feasible. Can we run maintainance plan job during off peak hours to shrink the live databses, will it be a performance increase or decrease please help. Thanks.
Remove all files that are not needed that might be on the same drives as your databases, like database backups, old log files, etc.
Retriving hard disk space can only be done by deleting unwanted files, because shrinking the database is not a solution because, there must be some heavy logged operations and data inserts performed which neede db to grow. Look at the recovery model, if possible keep it to simple and read about each model in detail in BOL. Better option could be to attach a new drive and shift log or data file onto it
