Post reply

Default Backup Directory

  • February 22, 2011 at 11:20 pm

    #246103

    Comments posted to this topic are about the item Default Backup Directory

  • February 22, 2011 at 11:27 pm

    #1290226

    Yuppy:-)

    I am the first one to answer. And got it right too.

    This was a learning for me. I googled a bit to get information about this.

    This url is having the info:

    http://www.mssqltips.com/tip.asp?tip=1583

    Thanks for good question.

    Regards

  • February 22, 2011 at 11:47 pm

    #1290233

    Nice and simple question.

    -----------------
    Gobikannan

  • February 22, 2011 at 11:47 pm

    #1290234

    GOOD MORNING ..MORNING I LEARNED NEW TOPIC THANKS..

    Editor: Removed material copied from another source.

  • February 22, 2011 at 11:53 pm

    #1290236

    Good question. Thank you.

    M&M

  • February 23, 2011 at 12:07 am

    #1290241

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 23, 2011 at 1:28 am

    #1290258

    You CAN change the default backup directory using SSMS very easily:-

    - From Object Explorer, right-click on the server and choose Facets.

    - In the Facet dropdown, choose Server Settings.

    - Change the BackupDirectory to your chosen folder.

    No server restart is necessary. You can verify the change by checking the registry key.

    -----
    JL

  • February 23, 2011 at 1:29 am

    #1290260

    Thanks for the positive responses, and a special thanks to SQL Super Star for the additional code.

  • February 23, 2011 at 1:44 am

    #1290264

    James Lean (2/23/2011)

    You CAN change the default backup directory using SSMS very easily:-

    - From Object Explorer, right-click on the server and choose Facets.

    - In the Facet dropdown, choose Server Settings.

    - Change the BackupDirectory to your chosen folder.

    No server restart is necessary. You can verify the change by checking the registry key.

    James is correct in SSMS 2008 you can change in it.

    So unless stated clearly in the question its not SQL 2008 its not valid imho

  • February 23, 2011 at 1:50 am

    #1290266

    James Lean (2/23/2011)

    You CAN change the default backup directory using SSMS very easily:-

    - From Object Explorer, right-click on the server and choose Facets.

    - In the Facet dropdown, choose Server Settings.

    - Change the BackupDirectory to your chosen folder.

    No server restart is necessary. You can verify the change by checking the registry key.

    Oh dear. I had no idea about that. I'd always used the registry in the past as that was the only way I could find to do it, and BOL seemed to back me up.

    I'm not sure if anything can be done to fix the question, but in the meantime I can only apologise for the incorrect answer and explanation.

    Duncan

  • February 23, 2011 at 2:26 am

    #1290273

    Good qUESTIONS..

    I SAW THIS TYPE QUESTIONS VERY RARE

  • February 23, 2011 at 2:39 am

    #1290274

    Following James' observations, I've requested that the question be changed to apply only to SQL Server 2005, and the explanation reworded to add that you can in fact use SSMS 2008 to change the default backup directory.

    Again, apologies to anyone that knew about the Facets method and got the question wrong because of that.

    (No apologies however to anyone that didn't know about that way of doing it and thought you could set it in the same place as the default locations for data and log files ;-))

    Duncan

  • February 23, 2011 at 3:12 am

    #1290281

    I picked a random answer because I was interested to see what the actual answer was...interesting to know!

  • February 23, 2011 at 5:51 am

    #1290318

    SUPER SQL STAR (2/22/2011)

    GOOD MORNING ..MORNING I LEARNED NEW TOPIC THANKS..

    The directories for the default data files, log files and backups are stored in the system registry. As mentioned already you have the ability to change the default data and log directories using SQL Server Management Studio, by right clicking on the server name and selecting properties and navigating to the Database Settings page as shown below.

    ...

    Super SQL Star,

    are you Greg Robidoux and is this your pseudonym here on SSC?

    If you aren't, please give credit to Greg and quote that you copied from his excellent post (http://www.mssqltips.com/tip.asp?tip=1583), as Tejaswili Patil already pointed out.

    Regards,

    Michael

  • February 23, 2011 at 6:22 am

    #1290335

    The question is wrong.

    We can change from SSMS too...

    Why did i got wrong answer???

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

Viewing 15 posts - 1 through 15 (of 34 total)

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