Basecamp Export

From the list: Regression/Maintenance Issues - Maintenance

✔ Run ISLG back to restore content - HIGH PRIORITY

Morgan M. added this on May 13, 2019
Completed May 14, 2019 by Morgan M.

Assigned to

Harsh P.

Jitesh D.

Paul M.

Ryan K.

Notes

Further to the video below, one of our editors has accidentally deleted a block of content from the Master Tree for the Subject Navigator, and we need to determine the best option for restoring content. The following questions need to be answered:

Can we perform a server based backup that isolates content in the Master Tree?
If not, will a server based backup affected any activity concerning user/subscriber managements
- Will this affect any trial account requests that have been made over the past 24hours?

Ryan

, can you please call me on Zoom when you are available to coordinate the appropriate action.

Thanks,

Morgan

System restore backup (13-May-19).mp4 14 MB • Download

Comments & Events

Paul Moon

Hi all:

I confirmed with the editor who deleted sub-branches that he did so around 10 a.m. Pacific Time this morning (May 13th).

Thanks,

Paul

May 13, 2019 at 6:15 PM Notified 4 people

Ryan Knuth, Customer Support Manager

Hi all,

I've submitted a ticket with Carbon60 asking what is available in the backups. I've cc'd each of you on the ticket.

Thanks!

Ryan

May 13, 2019 at 6:27 PM Notified 4 people

Ryan Knuth, Customer Support Manager

Jitesh

and

Harsh

As you may have seen from the Carbon60 ticket you're cc'd on, they have the following available for database back-ups:

You have following database backups:

-SQL native backup (from SQL server ) at 1AM with retention 2 days – you can restore database and tables from here. Your SQL admin can do the restore.

-HP DataProtector SQL backup – full database backup at 3:10AM – with retention 14 days. – We can restore the whole database (not table). We can restore the database with different name and you can extract the table and drop the DB.

We are running VM level backup as well at 11:15 PM as well.

Please attempt only restoring the missing data to avoid any user issues.

Feel free to respond to the ticket as well should you require any additional information from Carbon60.

Thanks!

Ryan

May 13, 2019 at 8:08 PM Notified 4 people

Morgan Maguire, CEO

Ryan

thanks for the details above.

Jitesh

and

Harsh

, could you please proceed with the backup as follows:

Use the SQL native back from 1AM EDT 13 May 2019 to restore content lost the Master Tree.
The missing content was removed from under the following branch: https://www.investorstatelawguide.com/MasterTree/Addnode?toc=editNode&rootNodeID=&expandList=1,33741,38628&nodeID=43503&parentID=38628&addLevel=&dataType=2&buttonEdit=Edit%2FRef.&nodeRadio=43503
If restoring the missing content is not possible, and you need to replace all the content in the Master Tree, please confirm date and time of the backup, so we can back fill any content added since the time of the backup.
Please do not replace the content on dev.islg, in case we need to use this for restoring content in the event that the back-up fails.

Please let me know if you have questions. I'll be monitoring my email until 10pm PDT.

Morgan

May 13, 2019 at 8:36 PM Notified 4 people

Harsh Parikh, Tech Lead

Morgan

and

Ryan

,

We have checked and found that total 82 records were deleted from database.

We are looking into that and tried to restored only those 82 records from 13th May's database backup.

May 14, 2019 at 5:06 AM Notified 4 people

Morgan Maguire, CEO

Ok. Great. Thanks

Harsh

. Let us know if any issues arise.

Morgan

May 14, 2019 at 5:18 AM Notified 4 people

Harsh Parikh, Tech Lead

Morgan

,

We are going to down site for 10 to 15 minutes to perform database activity.

May 14, 2019 at 5:56 AM Notified 4 people

Harsh Parikh, Tech Lead

Morgan

Ryan

and

Paul

,

We have restored deleted records in master tree table. We have checked master tree module primary level and seems all OK now.

Please take a note that application was down for approx 15 minutes.

Please check and let us know the feedback.

May 14, 2019 at 8:51 AM Notified 4 people

Morgan Maguire, CEO

Looks like the appropriate content is restored. Thanks

Harsh

Ryan

and

Paul

, please test the system to ensure there are no issues.

Thanks,

Morgan

May 14, 2019 at 1:28 PM Notified 4 people

Ryan Knuth, Customer Support Manager

Morgan

I haven't experienced any issues on the front-end of www.islg.

Thanks!

Ryan

May 14, 2019 at 4:46 PM Notified 4 people

Morgan Maguire, CEO

Ok. Great. Once

Paul

confirm. We'll mark this to-do complete.

Morgan

May 14, 2019 at 4:53 PM Notified 4 people

Paul Moon

Hi all:

Everything seems to have been restored, thank you.

Paul

May 14, 2019 at 5:00 PM Notified 4 people

Morgan Maguire, CEO

Great. Thanks

Paul

May 14, 2019 at 5:04 PM Notified 4 people

Morgan Maguire completed this to-do.

May 14, 2019 at 5:04 PM