Posted by Erland Sommarskog on 02/22/07 21:47

blueboy (matt_meech@hotmail.com) writes:
> Many thanks for that it seems to be what i was after however i keep
> getting an error -
>
> The job failed. The Job was invoked by User domainname\user. The
> last step to run was step 2 (Restore). The job was requested to start
> at step 1 (Kill connections).

Did you look under Job history to see what failed? Up to the right
(in Enterprise Manager in SQL 2000), there is a checkbox which says "View
step history". There should be an error message.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]