Restoring SQL by Combining Tables from Backups - URGENT
We had an issue today when someone noticed that two tables in our SQL DB were missing (the data was missing). We have a good backup from 10 hours earlier that had the table and data but want to be able to backup today's activities then see if we can combine the DB's to meld together the combined since it was hours before someone noticed it.
In practice can this be done?
In practice can this be done?
liija
There's no partial restore in SQL Server. Restore to another database and copy the data to production db a way or another.
ASKER
I was thinking of preventing anyone from using it for a couple of hours at which time I would:
1) Restore the DB with the majority of the records to a new DB
2) Backup today's DB
3) Find the Tables that don't have today's data and import in the data from today in the same tables into the newly created DB
If this is something that's been done before can you outline how to do it?
1) Restore the DB with the majority of the records to a new DB
2) Backup today's DB
3) Find the Tables that don't have today's data and import in the data from today in the same tables into the newly created DB
If this is something that's been done before can you outline how to do it?
Basic things for dba, start with backup and restore. I don't have time today help you any further today, hope someone else has...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.