Forum Discussion

Kush_Sumit's avatar
Kush_Sumit
Level 2
9 years ago

Backup completed with warning

Hi Folks,

i am facing below mentioned issue while perfoming the fulldata base backup. 

 

04/22/2016 15:05:25 - Error bpbrm (pid=22562) from client <HOSTNAME>-b: ERR - failure reading file: C:\Program Files\erst\iXSClient\var\lib\ixsclient.db.lck (WIN32 33: Unknown error)

04/22/2016 15:05:46 - Warning bpbrm (pid=22562) from client <HOSTNAME>-b: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf (WIN32 32: Unknown error)

04/22/2016 15:05:46 - Warning bpbrm (pid=22562) from client <HOSTNAME>-b: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL\Data\mastlog.ldf (WIN32 32: Unknown error)

04/22/2016 15:05:46 - Warning bpbrm (pid=22562) from client <HOSTNAME>-b: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL\Data\model.mdf (WIN32 32: Unknown error)

04/22/2016 15:05:46 - Warning bpbrm (pid=22562) from client <HOSTNAME>-b: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL\Data\modellog.ldf (WIN32 32: Unknown error)

04/22/2016 15:05:46 - Warning bpbrm (pid=22562) from client <HOSTNAME>-b: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdbdata.mdf (WIN32 32: Unknown error)

04/22/2016 15:05:46 - Warning bpbrm (pid=22562) from client <HOSTNAME>-b: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdblog.ldf (WIN32 32: Unknown error)

04/22/2016 15:05:46 - Warning bpbrm (pid=22562) from client <HOSTNAME>-b: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL\Data\northwnd.ldf (WIN32 32: Unknown error)

04/22/2016 15:05:46 - Warning bpbrm (pid=22562) from client <HOSTNAME>-b: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL\Data\northwnd.mdf (WIN32 32: Unknown error)

04/22/2016 15:05:46 - Warning bpbrm (pid=22562) from client <HOSTNAME>-b: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf (WIN32 32: Unknown error)

04/22/2016 15:05:46 - Warning bpbrm (pid=22562) from client <HOSTNAME>-b: WRN - can't open file: C:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf (WIN32 32: Unknown error)

04/22/2016 15:05:46 - Info bpbrm (pid=22562) from client <HOSTNAME>-b: TRV - last message being suppressed after 10 occurrences

04/22/2016 15:21:12 - Info bptm (pid=22563) waited for full buffer 30070 times, delayed 57009 times

04/22/2016 15:21:12 - Info bptm (pid=22563) EXITING with status 0 <----------

04/22/2016 15:21:12 - Info bpbrm (pid=22562) validating image for client <HOSTNAME>-b

04/22/2016 15:21:13 - Info bpbkar (pid=0) done. status: 1: the requested operation was partially successful

04/22/2016 15:21:13 - end writing; write time: 0:19:34

the requested operation was partially successful  (1)

 

 

kindly help to troubleshoot this issue.

 

Warm Regards

KUSH

  • You cannot backup online databases with MS-Windows policy. Backup online SQL db's with MS-SQL policy. You need to add *.mdf and *.ldf to Client's Exclude List. Lock files as well - *.lck.
  • You cannot backup online databases with MS-Windows policy. Backup online SQL db's with MS-SQL policy. You need to add *.mdf and *.ldf to Client's Exclude List. Lock files as well - *.lck.
  • Hi Marianne,

    Greetings of the day,

     

    Thanks for you advise i have added these files in excluded list and now the backup has been done successfully.

     

    Cheers

    Sumit

  • I do hope you are backing up the databases via some other means and not just getting rid of the warning.