I am a server Maintenance guy and i have given a task to work on restore Sharepoint missing data.
Its a tier 2 enviornment where in SQL Server 2005 is hosted on Server2008 and Sharepoint 2010 RTF version is on Server2008 as well.
We setup a mirror of SQL and Sharepoint server on Azure and the machines are in Stopped days 4 days back, since the Onprem Machines were running.
But due to a disaster onprem SQL and SP servers Machines are gone today. We have turn on the Azure SQL and APP server and connected via Site to site VPN. All portals are running , but the data on Sharepoint is missing since the MDF files on SQL server are 4 days old.
We have the latest MDF files on our backup solutions,So I am planing to Detach the DB file for all portals > Stop the MSSQL Service and Replace the old MDF files on the c drive with the update ones> then Start MSSQL service and Attach the MDF files.
Please suggest if the above plan looks safe or let me know the right way to do this