Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    Ireland
    Posts
    32

    Unanswered: Command to Backup user & System tables

    Can anyone tell me the command(s) you use to backup your user and system databases?

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    xp_sqlmaint '-PlanName "DBMaint System DBs" -Rpt F:\MSSQL2K\MSSQL\LOG\BckpSysDBs.txt -DelTxtRpt 2DAYS -RmUnusedSpace 10 1 -WriteHistory -BkUpDB -BkUpMedia DISK -DelBkUps 2DAYS -UseDefDir -VrfyBackup -BkExt "BAK"'

    xp_sqlmaint '-PlanName "DBMaint User DBs" -Rpt F:\MSSQL2K\MSSQL\LOG\BckpUserDBs.txt -DelTxtRpt 2DAYS -RmUnusedSpace 10 1 -WriteHistory -BkUpDB -BkUpMedia DISK -DelBkUps 2DAYS -UseDefDir -VrfyBackup -BkExt "BAK"'
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Jan 2002
    Location
    Ireland
    Posts
    32
    thanks..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •