Results 1 to 9 of 9

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User entium's Avatar
    Join Date: May:2003
    Location: Ðóñå
    Posts: 1,426

    Angry Âúïðîñ çà Maintenance Plan â MSSQL 2000

    Ñïðÿ äà ìè âúðâè Maintenance Plan â MSSQL 2000 .Ïðîáâàõ òðèõ ñúçäàâàõ íîâè ïëàíîâå íå òðúãâà , ñìåíÿõ ïîòðåáèòåëè îò êîèòî ñå ïóñêàò äæîáîâåòå - íèùî.Èíà÷å ðú÷íèÿ backup è òîÿ ïðåç backup wizard-a ñ schedule ìèíàâàò. Èçëèçàò ìè ñëåäíèòå ãðåøêè â ëîãîâåòå :

    2005-06-02 11:14:23.22 spid72 Error: 15457, Severity: 0, State: 1
    2005-06-02 11:14:23.22 spid72 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
    2005-06-09 09:03:23.83 spid56 Error: 15457, Severity: 0, State: 1
    2005-06-09 09:03:23.83 spid56 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
    2005-06-10 09:01:28.61 spid56 Error: 15457, Severity: 0, State: 1
    2005-06-10 09:01:28.61 spid56 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
    2005-06-10 09:05:53.47 spid60 Error: 15457, Severity: 0, State: 1
    2005-06-10 09:05:53.47 spid60 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
    2005-06-10 13:18:46.90 spid60 Error: 15457, Severity: 0, State: 1
    2005-06-10 13:18:46.90 spid60 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
    2005-06-22 10:16:04.15 spid60 Error: 15457, Severity: 0, State: 1
    2005-06-22 10:16:04.15 spid60 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
    2005-07-01 14:45:04.89 spid70 Error: 15457, Severity: 0, State: 1
    2005-07-01 14:45:04.89 spid70 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
    2005-07-07 09:01:38.95 spid56 Error: 15457, Severity: 0, State: 1
    2005-07-07 09:01:38.95 spid56 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
    2005-07-07 09:07:44.12 spid62 Error: 15457, Severity: 0, State: 1

    Event Type: Warning
    Event Source: SQLSERVERAGENT
    Event Category: Job Engine
    Event ID: 208
    Date: 07.7.2005
    Time: 15:19:42
    User: N/A
    Computer: RUS-MS1
    Description:
    SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan ' DB Backup plan'' (0xD2942E8EE12252499D1B48975A378102) - Status: Failed - Invoked on: 2005-07-07 15:19:42 - Message: The job failed. The Job was invoked by User RUS\Administrator. The last step to run was step 1 (Step 1).



    Event Type: Warning
    Event Source: SQLSERVERAGENT
    Event Category: Job Engine
    Event ID: 208
    Date: 01.7.2005
    Time: 23:30:00
    User: N/A
    Computer: RUS-MS1
    Description:
    SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan ' DB Backup plan'' (0xD2942E8EE12252499D1B48975A378102) - Status: Failed - Invoked on: 2005-07-01 23:30:00 - Message: The job failed. The Job was invoked by Schedule 3 (Schedule 1). The last step to run was step 1 (Step 1).

    Åxecuted as user: RUS\RUS-MS1$. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

    Íÿêîé àêî ìîæå äà ïîìîãíå
    EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2

  2. #2
    Automatic Jack
    Join Date: Feb:2004
    Location: Ëóíàòà
    Posts: 216
    ñèãóðíî çâó÷è òúïî, íî âñå ïàê äà ïèòàì: äà íå òè å ñâúðøèëî ìÿñòîòî íà áåêúï äèñêà?

  3. #3
    Registered User entium's Avatar
    Join Date: May:2003
    Location: Ðóñå
    Posts: 1,426
    Èìà îêîëî 80GB ñâîáîäíè backupa íà íàé ãîëÿìàòà áàçà å îêîëî 1ÃÁ òîâà ïðîâåðèõ íàé ïúðâî.
    EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2

  4. #4
    Automatic Jack
    Join Date: Feb:2004
    Location: Ëóíàòà
    Posts: 216
    à ïðîáâà ëè äà ìó ðúííåø åäíî reconfigure? òîêó âèæ ñå ðàçêàðàëî òîâà îò ëîãîâåòå, çàåäíî ñ ïðîáëåìà. àç áèõ ïðîáâàë. àêî íå, õâúðëè 1 îêî òóê, îñîáåíî àêî íàïîñëåäúê òè ñå å ïîÿâèëà íîâà áàçà, ïðèìåðíî.

  5. #5
    Registered User entium's Avatar
    Join Date: May:2003
    Location: Ðóñå
    Posts: 1,426
    ×åë ñúì ãî òîâà ãóãëåòî ìè ãî èçêàðà íàé-îòãîðå.
    Íå å ìîÿ ñëó÷àé, íå ñúì ïàðâèë íîâè áàçè äîñåãà ïëàíîâåòå ñè ðàáîòåõà.
    À òîâà ðåêîíôèãóðå êàê òî÷íî ñå ïðàâè.
    EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2

  6. #6
    Automatic Jack
    Join Date: Feb:2004
    Location: Ëóíàòà
    Posts: 216
    âëèçàø â, îõ, query analyzer ëè áåøå ïðè sql server-a è ïèøåø
    reconfigure, ctrl-e. òðÿáâàò permission-è íà sa, ìàé.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè