QuestionHow do I move the database files from one drive or folder to another?
Answer
To move the database files from one drive/folder to another follow the steps (example uses the RS database):
- Stop the Altiris Client Recovery Server service.
- Set the AeXCRDatabase to single user.
exec sp_dboption AeXCRDatabase, ‘Single User', True
- Get current database file location.
exec sp_helpdb AeXCRDatabase
You need the DBFile and LogFile paths.
- Detach the database.
exec sp_detach_db ‘AeXCRDatabase' , ‘true'
- Move the database and log files to the new location with Explorer.
- Reattach the database with the new locations.
exec sp_attach_db ‘AeXCRDatabase'
'<path>\<database file name.mdf>',
'<path>\<database file name.ndf>',
'<path>\<database log file name.ldf>'
- Restart the Altiris Client Recovery Server service.