Default Backup Directory

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

  • 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

  • Nice and simple question.

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

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

    Editor: Removed material copied from another source.

  • Good question. Thank you.

    M&M

  • Nice question, thanks.

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

  • 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

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

  • 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

  • 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

  • Good qUESTIONS..

    I SAW THIS TYPE QUESTIONS VERY RARE

  • 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

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

  • 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

  • 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 35 total)

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