July 11, 2012 at 5:08 pm
I just finished install a sql server 2008 R2 instance.
I noticed when I do backup, it default folder to the original backup folder,
D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\
I remember on my another server, it default to my new backup drive like H:\Backup.
I cannot remmeber when I install SQL server, does it ask about backup folder?
I may miss it.
How can I change the backup drive default to H:\backup?
THnks
July 11, 2012 at 5:26 pm
I figured out, using facet in 2008 R2 is very handy to do. But anyone remembers if it is asked when do the installation? If so, I need to pay attention to it next time when doing installation.
http://www.w3expose.com/blog/tutorial/change-default-backup-folder-in-sql-server-2008-r2/
July 11, 2012 at 5:28 pm
Very good. Thanks for posting an update with an answer to your own question. 😉
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 12, 2012 at 9:50 am
As I had to deploy an SQL instance for some testing, I figured I'd watch to see if I could specify the backup directory during install.
Turns out when you're at the "Database Engine Configuration" step, if you go to the "Data Directories" tab, you can specify your backup directory.
Jason
July 12, 2012 at 9:54 am
Thanks, I think I just pay attention to change the data and log directory, but ignored the backup directory, I need to pay more attention to that and make it right at the first place.
Thanks,
July 12, 2012 at 12:29 pm
You can also run this:
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory', REG_SZ, N'H:\Backup'
GO
July 12, 2012 at 12:31 pm
Thanks, that is a good tip too.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply