Viewing 15 posts - 36,196 through 36,210 (of 49,562 total)
Once the san repairs are 'finished', check the windows event log, make sure there are no IO-related errors. Make sure you know where your backups are, in case you need...
October 22, 2009 at 9:47 am
Animal Magic (10/22/2009)
October 22, 2009 at 9:27 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/Topic806976-149-1.aspx
October 22, 2009 at 3:07 am
su_kumar11 (10/22/2009)
and if my database has been crashed at 12.30 pm .Then how i will recover...
October 22, 2009 at 2:51 am
agriggs 11853 (10/21/2009)
October 21, 2009 at 2:32 pm
Take a look at this blog post and the two that follow it.
http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/
October 21, 2009 at 2:21 pm
UncleBoris (10/21/2009)
October 21, 2009 at 2:16 pm
agriggs 11853 (10/21/2009)
running a task every 30 minutes to shrink the log files, with truncate.
Bad idea. Exceedingly bad idea. Please go to the person who told you to do...
October 21, 2009 at 2:14 pm
HowardW (10/21/2009)
It was my understanding that regardless of recovery interval, the data files are not written to until the transaction is committed?
Nope. When checkpoint runs it writes ALL dirty pages...
October 21, 2009 at 10:02 am
Timothy Patihk (10/21/2009)
Yes, we are thinking of network problems, and are exploring ways to prove this
The proof is in the error message - "The specified network name is no longer...
October 21, 2009 at 9:46 am
Steve Jones - Editor (10/21/2009)
Am I missing something?
I thought we were talking about the restart-recovery, not the restore from backup.
October 21, 2009 at 9:40 am
I could easily understand a 2.1 billion row transaction rolling back during recovery, that would mean it hadn't hit the COMMIT at the time that SQL was stopped and had...
October 21, 2009 at 8:51 am
Using braindumps is cheating. They are actual questions taken from the actual exams (in violation of the NDA that a candidate has to accept) and posted illegally online.
Using or promoting...
October 21, 2009 at 8:45 am
The only difference between an estimated and an actual execution plan is that the actual execution plan includes some runtime information. Actual row counts, actual number of executions and a...
October 21, 2009 at 8:34 am
Network glitch. Since you're restoring from a network drive, all you need is a moment where the backup isn't accessible and the restore will fail. Copy the file locally, then...
October 21, 2009 at 8:31 am
Viewing 15 posts - 36,196 through 36,210 (of 49,562 total)