LOG directory change - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

LOG directory change

Author

Topic

dennisx2002x
Starting Member

2 Posts

Posted - 2011-05-06 : 10:21:03

Hey all,

can somebody tell me, how I can change the path of the log-directory from SQL Server Agent created Log Files?

standart dir is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

and it should be for example C:\Logs\SQLSA
SP4 installed!

Thx

dennisx2002x
Starting Member

2 Posts

Posted - 2011-05-06 : 10:22:32

Sorry wrong Forum, it is version 2005 not 2008, please transfer the Topic

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-05-06 : 10:33:37

Open SQL Server Configuration manager.
Choose SQL Server Services in the left pane
Right Click SQL Server in the right pane
Click properties
Go to the adanced tab
Change the path of the logs in the startup paramaters.

BE VERY CAREFUL If you make a mistake, your SQL Server won't start! This tool modifies the startup params in the registry.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources