Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)

  • RE: Monthly SQL Crashes

    I think I've tried it before with no luck. The message only appears after installing SP2. I've put the SQL service login account into the policy but I'll...

  • RE: Monthly SQL Crashes

    I paid Microsoft Support their exorbitant fee and spoke to a support person. They sent me CU4 (which brings SQL to version number 9.00.3200) and, so far, I haven't...

  • RE: Monthly SQL Crashes

    I've just setup a new SQL box. Win2K3 (x64) SP2 with SQL2005 - nothing else on it - didn't show up any errors untill I put SQL SP2 on...

  • RE: Monthly SQL Crashes

    Here are the advanced options

    Name Minimum Maximum Config_value ...

  • RE: Monthly SQL Crashes

    Okay, here is the math:

    16322444 + 717340 = 17,039,784

    17,039,784 - 16775868 = 263,916

    So it looks like I'm 264MB short on physical memory. I assume that changing the SQL Max...

  • RE: Monthly SQL Crashes

    Here are the memory numbers:

    Physical Memory

    ----------------

    Total: 16775868k

    Available: 438440k

    System Cache: 717340k

    Commit Charge

    --------------

    Total:...

  • RE: Monthly SQL Crashes

    I've had a trawl through the event logs and there are no errors/warnings about memory problems or anything hardware fault related. This server runs just the one instance of...

  • RE: Monthly SQL Crashes

    I thought it must be something like that, thanks.

    I've run the CheckDB on all the system DB's and there are no errors. The check on the user DB will...

  • RE: Monthly SQL Crashes

    It's running SQL 2005 (9.00.3152) Standard Ed (x64) build 3190 with SP2. The box has got 16GB physical memory plus 4GB swap. SQL Max memory is set to...

  • RE: Monthly SQL Crashes

    SQL Server ran DBCC checkDB on all the databases when it came back up, but reported no problems. Error log posted below:

    2008-02-06 03:12:12.48 Server ...

  • RE: Shrinking a live DB

    Thanks for your help.

    Regards,

    Stu

  • RE: Backup failed?

    I've done a bit of digging and found that it's not the database backup that's failing - it's the notification it tries to send me afterwards to let me know...

  • RE: Backup failed?

    Here is what our error-forwarding system picks up from the event log:

    EVENT #1187405

    EVENT LOGApplication

    EVENT TYPEError

    SOURCESQLISPackage

    EVENT ID12291

    USERNAMENT AUTHORITY\SYSTEM

    COMPUTERNAME OHG21

    TIME24/10/2007 00:28:17

    MESSAGEPackage "OHGPackaging Differential Backup" failed.

    EVENT #1187406

    EVENT LOGApplication

    EVENT TYPEWarning

    SOURCESQLSERVERAGENT

    CATEGORYJob Engine

    EVENT ID208

    COMPUTERNAME ...

  • RE: Backup failed?

    I've just tried running a full backup and I get the same thing. The files appears and is about the right size but it says the backup failed. ...

Viewing 14 posts - 1 through 14 (of 14 total)