Hi,
We have a MS SQL Server that back in October filled up its hard drive which caused some data loss.
Our DBA quit some time before and while trying to create a backup of the database that had lost data we have somehow broken it more, a whole bunch of custom functions are missing, we can now no longer truncate or append and we can't browse the database lists.
I am looking for ideas on the best methodology for restoring the database instance back to when it was known to be working.
What I am thinking of is:
What are your thoughts? Should I have IT restore the backup to the non-prod server first and do the work in there, then once its working copy it across to production? I am not a DBA and our IT guys are not saavy either so I am at a bit of a loss.
Regards,
Dale
Hello @DaleJenner42 I don't have the full answer for you. But one thing you need to consider is whether you need to maintain the database's name across your instances. Your Geodatabase will need to be version ArcGIS Pro 3.0 or ArcGIS Server 11, otherwise renaming could cause some of the types problems you have described.