.

I think maybe you're miunderstanding backups.

Transaction log backups are 'incremental' backups. The full backup is not a backup of the data file, it's a backup of the data files and...

sault (6/22/2015)

---

If I pull a backup from one of these sites and try to restore it the backup will have the database file plus many log files listed to be...

Yup, that's a stackdump triggered by an access violation.

So you're getting databases with multiple active ldf files?

The first problem likely to occur is that he boots the laptop and then plugs the drive in. SQL tries to access the database files when it first opens the...

No, because it's a plain subtraction,...

To allow for someone with the knowledge and tools to identify the cause of the access violation (memory-related error). Typically that someone is from Customer Support as they have access...

What, exactly, do you mean by 'There is a log file for each day of transactions.'?

What are you referring to as a 'log file'? The actual .ldf file? A log...

Index definitions and execution plan (saved as a .sqlplan file) please.

Yes, yes, yes, no.

2. Does Indexs Reorg have less impact on...

Yup.

Yes, the query's already running, the index create will, depending on locks, have to wait until that query has finished. If it does run at the same time, it can't...

You become an 'expert' by studying, trying, reading, practicing and making mistakes,...

Boot camps are typically designed to get you to pass the exams, not learn the material. They're a few of days of cramming what you need to pass the exams...