Cannot backup databases from SQL Server 2008

sql-server-2008team-foundation-serverwindows-server-2008

I'm trying to back up the SQL Server 2008 database on Windows Server 2008, using instructions from:
http://msdn.microsoft.com/en-us/library/ms253070%28VS.80%29.aspx

Everything is pretty straightforward (just follow through the wizard to trigger a backup) however the SQL backup fails with the following error:

— start error —

Execute Maintenance Plan

  • Execute maintenance plan. TFS backup (Error)
    Messages
    Execution failed. See the maintenance plan and SQL Server Agent job history logs for details.

ADDITIONAL INFORMATION:

Job 'TFS backup.Subplan_1' failed. (SqlManagerUI)

— end error —


Here is a copy'n'paste from the log (there were only 2 relevant entries):

— start log entry —

Date,Source,Severity,Log ID,Message,Process ID,Mail Item ID,Account ID,Last Modified,Last Modified By,Category,Event,User,Computer

07/07/2009 12:21:22,Service Control Manager,Information,,The description for Event ID '1073748860' in Source 'Service Control Manager' cannot be found. The local computer may not have the necessary registry information or message DLL files to display the message or you may not have permission to access them. The following information is part of the event:'Diagnostic System Host' 'running',,,,,,(0),1073748860,,WIN2008-TFS

07/07/2009 12:20:42,SQLSERVERAGENT,Warning,,SQL Server Scheduled Job 'TFS backup.Subplan_1' (0x0140518D9AD209468CD45ECA97EC0B93) – Status: Failed – Invoked on: 2009-07-07 12:20:41 – Message: The job failed. The Job was invoked by User WIN2008-TFS\Administrator. The last step to run was step 1 (Subplan_1).,,,,,,Job Engine,1073742032,,WIN2008-TFS

— end log entry —

Best Answer

First, this is really a standard SQL Server backup. TFS data is there, but that's not relevant.

Second, in SSMS, open your maintenance plan for editing. Make sure that you have logging enabled, and then run the plan. This will create text files in your /LOG folder under the SQL Server installation folder. Check that and it will have more details about what specifically is wrong. Post that and we can help you debug the issue.