Viewing 15 posts - 41,626 through 41,640 (of 49,562 total)
When was the previous log backup? Was there anything that broke the log chain since then (switch to simple, truncate only)?
January 18, 2009 at 2:53 am
Please don't start new threads for existing questions. It just leads to duplicate replies and wastes people's time.
Asked and answered - http://www.sqlservercentral.com/Forums/FindPost638856.aspx
No replies to this thread please.
January 18, 2009 at 2:52 am
RBarryYoung (1/17/2009)
Hey, I just read it. That is a great article!
Agreed. Steve, can you republish this?
January 18, 2009 at 2:49 am
What type are they at the moment?
January 18, 2009 at 2:38 am
What kind of CLR stuff do you have? Just asking in general about migrating it's a pretty vague question.
January 18, 2009 at 2:37 am
matsinopoulos (1/18/2009)
Hi,I was wondering whether there is any similar construct in SQL Server 2008 with what one has in Oracle as ROWTYPE.
No. You'll have to do it the hard way.
Aside,...
January 18, 2009 at 2:37 am
RBarryYoung (1/17/2009)
This being an ORDER BY on the outermost SELECT, it seems that it is guaranteed to be so sorted.
Ummm. This is an odd case. I chatted with one of...
January 18, 2009 at 2:35 am
Jeff Moden (1/17/2009)
Heh... first, you do realize that I was spoofing on him, right. 🙂 Just gotta make sure.
It was prettyn obvious
And I agree... correct answer for the...
January 18, 2009 at 2:23 am
kiransuram19 (1/17/2009)
January 18, 2009 at 2:22 am
Paresh Prajapati (1/17/2009)
Anywany if u want to talt log backup with truncation , Please take full backup of database after that..
I said that.
GilaMonster (1/17/2009)
January 18, 2009 at 2:09 am
Paresh Prajapati (1/17/2009)
That'y i said to take transaction log backup of current DB again and then apply it after that..
Except that, as Paul said, if the log's corrupt when you...
January 18, 2009 at 2:00 am
MichaelJasson (1/17/2009)
January 18, 2009 at 1:58 am
krypto69 (1/17/2009)
What am I missing?
An attached execution plan, along with the table definition, the index definitions and, if possible, an estimate of the number of rows in the table, the...
January 17, 2009 at 2:45 pm
Jeff Moden (1/17/2009)
Heh... I can just see the flame comments now.
😀
I'm writing an article on corruption at the moment and one of the things I've had to put...
January 17, 2009 at 2:23 pm
bhushanvinay (1/17/2009)
Look at issuing a nolock on the tables when do create the stored proc's this should help in getting the locks down.
Providing you don't mind the chance of incorrect...
January 17, 2009 at 2:12 pm
Viewing 15 posts - 41,626 through 41,640 (of 49,562 total)