I posted this in the Sql 2005 newsgroup but I'm not convinced it isn't
specific to the data tier of team foundation server so I'm trying here as
well. I'm trying to backup the data tier of my team foundation server by
creating a maintenance plan in sql server 2005.
When I try and execute the maintenance plan the first couple database backup
and then I get the following strange error:
Failed:(-1073548784) Executing the query "BACKUP DATABASE
[TfsWorkItemTracking] TO DISK =
N'\\\\jefferson\\TeamFoundationServer\\Full\\\\TfsWorkItemTracking_backup_200610120942.bak'
WITH NOFORMAT, NOINIT, NAME = N'TfsWorkItemTracking_backup_20061012094246',
SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Failed to pause catalog for backup.
Backup was aborted.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons:
Problems with the query, "ResultSet" property not set correctly, parameters
not set correctly, or connection not established correctly.
I have no idea what this error means and my online searches haven't led to
anything either. This is SQL Server Standard 2005 SP 1 running as the data
tier for my team foundation server.
Any ideas?
Thanks,
Bryan Call
Andrzej Martyna - 14 Oct 2006 21:47 GMT
I had the same problem.
Run system service "SQL Server FullText Search (MSSQLSERVER)" and backup
should start to work.