Results 1 to 6 of 6

Thread: BackUp Fails

Threaded View

  1. #1
    Join Date
    Jun 2006
    Posts
    28

    BackUp Fails

    Guys I was wondering if you can help me figure out the problem with the script.

    1) I am getting the following error message on one of the job which is backing up all the databases on the server.

    ...ges for database 'AdminWorkFlow_Reports', file 'AdminWorkFlow_Reports_Data' on file 1.
    [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'AdminWorkFlow_Reports',
    file 'AdminWorkFlow_Reports_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or
    restore operation successfully processed 433177 pages in 64.328 seconds (55.163 MB/sec).
    [SQLSTATE 01000] (Message 3014) Processed 113720 pages for database 'BMSRep', file 'BMS_Data'
    on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'BMSRep', file '
    BMS_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or restore operation
    successfully processed 113721 pages in 17.200 seconds (54.162 MB/sec). [SQLSTATE 01000]
    (Message 3014) Processed 208 pages for database 'EmailAddress', file 'EMailAddress_STGE_Data'
    on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'EmailAddress',
    file 'EMailAddress_STGE_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or restore
    operation succe... The step failed.

    Not sure where to start. I looked up the backup script it looks fine.

    BackUp Database AdminWorkFlow_Reports to Disk = 'q:\\AdminWorkFlow_Reports12-17-2007.bak'

    --
    --
    --
    --

    BackUp Database EmailAddress to Disk = 'q:\\EmailAddress12-17-2007.bak'

    2)Also I have another script which for some reason doesn't run on some nights. Its enabled and the job is scheduled daily but its not running for about a week.

    SQL server agent is running though.

    Any help in this regard would be appreciated.
    Last edited by Owais; 12-17-2007 at 04:19 PM.

Posting Permissions

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