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 «««1234»»

Default Backup Directory Expand / Collapse
Author
Message
Posted Wednesday, February 23, 2011 7:38 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, October 16, 2014 11:48 AM
Points: 3,958, Visits: 3,644
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.


Thanks James, I did not know you could change it from SSMS.
Post #1068266
Posted Wednesday, February 23, 2011 8:20 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:56 AM
Points: 3,352, Visits: 1,487
SKYBVI, Lady Di, MG-148046 and anyone else who picked SSMS because you can do this in 2008:

In case you haven't read my previous posts, I apologise for the question - it should have specified SSMS 2005, and I have emailed the webmaster to ask for it to be changed. Not much more I can do for now I'm afraid

Duncan
Post #1068301
Posted Wednesday, February 23, 2011 8:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 25, 2013 7:43 AM
Points: 1,384, Visits: 644
easy one today
thanks



Post #1068318
Posted Wednesday, February 23, 2011 8:43 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 6:14 AM
Points: 1,200, Visits: 3,237
Duncan Pryde (2/23/2011)
SKYBVI, Lady Di, MG-148046 and anyone else who picked SSMS because you can do this in 2008:

In case you haven't read my previous posts, I apologise for the question - it should have specified SSMS 2005, and I have emailed the webmaster to ask for it to be changed. Not much more I can do for now I'm afraid

Duncan


Thanks Duncan
btw, you made us afraid before :)

Regards,
Sushant
Post #1068325
Posted Wednesday, February 23, 2011 9:02 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
First let me say I only got the question right because I know someone that works at M$.
Second let me say that I have no idea if this question is still on the M$ database exams becuase it is so controverted.

The exam question used to be how do you set the default backup directory.
The correct answer was only during installation.
It was said the other "correct answers" were wrong becuase manual registry updates to change a policy settings was not supported.

Unfortunately it actualy can be done by updating the registry and with the FACETS management object for updating policy objects. Does not even have to be done in SSMS if you know how to call it from code.

Shame that M$ support does not properly document the Policy Update or FACETS utility.
Post #1068342
Posted Wednesday, February 23, 2011 9:04 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
The Spartans (2/23/2011)
Good qUESTIONS..

I SAW THIS TYPE QUESTIONS VERY RARE

This is off topic, but does everyone know there is an Edit button for changing your POST?
It actually does work!
Post #1068343
Posted Wednesday, February 23, 2011 9:08 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
Duncan Pryde (2/23/2011)
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, you can if you do it during the server install. Of course your question did say default, but then again a default installation on a cluster never puts any of these on the "C:" or "<system drive>:". You could add that to your explination.
Post #1068347
Posted Wednesday, February 23, 2011 3:06 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Thanks for the question. (It was easy since it has been modified to limit it to SQL Server 2005.)
Post #1068571
Posted Wednesday, February 23, 2011 4:52 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:24 PM
Points: 17,812, Visits: 15,737
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1068604
Posted Wednesday, February 23, 2011 4:54 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:24 PM
Points: 17,812, Visits: 15,737
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.



Thanks - That is very good information.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1068605
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse