TheBugSlayer
Programmer
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)
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)