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 |
|
N_EvilScott
Starting Member
4 Posts |
 Posted - 2012-09-10 : 19:01:55
|
| I have a system running SQL Server 2008 R2 Standard.The doctor made a Full backup of the database, took it home, modified it on his home computer.He then came back to work and resumed working on the Business Server database without restoring the changes he made back at home (he brought a .bak file from his home computer), so I now have a Full database backup from his home computer, and I need to restore ONLY the changes he made while at home.What is the easiest way to do this?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-09-10 : 19:47:31
|
| You can't do what you want with just a restore. What you'll need to do is restore his database using a new name and then run a program, such as Red Gate's SQL Data Compare, to see exactly what changed. The problem though is it's probably going to be very hard to figure out what changes he made after he got back to work. Do the tables have columns in them that indicate when the data was added/changed and by whom?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
N_EvilScott
Starting Member
4 Posts |
Posted - 2012-09-10 : 19:52:27
|
| I'll download that right now and get that process started because it's a fairly large database, around 2GB in size. The program itself he uses does not make any timestamps which is rediculous, but it DOES have a column called LastModified. By default its NULL unless the column is modified. Other than that, it would be new rows created.On the bright side he should have only been working on two or three of the tables at most. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-11 : 01:36:02
|
| It may be worth exploring - how many changes he made at work - and if the primary source data is available. Restore last nights - and rekey the entries. It's a manual approach , as a last resortJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
N_EvilScott
Starting Member
4 Posts |
Posted - 2012-09-11 : 14:26:16
|
| Red Gates SQL Data Compare did the trick. I used the 14 day trial, but I'll request management to purchase this tool.Thanks everyone! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Partial Restore Question
You're welcome, glad to help.Tara Kizer