rgb192
asked on
want to change folder location of backup file
sql server 2005
sql server agent
jobs
maintance plan3.subplan1
I can change the times that database is backed up
but I can not change folder location
sql server agent
jobs
maintance plan3.subplan1
I can change the times that database is backed up
but I can not change folder location
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can also do it another way.
For instance, by default, it is located here:
That window Defaults to C:\Program Files\Microsoft SQL Server\MSSQL.1\Backup
So, you can change it by going to your registry:
edit the HKEY_LOCAL_MACHINE\SOFTWAR E\Microsof t\Microsof t SQL Server\MSSQL.1\MSSQLServer \BackupDir ectory value to point to e:\data\databases
Notice I used e letter. You can change it to your preferred letter.
For instance, by default, it is located here:
That window Defaults to C:\Program Files\Microsoft SQL Server\MSSQL.1\Backup
So, you can change it by going to your registry:
edit the HKEY_LOCAL_MACHINE\SOFTWAR
Notice I used e letter. You can change it to your preferred letter.
I don't think it's a good idea to make changes directly in registries.
Anyway that key it's only the default directory, doesn't mean that his backup is set for that folder. Also we don't know if there is any other process that are making backups, so it's very dangerous these kind of changes.
Anyway that key it's only the default directory, doesn't mean that his backup is set for that folder. Also we don't know if there is any other process that are making backups, so it's very dangerous these kind of changes.
depends on his level of expertise.
That's one of the regularly used options, one I have used tons of times.
That's one of the regularly used options, one I have used tons of times.
ASKER
best answer thanks
You cannot select a new folder? It doesn't get saved? Or path is not accessible?
If you succeed don't forget to change also the cleanup task!