Viewing 15 posts - 40,651 through 40,665 (of 49,571 total)
noeld (3/3/2009)
That is why I don't really think "Clean Shutdown" is something you can choose.
It's not. SQL will always try to cleanly shut down all of its databases before...
March 3, 2009 at 12:12 pm
dmoldovan (3/3/2009)
As GilaMonster said, you should NEVER use DBCC REBUILD_LOG.
Actually I said it should never be the first thing tried.
March 3, 2009 at 11:55 am
sqlcentral (3/3/2009)
That will only ever allow me to return 1 row, correct?
No. There's a group by in the subquery, so that query will return 1 row for...
March 3, 2009 at 10:58 am
sqlcentral (3/3/2009)
Yeah, there was no forum for Sql server 2000.
Yes there is. The 2000 forums are below the 2005 forums on the forum home page.
March 3, 2009 at 10:54 am
winston Smith (3/3/2009)
March 3, 2009 at 10:25 am
sqlcentral (3/3/2009)
Please tell me that is Sql Server 2000 compliant 🙂 (my test machine is Sql 2005 Express)
Nope. 2005 and higher only. You did post in a 2005 forum.
Doing it...
March 3, 2009 at 10:22 am
winston Smith (3/3/2009)
so what happens in the case of a power outage? is sql server able to recover without intervention, as long as the storage media is ok?
Yes
there will...
March 3, 2009 at 10:19 am
prvreddy2000 (3/3/2009)
Recently i faced a question "how do we know database damage/crash happened in sql server?"
Depends what you mean by 'database crash'
If you mean corruption, use CheckDB
March 3, 2009 at 10:08 am
Dean Jones (3/3/2009)
Thanks for the posts guys, from the sql log details below
That's the results from 1204. Any chance you could use traceflag 1222 instead, as it produces a lot...
March 3, 2009 at 10:00 am
pedro.ribeiro (3/3/2009)
Do you think that...
March 3, 2009 at 9:59 am
WHERE logdate >= dateadd(dd, datediff(dd,0, getdate()),0) AND logdate < dateadd(dd, datediff(dd,0, getdate())+1,0)
will get you today's records. Play with that and you should be able to get x days past easily
March 3, 2009 at 7:17 am
ammarghanem921 (3/3/2009)
is it possible or not, and how to do it!
It is possible and if you read the article I linked a couple days back you'd see how to do...
March 3, 2009 at 7:11 am
Not necessarily. Shutting down the machine will shut down the SQL service just as if you went and said 'stop service'
The only exception is if you have long running transactions...
March 3, 2009 at 6:42 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic667195-8-1.aspx
March 3, 2009 at 6:08 am
Protect by not giving people rights to do things they shouldn't be doing (same as in 2005)
Monitor using a server-side trace.
March 3, 2009 at 6:03 am
Viewing 15 posts - 40,651 through 40,665 (of 49,571 total)