I am trying to restore the db that has been backedup from Umbraco cloud. I ran sp_configure 'contained database authentication', 1; prior to restore. But it keep falling with error message as mentioned below:
"Error SQL72014: .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Line 3 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FKHangFireJobParameter_Job". The conflict occurred in database "siteName-xyz-dev", table "HangFire.Job", column 'Id'."
I would really appreciate if I get to know if I am missing something in this regard.
Umb Cloud db .bacpac failing to restore on locally with tb name "HangFire.Job"
Hello Umbraco Community,
I am trying to restore the db that has been backedup from Umbraco cloud. I ran
sp_configure 'contained database authentication', 1;prior to restore. But it keep falling with error message as mentioned below:"Error SQL72014: .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Line 3 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FKHangFireJobParameter_Job". The conflict occurred in database "siteName-xyz-dev", table "HangFire.Job", column 'Id'."
I would really appreciate if I get to know if I am missing something in this regard.
Kindly advise / suggest.
Thank you in advance! :)
Regards, Ranjit
is working on a reply...