Manintenance Plan

I've created a maintenance plan and getting the following error message in the event log. This has been working for a while problem happend a week a ago, no changes to the system. Novice SQL user, any help on this appreciated.

Event ID 208. SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'RSS Pro2000 DBMP'' (0xFE3D7C9C154F9E48A4AA953C88D9F97E) - Status: Failed - Invoked on: 2007-03-19 13:28:00 - Message: The job failed. The Job was invoked by Schedule 13 (Schedule 1). The last step to run was step 1 (Step 1).

Are there any changes to the recovery model during this time of execution?

Also check the password or any information pertaining to SQLAgent account used here.

http://www.sqlservercentral.com/columnists/aingold/workingaround2005maintenanceplans.asp fyi.

|||No changes made. SQLAgent using 'Local System' a/c|||

Try to execute the job as manually with your account credential.

Do you have any other databases scheduled in this database?

if so are they getting same error?

|||The Db's are being backed up (there's 4 in total). It's only the transaction log that are not running.I've changed the a/c to 'administrator' and ran another transaction log and getting the same message.|||Have you applied the service pack or any changes to the server recentlY?

Management Studio won''t install

I am running Windows XP Pro, SP 2. I had SQL Server 2005 installed, but had uninstalled it. The install didn't go cleanly (I have posted a message in SQL Server 2005 Setup forum detailing the problems). Put simply, the files for 2005 were uninstalled, but Configuration Manager still shows the services there - although they aren't started and I can't start them (because they are not physically there. When I installed 2008, the server installed fine, but SSMS didn't. The installer program says it is installed. I'm assuming my problem has to do with the screwed up uninstall. Any ideas how I clean this mess without wiping my drive and reinstalling the OS? Thanks.

Ok, I uninstalled both Sql Server 2008 and 2005. The install process went fine until the last step -- documentation. It failed here. However, I have a link to the Books On Line and it works. The server is installed and running, but not SSMS. I previously had installed VS2008 on the D drive. I've seen references in other posts that this might be a problem.

|||

I am having the same problem. I uninstalled SQL 2000 as the whitepapers said you can't have it with 2008, but all that installed was configuration tools and reporting services

Management Studio won''t install

I am running Windows XP Pro, SP 2. I had SQL Server 2005 installed, but had uninstalled it. The install didn't go cleanly (I have posted a message in SQL Server 2005 Setup forum detailing the problems). Put simply, the files for 2005 were uninstalled, but Configuration Manager still shows the services there - although they aren't started and I can't start them (because they are not physically there. When I installed 2008, the server installed fine, but SSMS didn't. The installer program says it is installed. I'm assuming my problem has to do with the screwed up uninstall. Any ideas how I clean this mess without wiping my drive and reinstalling the OS? Thanks.

Ok, I uninstalled both Sql Server 2008 and 2005. The install process went fine until the last step -- documentation. It failed here. However, I have a link to the Books On Line and it works. The server is installed and running, but not SSMS. I previously had installed VS2008 on the D drive. I've seen references in other posts that this might be a problem.

|||

I am having the same problem. I uninstalled SQL 2000 as the whitepapers said you can't have it with 2008, but all that installed was configuration tools and reporting services