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
