Friday, March 23, 2012

how to change default system database location after install of ssql express?

don't like the default location being in c:\program files\Microsoft SQL Server\MSSQL.1\If you want to move the system databases you will have to suhtdown the service, move the system database files and change the appropiate settings in the registry. Then you will be able to start the service again.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\Parameters

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||thank you very much. I was not able to find parameters under mssql.1 but under .3

No comments:

Post a Comment