cancel
Showing results for 
Search instead for 
Did you mean: 

Backup completed with warning

Kush_Sumit
Level 2

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

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
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.

View solution in original post

4 REPLIES 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
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.

Kush_Sumit
Level 2

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

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

sclind
Moderator
Moderator
   VIP   

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