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:35 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 10:00 AM
Points: 8,551, Visits: 9,043
Interesting question.

Using .NET (Framework 2 or later) it can also be done using SMO, there are public functions to get and set the (default) backup directory. Documented for SQL 2005 at Settings.BackupDirectory Property.


Tom
Post #1068633
Posted Thursday, February 24, 2011 12:49 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 4:22 AM
Points: 383, Visits: 232
I've just used the facets method with SSMS 2008 and SQL Server 2005. It is working! So you should give the points to the answer SSMS!

Greetings
Christoph
Post #1068697
Posted Thursday, February 24, 2011 12:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 4:22 AM
Points: 383, Visits: 232
Try it with SQL Server 2000! It's funny!

Cheers,
Christoph
Post #1068698
Posted Thursday, February 24, 2011 1:23 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, July 17, 2014 4:47 AM
Points: 3,352, Visits: 1,480
Thanks everyone for a lively discussion. I honestly thought this would be a nice uncontroversial question! Apart from it actually being incomplete (or incorrect, depending on your point of view), there are also issues with what the default location would actually be and so on.

Live and learn I suppose!

Duncan
Post #1068708
Posted Monday, March 5, 2012 8:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, June 19, 2014 10:32 AM
Points: 483, Visits: 243
Nice question and important to note that the default backup directory cannot be changed using SQL Management Studio but by modifying the registry in SQL Server 2005.

Thanks.
Post #1261605
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse