Post reply

How to Set Automated Backups of SQL server database

  • May 7, 2004 at 2:10 am

    #82578

    Hello All,

    I am sure - i am posting my queries at a place where i can find the right help.

    I am new to SQL server, and want to set automated database backups at regular intervals. and when a backup file is created... it must not replace the old ones.

    Thanking you all in advance..... i hope i will receive your help soon.

     

     

     

     

     

  • May 7, 2004 at 2:49 am

    #505617

    You can automate backups a couple of ways. 1 way is to right click the Database and select Backup Database and then schedule it from there.

    What do you mean when a backup file is created, it must not replace the old one? 

    Kindest Regards,

  • May 7, 2004 at 3:38 am

    #505626

    U can automate the backup using the maintenance plan wizard in which u can schedule at what interval a backup has to be taken. The backup files wont be overwritten or replaced. There is an option for automatically deleting older files which u can set when u r running out of disk space.

    To take maintenace plan right click the database and select maintenance plan from the pop up menu.

    Hope this helps u.

    Nivedita

     

Viewing 3 posts - 1 through 2 (of 2 total)

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