Select to view content in your preferred language

Restoring MS SQL Server

99
1
2 weeks ago
Labels (2)
DaleJenner42
New Contributor

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:

  • export the data from the current non-working database
  • import into a new instance on a non-production server
  • restore the non-working server to a known working backup
  • make sure the restored server is working
  • copy data from the non-working server back to the production server
  • confirm working

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

0 Kudos
1 Reply
ChrisUnderwood
Esri Contributor

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.

https://www.esri.com/arcgis-blog/products/arcgis-pro/data-management/restoring-sql-server-databases-...

0 Kudos