Post reply

SQL Server 2005 Full Database Backup

  • November 12, 2008 at 6:20 am

    #195943

    I'm taking full backup of database in SQL Server 2005 which is appending the data in same file on daily basis and not creating any new file on daily basis. I need to know how can I get full backup of database in SQL Server 2005 that creates automatically a new file on daily basis as per schedule.

  • November 12, 2008 at 6:53 am

    #897480

    Let me get this straight, you are running a scheduled backup that is appending to a single file? How is this job configured?

    I would suggest that you use the maintenance plan wizard to set this up. This will allow you to select the tasks you need and set them up as a single complete maintenance plan.

    Regards, Irish 

  • November 12, 2008 at 7:33 am

    #897520

    why dont you make a maintainance plan in which first step take full backup and schedule it and then add a clean file task to the second step and delete files based on days or hours, you can keep as many copys or only one depend upon ur requirement.

    Thanks

  • November 12, 2008 at 7:56 am

    #897550

    Sounds like it's going to a backup device with "append" instead of "overwrite".

    I prefer creating indiviual .BAK files and keeping a few days worth on hand in case they're needed.

  • November 12, 2008 at 10:05 pm

    #897894

    [font="Tahoma"]I've written a script for full backup some days back, you can try the script. Check the link below

    http://sql-articles.com/blogs/2008/06/backup-script-with-retention/[/url][/font]

    Regards..Vidhya Sagar
    SQL-Articles

  • November 13, 2008 at 1:06 am

    #897921

    You should take differential backup and restore it.

    mmmmmmmm......

  • November 13, 2008 at 2:03 am

    #897931

    Amit Gupta (11/13/2008)

    You should take differential backup and restore it.

    Huh? Why would you want to do that?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 13, 2008 at 6:32 pm

    #898372

    yea...why would you do that?

    Maintenance plans are the way to go here buddy

Viewing 8 posts - 1 through 7 (of 7 total)

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