Post reply

Backup Process

  • February 16, 2009 at 8:58 am

    #134811

    Hello All,

    We have a database running on SQL2005 and I have to develop a script to do a full backup of this database every week and keep the backup file for a week. But the backup that is taken at the end of the month should not be overwritten. We have to keep one backup per month (taken on the last day of the month). Can anyone help me with this.

    Thanks

    Shri

  • February 16, 2009 at 9:13 am

    #944643

    there are lots of backup scripts on this site.

    you can have two different jobs for backups. one for weekly backup(and delete them after a week using same job) and other one for monthly backup.

    you can also use maintenence plan wizards...

    also, is your db in simple recovery model? coz you didnt mention backing up transaction logs.


    Pradeep Singh

  • February 16, 2009 at 11:26 am

    #944748

    Thanks

    It is set up for full recovery, I am doing a transactional log backup every hour, but I did not know how take the monthly backup. Should I not set an expire date on them, so they don't get deleted.

    Thanks

    Shri

  • February 16, 2009 at 11:45 am

    #944756

    shri_sastry (2/16/2009)

    Thanks

    but I did not know how take the monthly backup.

    Thanks

    Shri

    you can schedule a job for monthly backup..there are lots of scripts on this site

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • February 16, 2009 at 12:23 pm

    #944769

    You can have a separate job for monthly that puts the backup in a separate folder so it won't get overwritten.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply