The extension doesn't matter, it's a matter of convention. You can detach it, rename it, then attach it back.

As far as the size, you need to check the database recovery...

Mad Hacker (6/10/2009)

---

Although I could see using the data analysis as a supporting tool, I still feel very strongly that it is management's responsibility to maintain morale. In many...

Peter, it does identify people, but it doesn't necessarily give a prescription of what to do, or that's not what I read.

If it said "Peter is likely to quit, terminate...

Leisure and sports allow for a better quality of life, and a distraction from other issues. There have been studies in the US that show TV has been a nice...

There is definitely the possibility that this can be mis-used, but this is the type of thing we all do every day.

It isn't an exact, pinpoint system. I don't think...

I've put it back in the article text, so you can read it online with colored formatting.

My apologies to Wayne for not getting this done sooner. I thought I...

I agree with you, Jeff, but who do you talk to? I've known plenty of people that were thinking of leaving, and wouldn't want to let their manager know. And...

Maybe someone could send him a blue pawprint?

http://www.youtube.com/watch?v=MJM9eSDjRho

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...