Yeah that's not really intended use of CDC to posthumously recreate the change capture from logs.

Another option is to keep two snapshots on your target, so pre and post restoring...

Just be careful switching to an inner join if that is a 1 to many 🙂

Except the point of...

Completely missing the point, Phil.

It's not discrimination. You are not being forbidden from attending these conferences. You are not incapable of getting jobs or networking because of your gender...

Well this is a SQL forum 🙂  So load it to a database and do a full outer join on what you consider the key columns, then you can do...

Compare-Object is comparing the entire object, in the case of files it'll compare the entire line and you'll see all the lines that are in one file or the other. ...

Well why are you using -includeequal if you just want the diffs 🙂

Make sure you understand the difference between adding a new filegroup vs just adding a new ndf to the primary file group.

Well if the tables have no relationships the ER diagram is really simple, it's just a bunch of boxes with the table names in them 🙂

How much of that is actual unique applications/db's vs basically the same install being used by a different group?

The whole point of error handling is to actually handle the error in some way.  Where that makes sense to do depends what the over all set up looks like. ...

Make sure to check not just that group's permission but every group in AD that that group might be a member of, nested groups are fun.

Now, I'm going to assume you are on SQL Express which is why you using the bat file. Now, if you are looking to use windows task scheduler for...

I'm guessing that snippet of C# code is from the...

Can you post a screen shot of the SSIS package?

It sounds like all it is an execute task that is calling some local web services and that web service is...