You can limit it, but you'd need to shred the EVENTDATA XML to figure out which table it was and then limit things.

You might be better off just logging changes...

You transaction log backup should not be growing if you are not changing data. If it is, I can only assume that transactions are being added to the database, inserts,...

The trigger can't exist without the table, so I think it's a dependent object that goes in there. You ought to be able to get the others as separate files.

The...

I don't include tempdb in anything.

I do include model. If changes get made there, you want them backed up. However I don't reorganize or reindex system dbs.

I put system dbs...

I agree. I think it's an outstanding technique. You could watch them go through things, or leave them in a room, give them an hour, have them make notes and...

The reindex will need space to complete, but it ought to get you a set of contiguous extents. The issue is that you don't know where those will be.

What you...

How exactly to envision the data being used? What are some samples ways this data is being gathered, user for search?

That will help us to determine how the entity lives...

GSquared, actually the whole technique is great. Give them a server in a VM, what's wrong?

A good way to see how people go about their jobs.

I love these questions.

http://www.sqlservercentral.com/Forums/Topic703533-24-1.aspx?Update=1

Gives me a chance to get multiple posts in :w00t:

Please do not cross post.

Please do not ask general questions without having done some basic research and thinking about what problem you are having.

Closing this thread.

There is one method, no best.

http://msdn.microsoft.com/en-us/library/ms186858.aspx

If you have some other question, please better define what issue you are having or what you don't understand. If this is a simple restore,...

That's an interesting technique. With VMWare/Virtual PC, you could easily set one of these up. Hmmm, I think I see an editorial here.

Moved to the 2000 forum.

What I'd do is insert all the records into a staging table. Then insert rows into the real table that are good, whatever that means.

You have...

Points awarded back and both 1 and 2 marked as correct.

I think the answer is correct, but I have added a warning to the explanation so that people that might not read the discussion will see it.