Home Forums SQL Server 2005 T-SQL (SS2K5) Default mdf/ldf directory at the server level RE: Default mdf/ldf directory at the server level

  • May 15, 2013 at 3:33 pm

    #1615576

    BACKUP default directory

    http://www.sqlservercentral.com/Forums/Topic1319398-1550-1.aspx

    /*

    In case it was not clear in Jason's post, the @key parameter value remain consistent

    across all of your instances. The proc he is calling does proper registry resolution

    for us depending on the instance we run it from. That is the beauty of master.sys.xp_instance_regread, as opposed to master.sysxp_regread

    which requires the literal path to the registry location you want.

    If you were using master.sys.xp_regread your calls would need

    to be different across all of your 5-10 instances.

    */

    EXECUTE [master].dbo.xp_instance_regread

    N'HKEY_LOCAL_MACHINE',

    N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!