Solved

Change location/retention of SQL Database backups

Posted on 2014-12-15
3
102 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
3 Comments
 
LVL 7

Accepted Solution

by:
Ray earned 500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Account Lockouts 25 151
local administrator password solution 26 77
SQL Server CASE .. WHEN .. IN statement - Syntax issue 4 51
Query Peformance + mulitple query plans 9 48
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

920 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

12 Experts available now in Live!

Get 1:1 Help Now