I don't think a 1 minute Tlog interval is too much. I've run that before and it works OK. HOWEVER, it doesn't mean you won't lose data. The important thing...

If you have 500 DTS packages, I bet you have DTS on the headache!

you didn't mention open transactions. Those can prevent the log backups from freeing space.

Also, did the log backups change in size? I used to track this rather than the actual...

Diffs don't impact log backups. At least I didn't think they did. They only reduce the number of log restores needed, but AFAIK (correct me Gail), you could take the...

I tend to agree with Gail. Saving 0.01s on a query run 1000 times an hour can be more important than saving 12 minutes on one run once a day....

I picked way0utwest when I came to Denver, and use that in places. Others I stick with Steve Jones. No real rhyme/reason, but I note that they are part of...

Migrating DTS is not migrating a database. It is something different. And it is a pain.

We are happy to help with questions on items, but not general ones like what...

Oooohh, that's bad.

I didn't think that was bad, a little short, but not bad.

Here are a few books recommended on database design. The diagrams will be listed in there: http://thomaslarock.com/book-reviews/

A few tools I have used:

- Management Studio/Enterprise Manager with Database Diagrams

- ER/Studio (Embarcadero)

-...

a billion dollars is a lot. It's hard to spend it, and MS moves in a lot of areas. Check out Microsoft Research[/url]. The idea isn't that everything gets turned...

This flies in the face of what a backup/restore is for, and in common sense in terms of DR.

I can see the "worried about an investigation" and there are legitimate...

Correct, but it's not about pointers, it's about physical movement. If the extents are located in order 1, 2, 3, 4, 5 inside the logical file, as they should be...

I'll check and see. We had an issue with the email servers on Sun/Mon, so that might have been it.

apparently everyone is in this thread now, but I'll repeat what's above. Rebuilding indexes will require more space, but you NEVER, NEVER, shrink down to the data size. Even if...