Maybe not - the times I've seen that are when a DB action is taken against the DB row containing the problem. I suppose an index build or rebuild might be a potential trigger, if that's the real problem, but that's grasping a bit.
Is it possible to bring the DB online a piece at a time, or with selected features turned off? Do previous backups have the same problem? Rick On Sat, Oct 11, 2008 at 11:41 AM, Jeff Lockemy (Northrop Grumman Mission Systems) <[EMAIL PROTECTED]> wrote: > ** > > Hi Rick, > > > > Thank you for the response. This all happens before we even bring the AR > System application online. Do you think it could still be that? > > > > Regards, > > Jeff > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Rick Cook > *Sent:* Saturday, October 11, 2008 11:17 AM > *To:* [email protected] > *Subject:* Re: Production SQL Server Problem > > > > ** > > Jeff, turn on your SQL logs next time you put it on line - it may point to > a workflow or data issue (i.e. a field overflow) that's causing this. I've > seen that happen. > > Rick > > On Sat, Oct 11, 2008 at 10:56 AM, Jeff Lockemy (Northrop Grumman Mission > Systems) <[EMAIL PROTECTED]> wrote: > > ** > > Listers! > > > > We have a problem with a production SQL Database Server. We are running > SQL Server 2005 Enterprise Edition SP2 on Windows Server 2003 Enterprise > Edition SP2, on a Dell PowerEdge 2850. When we bring our ARSystem database > online (45GB), it may run for a while but then without warning the system > will lock-up, then blue screen and reboot. After the reboot, the database > is corrupt and must be restored again from back-up. > > > > We have ensured that all of our drivers and firmware are up-to-date on the > servers, and are staging a different PowerEdge model to eliminate the 2850 > server hardware as being suspect. At this point we still don't know if it > is a O/S, SQL Server, database or system problem. > > > > Has anyone seen any problems like this with SQL 2005? Any suggestions on > where else we might look? > > > > Thanks in advance… > > > > Jeff > > > > > > Jeff Lockemy > > QMX Support Services > > > > > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
