[ dom @ 03.04.2007. 08:30 ] @
Imam server i to windows server 2003 i na njemu bazu i to microsoft sql server 2000. Na serveru su postavljeni jobovi da se izvrsavaju(nisam ih ja postavio nego neko drugi).
Od nedjelje dva joba mi se ne izvrsavaju i to jedan radi izgradnju indexa i to ja postavljeno da se radi jednom mjesecno. Greska koja mi se javlja u job history je:

Executed as user: IME\sqlsvcacc. ...contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execu... The step failed.

Drugi job je log shipping alert job – restore. I ovo je job koji se izvrsava svaki minut. Greska iz job history je:

Executed as user: IME\sqlsvcacc. The log shipping destination NAZIV.IME_BAZEis out of sync by 2715 minutes. [SQLSTATE 42000] (Error 14421). The step failed.

Hvala unaprijed
[ logic_rabbit @ 05.04.2007. 22:03 ] @
Vjerujem za prvu gresku da ti je greska tacno ispred reda
... The step failed.
u te tri tackice.Ovo ispred samo kaze da se DBCC izvrsio.

Za drugu gresku pogledaj(ako vec nisi)
http://www.developmentnow.com/...log-shipping-error-message.htm
tu je opisan isti problem i moguci uzroci.

Nadam se da ce ti ovo biti od pomoci.
[ dom @ 11.04.2007. 13:23 ] @
OK. Hvala