Database Administrators Asked by Jac on January 24, 2021
I have a SQL 2016 instance installed. It has SSISDB for SQL server integration services installed.
Now because it is taking up all the space on our system drive, I need to move its data and log files to a separate disk. To do that I will need to take the db offline.
Is there any repercussions you guys can think of after taking it offline. I have coordinated a time with application guys already.
It is more or less the same as moving the data files for a user database, but you can follow the steps in the documentation To Move the SSIS Database as it has some additional good precautions noted:
Follow the instructions for moving user databases. For more information, see Move User Databases.
Ensure that you back up the master key for the SSISDB database and protect the backup file. For more information, see To Back up the SSIS Database.
Answered by LowlyDBA - John McCall on January 24, 2021
There are no big concerns with taking it offline as a part of moving it. I've performed this action a couple of times in the past and encountered no issues.
Answered by Nic on January 24, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP