[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

want to change folder location of backup file

Posted on 2012-03-13
6
Medium Priority
?
780 Views
Last Modified: 2012-03-28
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
0
Comment
Question by:rgb192
6 Comments
 
LVL 25

Expert Comment

by:jogos
ID: 37719095
>>but I can not change folder location<<
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!
0
 
LVL 53

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 37719447
That's because you created the backup job from Maintenance Plans.
Go to Management / Management Plans / MaintenancePlan User Databases, edit the backup database plan and change the folder location there. Don't forget to Save after you give the OK.

Good luck
0
 
LVL 29

Expert Comment

by:sammySeltzer
ID: 37719728
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\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\BackupDirectory value to point to e:\data\databases

Notice I used e letter. You can change it to your preferred letter.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 53

Expert Comment

by:Vitor Montalvão
ID: 37720262
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.
0
 
LVL 29

Expert Comment

by:sammySeltzer
ID: 37720499
depends on his level of expertise.

That's one of the regularly used options, one I have used tons of times.
0
 
LVL 1

Author Closing Comment

by:rgb192
ID: 37779873
best answer thanks
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question