This procedure is used to shrink the databases. Many times we use shrink option to shrink the databases for backup. and we do it N number of times, when we take the back of databses or make free space of drive.
instructions:- Follwo the step.
1. run script.
2. And execute the statement, exec shrink_databases
I m new, if you found any better option or script then please tell me. I always need ur guidance and help.
Have you ever wished that creating a backup on the fly was easier and quicker? Whether you do it with the GUI or with T-SQL, you still have to open up Management Studio, connect to the database, and go through the steps. You have to figure out ...