Default Backup Directory

Question

Default Backup Directory

Viewing 5 posts - 31 through 34 (of 34 total)

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

TomThomson SSC Guru Points: 104773 More actions · Answer 1

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

Christoph Muthmann Ten Centuries Points: 1164 More actions · Answer 2

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

Have a nice day,Christoph

Christoph Muthmann Ten Centuries Points: 1164 More actions · Answer 3

Try it with SQL Server 2000! It's funny!

Cheers,

Christoph

Have a nice day,Christoph

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 4

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

zymos SSCommitted Points: 1960 More actions · Answer 5

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.