How to migrate the data directory for MSSQL Server?

Posted by Ryan on Server Fault See other posts from Server Fault or by Ryan
Published on 2011-02-03T22:47:17Z Indexed on 2011/02/03 23:27 UTC
Read the original article Hit count: 290

Filed under:

I have an installation of MSSQL where I would like to move the data directory to another drive so that all the existing databases are located there and all new databases are created there, as well as the backups, logs, etc. I know I can detach/attach the existing databases, but what about the rest of the settings (backup, new databases)? Is this possible without an uninstall/reinstall? Thank you.

© Server Fault or respective owner

Related posts about sql-server