Post reply

DataBase maintanance Plan

  • November 3, 2008 at 2:16 am

    #195322

    When i create a database maintanance plan to backup my database . The backup in taken but it is stored in a file .

    Is there some way in which i can specify my backup device (which we can create)to be used for my backup.

  • November 4, 2008 at 4:55 am

    #893532

    Are u using wizard for maintenance plan or designer?

    DBDigger Microsoft Data Platform Consultancy.

  • November 4, 2008 at 6:53 am

    #893585

    I am using a wizard

  • November 5, 2008 at 12:17 pm

    #894471

    I find the best way to do it is to just copy the file to the backup device after the backup is complete. Once it is copied over you can delete the file.

  • November 7, 2008 at 8:31 am

    #895590

    Ok- while using the Wizard, the first step should prompt you to specify the location of the backup. Specify 'to disk' and then add the disk you want the database to be backed up to.

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

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

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