Shrink Multi-File Databases
This stored procedure shrinks all database files within the current database, including the unused portion of transaction log. This procedure is especially useful for multi-file databases.
2003-03-24
195 reads
- Interests: My true passion are my kids and supporting the local music scene in Jacksonville, Florida. I am also the President and Founder of a non-profit corporation that supports the local music scene in Jacksonville and North Florida.
Blogs
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but...
Forums
Running Trace - Error: Login timeout expired
Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...
query perf issue
Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...
Looking for some guidance on avoiding Scalar UDFs for DB lookups
Hello. I am not a SQL Developer - just an IT generalist (if that)...
Ask SSC