Post reply

Default Log Directory

  • November 1, 2008 at 10:47 pm

    #94688

    HI, I need some help with a problem. My Server's audit logs are not saved in the new location even though I have changed the location to the new directory though my sql server's properties-database settings and restarted the sql server.

    I've also checked the registry key "Default Log" in "...\HEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer", and the value matches the new directory which is "G:\", the original log path was "F:\MSSQL\LOG"

    Thanks in advance

  • November 2, 2008 at 2:26 am

    #892791

    Hi Bob,

    Which log-file is it that you want to change the location for? You mention Audit Logs - are you referring to the Default Trace that runs and captures trace data?

    The option you changed, specifies which directory NEW transaction logs should go - it will not change anything existing.

    So, to change the location of:

    1. Existing transaction log

    See "Moving Database Files" in BoL (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/89f01b10-5fae-4ed8-b0fb-a4b9f540fd28.htm).

    2. The audit trace files

    http://msdn.microsoft.com/en-us/library/cc297240.aspx

    3. Errorlog

    A Startup Parameter has to be changed in SQL Server Configuration Manager

    HTH!

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • November 4, 2008 at 1:34 am

    #893466

    Thanks for the help, the one I needed help with was with the errorlog. I've changed the errorlog directory by changing the startup parameters but then that reminds me of what I originally did, changing the default log directory, does anybody know what does the default log directory store?.

    Thanks in advance again.

  • November 4, 2008 at 7:33 am

    #893615

    Hi Roger,

    As I believe I mentioned... ;), you changed the Default Directory for new transaction logs.

    So when will this have an effect?

    Only when you create a new database without specifying where you want to put your transaction log.

    HTH!

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • November 5, 2008 at 11:41 am

    #894453

    Thanks a lot :D, I must have missed that, sorry for having you to reply again.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply