Bigger picture: Propose to management that a reporting database be created and updated (preferably on a different server) and let users query against that database instead. Still not ideal to...

Run something like this to see your backup history and see if there are full backups running at other times. You can add DIFF and LOG to get more results:

SELECT...

Almost 2 years ago at a different company. I don't remember. But since I only displayed sample code, not sure how it would help you.

If you have a trace running, maybe you can match up big t-log backup files with events in the trace file for the same time period.

" ... Thanks for any input ..."

I hate "Order by 1" type code. Why not put the column name so it's clear ?

And no comments and meaningless temp table names...

The next Full backup is tomorrow morning, so that is good. Puzzled by the huge Diff though. I have trace files from that time period. Not sure the best columns...

Chris, although your code is better, I can understand why it's confusing to newer SQL coders. I think it's less intuitive, and not everyone is familiar with some of the...

Ed Wagner (3/18/2013)

---

Have you tried importing into an "inbox" or "incoming data" table that the Import Wizard creates itself? I just did this recently to get data into a...

Would SQL 2012 work any better ? I could install it on my laptop just for this.

I think SQL doesn't take a big enough sample of data, so it makes the output columns too small. I found a registry setting for how many rows to sample...

I use backup history too. Quite a few threads , posts & scripts here and elsewhere.

Make sure everything is working. If not, figure out why & fix it. And if you have time, improve things that are working, but take too long.

That's pretty much my...

Could be any number of things. Fragmented indexes, blocking/locking, missing indexes, other applications grabbing CPU, any server changes recently ? code changes ? major data changes ? Bigger...

You are correct (as usual). All good now after manually putting permissions back on.

The permission problem seems like it would be a red herring. I had no trouble moving (detach/attach) a different database in the same folders. And I wasn't moving the log...