Change location/retention of SQL Database backups
Posted on 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.