Here is a question for the sys ops out there (or those who have gone through this experience before).
My company wants to allocate additional disk space on existing SQL Server boxes in production. We are wondering whether extending a volume ("Extend Volume..." in Disk Management) can be done ONLINE or whether the SQL Server Service needs to be shut down.
Any reason why SQL Server Service should be stopped to do this or is it OK to just go an perform this operation during the day?
Just in case the system specs are relevant. This is a real box (no virtualization) running Windows 2012 R2 and SQL Server 2008 R2.