SQL DB - Required MDF-file is missing while exists[#19179]

Discuss any Microsoft SQL Server related issues here.

SQL DB - Required MDF-file is missing while exists[#19179]

Postby corbit » Mon Sep 25, 2017 7:46 pm

While backing up an MSSQL DB with CloudBacko Pro, I'm getting these "required file ***.mdf for database is missing" while these files do exist.

Log file:
1506290400153,2017-09-25-00-00-00,INFO,Report,Start sending backup error / warning report.
1506290400203,2017-09-25-00-00-00,INFO,Report,Finished to send backup error / warning report.
1506290400250,2017-09-25-00-00-00,INFO,Report,Start sending missed backup report.
1506290400251,2017-09-25-00-00-00,INFO,Report,Finished to send missed backup report.
1506290400254,2017-09-25-00-00-00,INFO,Report,Start sending storage alert report.
1506290400254,2017-09-25-00-00-00,INFO,Report,No destination is over 10% usage.
1506290400254,2017-09-25-00-00-00,INFO,Report,Finished to send storage alert report.
1506293801423,2017-09-25-00-56-41,INFO,Utilities,"Start running retention policy on backup set \"MSSQL-1(1468591085329)\", \"OneDriveForBusiness-1(1468591391998)\""
1506294406165,2017-09-25-01-06-46,INFO,Utilities,"Finished running retention policy on backup set \"MSSQL-1(1468591085329)\", \"OneDriveForBusiness-1(1468591391998)\""
1506294415928,2017-09-25-01-06-55,INFO,Report,Saving encrypted backup log files to 1468591085329/logs at destination OneDriveForBusiness-1...
1506294423890,2017-09-25-01-07-03,ERROR,Services,"Failed to run schedule backup, backup set \"MSSQL-1(1468591085329)\" , \"OneDriveForBusiness-1(1468591391998)\". Reason=\"[1468591391998] Required file \"500.mdf\" for database SQL\\500 is missing.\""
1506294424064,2017-09-25-01-07-04,INFO,Services,"Finished backup set \"MSSQL-1(1468591085329)\" Schedule backup."
1506331187925,2017-09-25-11-19-47,INFO,Report,"Generate backup report from \"15-09-2017\" to \"22-09-2017\"."
1506331192053,2017-09-25-11-19-52,INFO,Report,"Generate backup report from \"15-09-2017\" to \"25-09-2017\"."

Thanks in advance
Greets
User avatar
corbit
 
Posts: 7
Joined: Mon Sep 25, 2017 5:52 pm

Re: SQL DB - Required MDF-file is missing while exists

Postby jeff.tang » Wed Sep 27, 2017 10:35 am

Hello,

May I ask which Cloudbacko version are you using? To help us looking into this issue, could you please provide us with the Cloudbacko client log files for our investigation?

You can copy the log files to Dropbox, OneDrive, Google drive etc and share the link on this thread for us to download?

Please refer to our FAQ "Where are the CloudBacko backup and restore logs located?" viewtopic.php?f=58&t=233
Jeff Tang
CloudBacko Forum Support
The Most Secure Cloud & Local Backup Software
jeff.tang
 
Posts: 748
Joined: Mon Feb 02, 2015 9:50 am

Re: SQL DB - Required MDF-file is missing while exists

Postby corbit » Wed Sep 27, 2017 9:59 pm

I'm using CloudBacko Pro version 2.9.0.1
User avatar
corbit
 
Posts: 7
Joined: Mon Sep 25, 2017 5:52 pm

Re: SQL DB - Required MDF-file is missing while exists

Postby jeff.tang » Thu Sep 28, 2017 10:43 am

Hello,

Thank you for your update. Could you also provide us with the Cloudbacko client log files for our investigation?
Jeff Tang
CloudBacko Forum Support
The Most Secure Cloud & Local Backup Software
jeff.tang
 
Posts: 748
Joined: Mon Feb 02, 2015 9:50 am


Re: SQL DB - Required MDF-file is missing while exists

Postby jeff.tang » Fri Sep 29, 2017 10:49 am

Hello,

Apart from the system log, can you please send us the whole log folder for our investigation?
Jeff Tang
CloudBacko Forum Support
The Most Secure Cloud & Local Backup Software
jeff.tang
 
Posts: 748
Joined: Mon Feb 02, 2015 9:50 am


Re: SQL DB - Required MDF-file is missing while exists

Postby jeff.tang » Mon Oct 09, 2017 1:36 pm

Hello,

Thank you for the log files.

Just to let you know, I have escalated the case to our development team for further investigation.

==============
TMS #19179
[KB] CBK MSSQL backup fails with "Required file "xxx" for database xx is missing" error
==============

When the resolution available we will provide you an update on this thread, or you can visit to our web site to check updates on product news or releases.
Jeff Tang
CloudBacko Forum Support
The Most Secure Cloud & Local Backup Software
jeff.tang
 
Posts: 748
Joined: Mon Feb 02, 2015 9:50 am


Return to Microsoft SQL Server backup and restore

Who is online

Users browsing this forum: No registered users