September 9, 2016 at 9:10 am
Hello, first let me say that I am an Oracle DBA by trade and was given the duties of SQL Server DBA after that guy left. So far, okay. However, I was told we are decommissioning the current Backup Server in order to move to a brand new one. I have been poking around for days on how to change the location of the backups. I know there is the "default" location but our databases on the PROD SQL Server are not using it. They are using the current location which is a Network Server.
I can see the location in the jobs but WHERE in the heck do I change them to point to the new server when we go to cut over?
So far backups have been running like clockwork and I don't want to have to recreate any of the jobs or plans if I don't have to.
But come Tuesday night and I don't have an answer on how to do I'll be screwed.
How can I do change the location of the backups?
Thanks.
September 9, 2016 at 9:13 am
How are you doing your backups at the moment - maintenance plans, Ola Hallengren's solution, or some other method?
John
September 9, 2016 at 9:24 am
John, Maintenance Plans.
September 9, 2016 at 9:28 am
Oooh, that's nasty. I think you need to go into each plan and amend it by hand, I'm afraid. Or take this opportunity to move on to something more flexible and robust, such as the aforementioned Hallengren scripts.
John
September 9, 2016 at 9:43 am
I have seen the Hallengren scripts being mentioned from time to time.
If I were to use it, would it delete everything that is there and recreate it?
Also, if I were to change each plan where would the change be? I have looked but have not found out where the database location is?
Thanks again John, appreciate the help.
September 9, 2016 at 9:52 am
I'm not sure what you mean. Do you mean delete the maintenance plans, or delete the existing backups? You'd have to remove the maintenance plans yourself. You can configure the Hallengren jobs to delete old backup files.
Where would what change be? Do you mean where are the maintenance plans stored? They're effectively cut-down SSIS packages, and I think they're stored in msdb. I don't think you can edit them directly in place, though - you have to use the GUI.
John
September 9, 2016 at 12:18 pm
No the plans. I don't care about the existing backups.
That's the thing, I didn't set them up so and I don't know much about them generally speaking but I cannot find anywhere in the GUI that says, here's the backup location.
So, I can delete all the plans? And then run that script that will recreate all of them? And it will let me specify where the backups are going?
Thanks.
September 12, 2016 at 2:13 am
What version of SQL Server are you using? Double-click on the Back Up Database Task, and you should find the backup location in the Destination tab.
John
September 12, 2016 at 8:47 am
HOLY COW THERE IT IS!!???
John, I am using SQL Server Management Studio for all of this but that particular box is a 2008 SQL Server installation.
So you are saying if I ADD A LOCATION there of the new backup server and then DELETE the current one, that when ANY backup runs then it will use THAT location?
Even the scheduled maint plans as well?
That would be a tremendous weight lifted off me!!
Thanks again John!
September 12, 2016 at 9:06 am
No, not quite. That location will only apply to the database specified in the General tab of the Back Up Database Task. If you're backing up all databases with that task, then yes, that will take care of it, provided you don't have any databases in Full recovery mode (for which you need to set up transaction log backups).
John
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply