Solved

want to change folder location of backup file

Posted on 2012-03-13
6
766 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
Comment Utility
>>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 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
Comment Utility
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 28

Expert Comment

by:sammySeltzer
Comment Utility
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
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
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 28

Expert Comment

by:sammySeltzer
Comment Utility
depends on his level of expertise.

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

Author Closing Comment

by:rgb192
Comment Utility
best answer thanks
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Trigger for audit 26 48
SQL Query 2 56
How to check data in sql table 11 37
configure service broker on all databases 2 67
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now