Rank: PA User
Joined: 24/04/2009(UTC) Posts: 332 
|
Zanima me kako izvajati maintenance plan?
Katera opravila(taske) je potrebno zaganjati, da je baza v čim boljši kondiciji?
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 576 Was thanked: 9 time(s) in 9 post(s)
|
Jaz imam check database, reorganized index, rebuild index, update statistic in shring database. |
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 332
|
NEkaj dni dobivam tale error:
Message
Executed as user: MEDUSA\SYSTEM. ...sion 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:00:00 Progress: 2011-03-04 01:00:02.68 Source: {121C99A1-F87E-49CA-871B-75BEA4C4F444} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2011-03-04 01:00:03.84 Source: Shrink Database Executing query "USE [UNIKA10] ".: 50% complete End Progress Progress: 2011-03-04 01:00:15.32 Source: Shrink Database Executing query "DBCC SHRINKDATABASE(N'UNIKA10', 10, TRUNCATEONLY) ".: 100% complete End Progress Progress: 2011-03-04 01:03:01.06 Source: Reorganize Index Executing query "USE [UNIKA10] ".: 0% complete End Progress Progress: 2011-03-04 01:03:01.06 Source: Reorganize Index Executing query "ALTER INDEX [_KontoSRS2002_0] ON [dbo].[_KontoSRS2".: 0% complete End Progress Progress: 2011-03-04 01:03:01.06 Sour... The package execution fa... The step failed.
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 576 Was thanked: 9 time(s) in 9 post(s)
|
Jaz pa že nekaj mesecev...
Message
Executed as user: VOBOSERVER\SYSTEM. ... 9.00.5000.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:40:01 Progress: 2011-03-04 09:40:04.68 Source: {C128246D-6F53-43CB-8414-A2DF5A0A7471} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2011-03-04 09:45:12.22 Source: Reorganize Index Executing query "USE [Aroma] ".: 0% complete End Progress Progress: 2011-03-04 09:45:12.33 Source: Reorganize Index Executing query "ALTER INDEX [PK_MIGALL_Table] ON [dbo].[_MIGALL_Ta".: 0% complete End Progress Progress: 2011-03-04 09:45:12.33 Source: Reorganize Index Executing query "USE [Aroma] ".: 0% complete End Progress Progress: 2011-03-04 09:45:12.35 Source: Reorganize Index Executing query "ALTER INDEX [APCALLLINKS_01] ON [dbo].[APCALLLINKS".: 0% complete End Progress Progress: 2011-03-04 09:45:12.35 Source: R... The package execution fa... The step failed.
Kaj mi lahko kdo pove kaj je narobe ???
lp
Dejan |
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 332
|
nekaj sem našel na to temo sem pa res kake 14 dni nazaj popravil CPU and IO Affinity, tako da sem izklopil en procesor kar opisuje na spodnjem linku da zna biti problem http://social.msdn.micro...9-4e99-bfcf-7f88bda7efb5tole se sesuje Check Database Integrity (asdasd\sasdad) Check Database integrity on Local server connection Databases: UNIKA10 Include indexes Task start: 2011-03-04T01:00:02. Task end: 2011-03-04T01:00:03. Failed:(0) Alter failed for Server 'asdasdasd\\asdasdasd'. Bom poizkusil dati gor pa še SP4 Edited by user 26 April 2012 17:27:28(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 576 Was thanked: 9 time(s) in 9 post(s)
|
Nebo pomagalo, ker ga imam jaz pa je isto. |
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 332
|
kje se ti usuje? poglej v log.
Jaz sem namreč zdaj odkljukal CPU and IO Affinity, tako, da nimam nobenega procesorja izključnega
in mi je naredilo maintenance plan brez napake. "The package executed successfully. The step succeeded."
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 576 Was thanked: 9 time(s) in 9 post(s)
|
Jaz imam to nastavljeno na avtomatsko. Je lahko to problem ??? Sedaj bom probal dati avto vstran itak so zadaj tudi vsa polja pokljukana... pa javim kako je cez cca 1uro ( ja tak dogo mi dela :)) |
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 332
|
Jaz sem pred nekaj dnevi izklopil avtomatiko in očitno je bil to problem. Danes sem nazaj vklopil in maintenance plan spet dela.
poglej log v:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
Tam ti morda kaj bolj natančno piše kaj je narobe.
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 576 Was thanked: 9 time(s) in 9 post(s)
|
sebastijan piše:Jaz sem pred nekaj dnevi izklopil avtomatiko in očitno je bil to problem. Danes sem nazaj vklopil in maintenance plan spet dela.
poglej log v:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
Tam ti morda kaj bolj natančno piše kaj je narobe. Isto je kot pri tebi seba. S tem, da imam jaz na avto nastavljeno pa mi vrne error sedaj sem naredo "ročno" pa čakam, da vidim kaj se bo zgodilo. |
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 576 Was thanked: 9 time(s) in 9 post(s)
|
|
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 332
|
a je bol problem s temi procesorji?
|
|
|
|
|
|
Rank: PA User
Joined: 24/04/2009(UTC) Posts: 576 Was thanked: 9 time(s) in 9 post(s)
|
|
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)Powered by YAF 1.9.6.1 Under DNN |
YAF © 2003-2025, Yet Another Forum.NETThis page was generated in 0,481 seconds.