sql server - Script to change the SQL Default database location in windows

Question

Can someone help me with any script like windows script, BAT script or SQLcmd script for changing the default database location of SQL.

I am using Windows

question from:https://stackoverflow.com/questions/65926796/script-to-change-the-sql-default-database-location-in-windows

Answer 1

Not sure if it will fit to SQL Server 2005 as I use 2017 Express on my laptop, but give it a try...

USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'DefaultData', REG_SZ, N'C:DATA'
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'DefaultLog', REG_SZ, N'C:DATA'
GO