Solved

Change location/retention of SQL Database backups

Posted on 2014-12-15
3
108 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 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

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.
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

733 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