Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Moving SSISDB from C:\ to a different drive. Advice needed.

Status
Not open for further replies.

TheBugSlayer

Programmer
Sep 22, 2002
887
US
Hi all.

All my user databases are not created on C:\. I had forgotten SSISDB and now the drive is running out of space and I need to move it. This being a system DB and me being relatively new to SQL Server 2012 and not having ever performed this task I suspect there are gotchas to be aware of. Is there anything I should be aware of? This being a move on the same server I am thinking there is no need to backup and restore the master key.

Your advice is greatly appreciated.

Thank you!

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)
 
Nothing special. I did it the way I would any other database. This is because SSIS was already installed on the server.

Thank you!

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top