November 22, 2011 at 8:18 am
Will there be any downtime needed to do the following operation? Can the end users run their reports while this is running?
DBCC SHRINKFILE ('<logical file name>', EMPTYFILE )
November 22, 2011 at 9:49 am
No downtime, but you could experience a performance degradation and blocking while the command runs.
-- Gianluca Sartori
November 22, 2011 at 10:07 am
It is a shared server. Would it have an effect on the server or just the database?
November 22, 2011 at 10:18 am
It's an I/O intensive operation, so I guess it will affect the whole server.
-- Gianluca Sartori
November 22, 2011 at 10:18 am
Generally, it will. However, if you have 8 cores with 48 GB of memory and databases are on several spindles, you will not see much degradation.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply