How can I set "Database Default Location" during unattended sql server installation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » How can I set "Database Default Location"...

How can I set "Database Default Location" during unattended sql server installation

Rate Topic

Display Mode

Topic Options

Author

Message

egpotus

Posted Thursday, April 16, 2009 2:26 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:04 AM
Points: 120, Visits: 955

hi,

Is there a way to set "Database Default Location" during unattended sql server installation ?

(Database Default location can be displayed in "Database settings" in Server Properties)

Kindest Regards,

egpotus DBA

Post #698210

MarkusB

Posted Thursday, April 16, 2009 2:57 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:22 AM
Points: 4,218, Visits: 3,875

You have to use the INSTALLSQLDATADIR parameter. Problem is that this will only accept one directory for data and log files.
In case you want to have separate loctions for data and log I would advise run a post install script.
For Datafiles:
EXEC master..xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',N'DefaultData', REG_SZ,'D:\MSSQL.1\MSSQL\DATA\'

For Logfiles:
EXEC master..xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',N'DefaultLog', REG_SZ,'E:\MSSQL.1\MSSQL\LOG\'

Markus Bohse

Post #698225

egpotus

Posted Thursday, April 16, 2009 3:10 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:04 AM
Points: 120, Visits: 955

thank you

Kindest Regards,

egpotus DBA

Post #698231

« Prev Topic | Next Topic »

Permissions