4 Replies Latest reply on Mar 27, 2017 5:44 AM by ja2013

    EPO 5.9 - drop disaster recovery snapshot

    p4sql

      Hello,

       

      First post, first question ;-)

       

      I've setup EPO 5.9 with MS SQL Express 2016. I started some disaster recovery tests and after I've finished everything successfully I'd like to "drop" old snapshots in my DB but I do not know how.

      Just delete the table dbo.orionsnapshot is a really bad idea from my point of view. I checked the KB but there is nothing really helpful.

       

      How can I do this with MS SQL Server Mgmt studio? I have two snapshots in my DB and due to the fact that SQL express is limited to 10 GB DB size I'd like to delete at least one of my two snapshots.

       

      Thanks.

       

      Regards

      Pascal