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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:21 PM
Points: 7,928, Visits: 9,653
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
SSC-Addicted

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

Group: General Forum Members
Last Login: Friday, December 5, 2014 1:32 AM
Points: 405, Visits: 248
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
SSC-Addicted

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

Group: General Forum Members
Last Login: Friday, December 5, 2014 1:32 AM
Points: 405, Visits: 248
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: Friday, December 12, 2014 5:31 AM
Points: 3,352, Visits: 1,490
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: Saturday, November 29, 2014 2:17 AM
Points: 483, Visits: 245
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