Can anyone tell me the command(s) you use to backup your user and system databases?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"'|||thanks..
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment