I don't know much about DPM. I did find this at social.msdn.microsoft.com

===

"DPM takes VDI backups not native backup. Full backups would not hurt, log backups would."

===

so it looks like...

Replication probably wouldn't work in this scenario, nor mirroring. Log shipping might work for you but that involves the FULL backup and T-Log backups.

Personally, I would still take a...

I have to second the previous comment. We've been running clusters (Sql Server and Oracle) for years and the only time these clusters fail over is when we manually...

duh, thanks. Time for another double shot + energy.

It looked the text was missing from your post.

I'm interested in your disk configuration.

Sometimes vendors allow you to bring a server in for testing. They'll loan you a server for a month or so. Why not see if you can get...

Where is GroupID coming from?

Is there a GroupTable?

If I understand then the "groups" have mixed weight classes in them. Essentially the event wants x Number of athletes in each...

What Paul said, is absolutely correct. You can't do much without determining the entities or relationships. That should be the first thing you do, or sketch out on...

Since this is x64 are you using "Lock Pages In Memory"? This should eliminate the startup message that you are receiving with regards to paging. Instead you'll see...

...but not many from OZ

Do you have a family? It's tough to chance leaving stability and benefits for the unknown, especially in this economy and market and with fierce competition. That said,...

Can't you just prevent the truncation to begin with?

I regularly deal with flat files because we interface with a mainframe. I use this approach.

Use a sql query, or stored procedure...

Perhaps something like this:

Member (table)

MemberID PK

=========

I9Rules (table)

I9RulesID PK

CountryCode PK FK

RuleDesc

=========

DocumentType (table)

DocumentTypeID PK

IsRequired bit not null

I9RuleID (FK)

=========

Document (table)

DocumentID PK

MemberID (FK)

DocumentTypeID (FK)

I modified the I9Rules table to make CountryCode party of the...

Working with this example above, I would create 2 records for PAD - C0205:

<ReadingType-Gamma-ID> <GammaValue> <AssignDate> <ReturnDate> <Employee-ID>

<ReadingType-Alpha-ID> <AlphaValue> <AssignDate> <ReturnDate> <Employee-ID>

Let me know if...

You can absolutely have <null> values for a FK field, so your example of that is ok.

Also, you say that these tables are the "main" tables:

EquipmentType

Equipment

TransactionType

Transactions

To me the "xxxType" tables...