Job oprettet til starte backup maintenance plan
Jeg har lavet en maintenance plan, der laver full backup af alle mine databaser. Jeg kan "excecute" den, og så laver den også backup.Så vil jeg godt have det til at køre automatisk, så jeg opretter et job under server agenten der skal starte min maintenance plan.
Hvis jeg så starter den manuelt, så kommer den efter kort tid og siger success, men hvis jeg kigger i job history for mit job, så står der dette.
Message
Executed as user: *domain*\SA_SQLAgSvc. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 13:16:56 Error: 2008-07-04 13:16:56.50 Code: 0xC020801E Source: FullBackup Log provider "{1D3270E2-8045-4698-8D4B-2D13DE3F7EB6}" Description: The connection manager "Local server connection" is an incorrect type. The type required is "FILE". The type available to the component is "ADO.NET:SQL". End Error Error: 2008-07-04 13:16:56.53 Code: 0xC020801E Source: FullBackup Log provider "{1D3270E2-8045-4698-8D4B-2D13DE3F7EB6}" Description: The connection manager "Local server connection" is an incorrect type. The type required is "FILE". The type available to the component is "ADO.NET:SQL". End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 13:16:56 Finished: 13:16:56 Elapsed: 0.5 seconds. The package executed successfully. The step succeeded.
Nogen der har en idé til hvad der er galt?
Har lavet det samme med Transactional logs og det fungere fint...