Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
palencia
Starting Member
1 Post |
 Posted - 2011-07-28 : 15:07:44
|
| We have 2 sites that are running SQL 2008 and a central site that is also running SQL 2008. The data from the 2 sites is replicated to the central data warehouse. We have a purge process that will delete data from the site and only keep 45 days worth of data. The customer did not want the purge process turned on until all the financial reports at the site were printed and they had a hard copies. The customer's IT accidentally turned on the Purge job and didn't tell us. He quickly turned it off, however it ran for several minutes, deleting data. The site continued to operate and we just found out what happened. The customer now wants that data back before we implement the Purge process. The question is: What is the best approach to pull the data from the Central Datawarehouse to the site. There are primary keys on the tables FYI. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-28 : 16:20:35
|
| Restore a backup to a new database and copy the missing data back in. |
 |
|
|
3magic
Starting Member
14 Posts |
Posted - 2011-08-19 : 07:05:22
|
| Resolve a problem with reports that are not up to date or contain missing data.Process the warehouse or cube after you resolve schema conflicts that occurred in the warehouse. |
|
|
|
|
|
|
Recover missing data from Data Warehouse