locked
which one is best? RRS feed

  • Question

  • Hi All,

     We are taking regular backups by creating a job. I want to implement a schedule task to perform regular backups. Now my doubt is which one is best. working with a job or with a schedule  a task.

    I need one more thing. When we want to take the backup i want to supress the memory occupied by the backup.

    Please guide me how to handle this and please help me to clear the above mentioned doubt.

    Waiting for valuable replies

    Friday, April 23, 2010 10:36 AM

Answers

  • If you don't have an experienced DBA, Database Maintenance Wizard is the very, very best option.

     

     


     

    Kalman Toth, SQL Server & Business Intelligence Training; BI TRIO 2008

    • Proposed as answer by Naomi N Monday, April 26, 2010 2:08 AM
    • Marked as answer by Tony Tang_YJ Wednesday, April 28, 2010 8:00 AM
    Friday, April 23, 2010 11:07 AM

All replies

  • Use the Database Maintenance Wizard (SSMS Object Explorer, Maintenance Plans) to build you a Maintenance Plan.

    That is your best option if you don't have an experienced DBA.

     


     

    Kalman Toth, SQL Server & Business Intelligence Training; BI TRIO 2008

    Friday, April 23, 2010 10:48 AM
  • Thank you for the answer and goodmorning.

    I know that through  Database Maintenance Wizard  we can handle. I want to know which one is the best option.

    Friday, April 23, 2010 11:05 AM
  • If you don't have an experienced DBA, Database Maintenance Wizard is the very, very best option.

     

     


     

    Kalman Toth, SQL Server & Business Intelligence Training; BI TRIO 2008

    • Proposed as answer by Naomi N Monday, April 26, 2010 2:08 AM
    • Marked as answer by Tony Tang_YJ Wednesday, April 28, 2010 8:00 AM
    Friday, April 23, 2010 11:07 AM