Post reply

back up

  • April 17, 2003 at 4:51 am

    #159094

    anyway,If i want to schedule a back up for the whole database what should i do in the enterprise manager.

    Can u please tell me how to schedule the process..

    Thanks in advance

  • April 17, 2003 at 5:43 am

    #454487

    You can either create a job with the TSQL code for doin the backup or setup a maintainence plan to handle this.

  • April 17, 2003 at 5:49 am

    #454490

    You can do this by Maintenance Wizard or as follows with TSQL job:

    SQLMAINT.EXE -D DATABASENAME -CkDB -CkAl -CkTxtAl -CkCat -UpdSts -BkUpDB D:\MSSQL\BACKUP\DATABASENAME\DB -BkUpMedia DISK -DelBkUps 1 -Rpt D:\MSSQL\BACKUP\DATABASENAME\Reports\DATABASENAME_Daily_Maint.rpt

    OR You can just take the backup as follows:

    SQLMAINT.EXE -D DATABASENAME -BkUpDB D:\MSSQL\BACKUP\DATABASENAME\DB -BkUpMedia DISK -DelBkUps 1 -Rpt D:\MSSQL\BACKUP\DATABASENAME\Reports\DATABASENAME_Daily_Maint.rpt

    .

  • April 17, 2003 at 5:51 am

    #454491

    Bruce: You might want to check the syntax and options for SQLMAINT.EXE in BOL.

    .

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

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