Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
How can I change the default location for database files that SQL creates?
Neil Pike
November 28, 1999
1 Min Read
A. Change/add the following registry keys :-
KEY: HKLMSoftwareMicrosoftMSSQLServerMSSQLServer
VALUE: DefaultData
VALUE: DefaultLog
Just put in a directory name (no trailing backslash) for these.
This works only for databases that you create with the CREATE DATABASE statement, not for databases created from Enterprise Manager.
(Answer courtesy of Kalen Delaney)
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)