Skip to main content
Database Administrators

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

7
  • I think the simplest way would be to manually script your backup job to only use YYYY-MM-DD (maybe HH) in the naming convention so you'd know the backup names for each day. Unless you're sold on Ola's scripts, in which case this won't be viable. Commented Feb 5, 2015 at 20:22
  • @JohnM that would be ideal, unfortunately we don't manage that system and in any case the maintenance plan that does the backup also does a whole bunch of other important stuff, so separating the backup job from it is not desirable :( Commented Feb 5, 2015 at 20:25
  • 1
    unless the the "whole bunch of other important stuff" is directly backup-related, i'd say that it's extremely desirable to separate it. Commented Feb 5, 2015 at 20:29
  • also, you mention ftp ... how much access do you have to the source? can you get a linked server? Commented Feb 5, 2015 at 20:30
  • 3
    @JohnM though i'd certainly advocate against maintenance plans altogether Commented Feb 5, 2015 at 20:32