Viewing 15 posts - 23,506 through 23,520 (of 39,819 total)
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...
June 10, 2009 at 12:25 pm
Mad Hacker (6/10/2009)
June 10, 2009 at 11:54 am
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...
June 10, 2009 at 11:52 am
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...
June 10, 2009 at 9:57 am
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...
June 10, 2009 at 9:13 am
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...
June 10, 2009 at 8:43 am
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...
June 9, 2009 at 9:18 pm
Maybe someone could send him a blue pawprint?
June 9, 2009 at 2:27 pm
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...
June 9, 2009 at 2:12 pm
If you have 500 DTS packages, I bet you have DTS on the headache!
June 9, 2009 at 12:00 pm
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...
June 9, 2009 at 11:58 am
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...
June 9, 2009 at 11:54 am
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....
June 9, 2009 at 11:51 am
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...
June 9, 2009 at 11:48 am
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...
June 9, 2009 at 11:45 am
Viewing 15 posts - 23,506 through 23,520 (of 39,819 total)