Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Get Data, Log, Backup, and Binn Directory (SQL Server 2005) Expand / Collapse
Author
Message
Posted Sunday, November 23, 2008 11:44 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 3:42 AM
Points: 99, Visits: 2,212
Comments posted to this topic are about the item Get Data, Log, Backup, and Binn Directory (SQL Server 2005)
Post #607313
Posted Monday, December 15, 2008 8:54 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:08 AM
Points: 316, Visits: 1,117
Hello,

Nice script. I've tested it a SQL server with 6 instances and your code does not product the instance name. It seem to work on default instance only.

I like it.

Rudy



Post #619655
Posted Monday, December 15, 2008 10:23 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 3:42 AM
Points: 99, Visits: 2,212
This is odd as I've just ran it against a named instance and it works as expected.
Post #619793
Posted Monday, December 15, 2008 10:54 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:08 AM
Points: 316, Visits: 1,117
Are you executing this on a SQL server with more than one instance? I've tried on SQL server 64bit as I don't have any 32 bit servers.


Post #619816
Posted Tuesday, December 16, 2008 1:09 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 3:42 AM
Points: 99, Visits: 2,212
Yes. On 32Bit though
Post #620215
Posted Tuesday, December 30, 2008 2:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 2, 2014 4:11 AM
Points: 44, Visits: 148
Hi, this script is a great idea and does exactly what I needed to document some server settings before I apply a change to default data and log values.

I have found a small bug in the script. If the DefaultData value is set but the DefaultLog is not set then the DefaultLog is displayed as the DefaultData value rather than the SQLDataRoot value. This is because the @path variable is no longer null going into the xp_instance_regread for the DefaultLog value. The xp does not find the value for DefaultLog as it is not set, and therefore does not alter the value in @path, but @path is not null as it contains the value from DefaultData set previously.
To fix this I just added a SET @path = NULL before each call to xp_instance_regread

Thanks again.
Post #627169
Posted Wednesday, June 17, 2009 9:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 7:30 AM
Points: 21, Visits: 348
Exactly what I was looking for. I needed a path for automated tracing that the sql agent account had permissions to, and not dump everything in the root of C:\ like my predecessor in SQL 2000. It works on my multiple instance machine SQL2008.

I added the following to get the default errorlog path

SET @path = NULL
exec @returncode = master.dbo.xp_instance_regread N'hkey_local_machine',N'software\microsoft\mssqlserver\CPE',N'ErrorDumpDir', @path output, 'no_output'


Thanks a bunch!



david hay
Post #736742
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse