Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Posts
    13

    Unanswered: Maintenance plan: backup

    Hi,

    I have made a maintenance plan to backup a database.

    The file name is like this: name_db_200606211209.BAK

    isn 't it possible to get the filename to be always the same
    (without 200606211209)

    I have unchecked the checkbox to remove files older than x-days
    but it still appends 2006... to it

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Not thru a maintenance plan. If you want the same file name for each backup, create a backup device, then manually create a sql agent job to backup the database to that device.

    I would recommend using the init feature of the backup command so you don't keep appending the current backup to the backup device. That couls get messy (and quite large) after a while.

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Aug 2005
    Posts
    13
    Do you perhaps have an example of

    an sql agent job to backup the database to that device ?

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Nope ... i use LiteSpeed to backup to disk and then have the files written to tape. I typically keep 2 or 3 days backups and trans logs on disk before deleting them.

    I could type up all the steps, or you could try to do it yourself using Books OnLine. I prefer the latter, so that you learn to fish instead of me giving you the fish.

    Try it, detail your results, and come back with specific questions that we can answer.

    -- This is all just a Figment of my Imagination --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •