Viewing 15 posts - 40,636 through 40,650 (of 49,552 total)
winston Smith (3/3/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2009 at 10:00 am
pedro.ribeiro (3/3/2009)
Do you think that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2009 at 6:03 am
nabajyoti.b (3/3/2009)
i want to create a query which will give me emp_id, name, emp_address,DOB.
Join the two tables with a LEFT OUTER JOIN, instead of an INNER JOIN
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2009 at 6:02 am
winston Smith (3/3/2009)
seems it can be caused a lot by a database that was not cleanly shutdown.
That's not enough to send a DB suspect. SQL can recover a database...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2009 at 6:00 am
Grant Fritchey (3/3/2009)
Also, do you get Management Studio (and all the other GUI tools) with SQL Server Express? I didn't think you did.
Not with it, but Management Studio Express is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2009 at 5:47 am
A detach commits (or rolls back) all transactions, writes all dirty data pages to disk, writes a mark in the log indicating a clean shutdown and then it removes the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2009 at 5:19 am
Viewing 15 posts - 40,636 through 40,650 (of 49,552 total)