backup failed to complete the command backup

• Akan Antia

  SSC Rookie

  Points: 41

  More actions

  August 19, 2004 at 1:57 pm

  #112190

  Hello,

  Can anyone help me? I tried to do a full master database backup and in return get this error message 'SQL-DMO (ODBC SQLSTATE: 42000)'

  Akan.

   

  ---

  Kindest Regards,

  Akan Antia

• Julian Kuiters

  SSCertifiable

  Points: 6585

  More actions

  August 20, 2004 at 1:16 am

  #519948

  How are you attempting to do the backup ? using SQL DMO objects?

  Have you tried a simple disk backup?

  BACKUP DATABASE master TO DISK='C:\backuptest.bak'

  RESTORE VERIFYONLY FROM DISK='C:\backuptest.bak'

  ---

  Julian Kuiters
  juliankuiters.id.au

• Alamir

  SSCertifiable

  Points: 6085

  More actions

  September 1, 2004 at 1:51 am

  #521305

  what about open Enterprise manager .. and right click on your Database , choose All Tasks >> Backup database

   

  
  Alamir Mohamed
  Alamir_mohamed@yahoo.com