Changing the default backup location for a clustered instance

Question

Post reply

Changing the default backup location for a clustered instance

vultar

Hall of Fame

Points: 3271
More actions
November 22, 2011 at 6:06 am

#390920

Hello all,
I want to change the default backup locations for a no. 2k8 R2 instances running on a 4 node cluster. I've read that I can only do this by changing a registry key.. has anyone ever tried this on a cluster before ? If so, is there a best practice to follow ?
I'll run through this in our release environment before making any changes in production.
Cheers
Vultar

Viewing 10 posts - 1 through 9 (of 9 total)

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

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

How to change the default backup location?

http://social.msdn.microsoft.com/forums/en-us/sqldatabaseengine/thread/5704312C-BF9C-4908-AD90-F4D8BBCB26A9

WARNING: Not Tested, Risky Registry Updates

vultar Hall of Fame Points: 3271 More actions · Answer 2

Thanks for this, however it doesn't mention anything about making registry key changes against a clustered instance, which is what I want to do.

Cheers

Vultar

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 3

vultar (11/22/2011)
Thanks for this, however it doesn't mention anything about making registry key changes against a clustered instance, which is what I want to do.
Cheers
Vultar

I never tried it (preferred it). Did you find similar entry in registry? Clustered Servers basically behave as one Entity. It should be same as regular instance.

NJ-DBA SSChampion Points: 13834 More actions · Answer 4

from http://www.sqlservercentral.com/articles/Backup+%2f+Restore/71500/

Here I will show how to find or change the default backup dircetory in various versions of SQL Server.

SQL Server 2008

Connect to the server in SSMS.

In the Object Explorer window, right-click the server and select “Facets”.

Change the Facet to “Server Settings”

The default backup file location can now be set.

NJ-DBA SSChampion Points: 13834 More actions · Answer 5

NJ-DBA (11/22/2011)
from http://www.sqlservercentral.com/articles/Backup+%2f+Restore/71500/
Here I will show how to find or change the default backup dircetory in various versions of SQL Server.
SQL Server 2008
Connect to the server in SSMS.
In the Object Explorer window, right-click the server and select “Facets”.
Change the Facet to “Server Settings”
The default backup file location can now be set.

(facets is under managment>policy mgmt)

NJ-DBA SSChampion Points: 13834 More actions · Answer 6

NJ-DBA (11/22/2011)
NJ-DBA (11/22/2011)
from http://www.sqlservercentral.com/articles/Backup+%2f+Restore/71500/
Here I will show how to find or change the default backup dircetory in various versions of SQL Server.
SQL Server 2008
Connect to the server in SSMS.
In the Object Explorer window, right-click the server and select “Facets”.
Change the Facet to “Server Settings”
The default backup file location can now be set.
(facets is under managment>policy mgmt)

eh, sorry- not there... right click the server, select Facets (from very top).... here is a good site with screenshots: http://www.mytechmantra.com/LearnSQLServer/Changing_Default_Backup_Location.html#axzz1eRfbvYUM

vultar Hall of Fame Points: 3271 More actions · Answer 7

Dev - I'd guessed they would probably behave the same but wanted to double check more anything.

NJ-DBA - That's worked a treat, much better & safer than editing the registry.

Thanks to both of you for your help!

Cheers

Vultar

vultar Hall of Fame Points: 3271 More actions · Answer 8

No probs, I didn't find it straight away.. thought it was me mis-reading your instructions 😉

Thanks again

Cheers

Vultar

NJ-DBA SSChampion Points: 13834 More actions · Answer 9

vultar (11/22/2011)
Dev - I'd guessed they would probably behave the same but wanted to double check more anything.
NJ-DBA - That's worked a treat, much better & safer than editing the registry.
Thanks to both of you for your help!
Cheers
Vultar

I know many of us get a better feeling using the gui than manually digging through the registry, but just FYI, all we are doing is changing the registry through the GUI... SSMS just executes a stored proc that edits the registry anyways, so in my mind, either method is legit.