?
Solved

Change location/retention of SQL Database backups

Posted on 2014-12-15
3
Medium Priority
?
116 Views
Last Modified: 2014-12-15
First, going to prelude this with the fact I have no SQL coding experience.

Issue: We have a SQL server hosting several databases. At one point, there was a SQL admin overseeing the server. Apparently he set backups to run daily for all of the databases with 0 retention.

I need to get the backups moved to a separate drive as it is causing problems with our ShadowProtect backup schedule and offiste backups.

I tried right-clicking on each database and going to backup database to change the location of the backup, but this only seemed to create a one-time backup and not change whatever was setup originally.

I fear he may have used a SQL script and not sure where else to check to get this corrected.
0
Comment
Question by:SBSWIZARD
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 7

Accepted Solution

by:
Ray earned 2000 total points
ID: 40501449
1. Check Management -> Maintenance Plans
Open the maintenance plan and look for "Backup Database" tasks
Open the task and look for the destination folder

2. If he use scripts, you might see them under SQL Server Agent - > Jobs
Then you can check individual steps to find out if he's using TSQL or Store Procedure to run backup.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 40501530
<<I fear he may have used a SQL script and not sure where else to check to get this corrected.>>
If you are not feeling comfortable with scripting yet, I would suggest you learn to begin learning how to set up a Database Maintainance Plan then disable the old job.  You will be faster doing that than retroengineering what was done previously with limited skill set.
0
 

Author Comment

by:SBSWIZARD
ID: 40501550
I would much rather just cancel the backups than anything. We currently backup the server on the hour, so I dont need two backups running.

But I was able to find the job in the SQL Server Agent and disable it.

Thanks guys.
0

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
Suggested Courses

800 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