I probably didn't do a good job explaining the analogy, but I think that looking at other professions might help us decide if we should change the way we do...

:), I was going to suggest what you posted. Single user mode usually helps here.

Terry,

Good advice.

OP,

You would restore the full, the diff, and logs, and with the final log, go as long as you can. You have to practice those tasks. I'm not sure...

That's a good question. I know xp_delete_file is called, with the filename and time base on tracing things.

In testing, I also saw a call like this:

exec sp_executesql N'RESTORE LABELONLY FROM...

2 instances meaning active/active or 2 instances on one node in active/passive?

Are you adding another server (3 nodes) for the instance or a third instance somewhere else?

Config Mananger, is it connecting to the virtual node or one of the individual nodes?

It might not be cluster aware. I wouldn't be surprised there if you had to manually...

Marios,

That's an interesting scenario. I haven't dealt with it, but my thoughts are that you enable AWE on all instances. With 2-3GB for each instance, I think you would not...

That should be the right file. I think a reboot is necessary since there could be a pending change. Shouldn't hurt.

Order shouldn't matter, never seen it do so in the past, but I've added things to the end so I know what to remove.

Be sure you document your changes.

I own a training center, but I'm not sure classroom is for everyone. Some people like the live environment, getting a ton of information packed into one week. Others think...

I'd be interested as well. What people typically do is quiesce the system, make sure nothing else is happening, and then run your process.

Keep in mind that the server is...

Typically you have CALs that allow a client to access any number of devices. I don't believe this has changed, but licensing is fluid, so I'd check directly with Microsoft...

I don't think there are queries for this. I'd assume it's in the registery, so perhaps you can xp_regread the data out of there. Might need multiple queries.

Interesting thoughts, and I'm looking forward to seeing what you think about tomorrow's comparison.

Jeff, inspections are often third party, city or county employers, isn't that better than having the developer...

How do you expect this data to get into folders? What type of result set?

The data from SQL Server can be easily exported using DTS or bcp and you can...