|
Home > Archive > MS SQL Server > October 2006 > Problem backing up databases with maintenance plan
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem backing up databases with maintenance plan
|
|
| Greensombrero 2006-10-24, 6:37 pm |
| I'm having a strange error when I try and backup several databases using a
maintenance plan. The first couple will backup but then I get the following
error:
Failed:(-1073548784) Executing the query "BACKUP DATABASE
& #91;TfsWorkItemTrack
ing] TO DISK =
N'\\\\jefferson\\Tea
mFoundationServer\\F
ull\\\\TfsWorkItemTr
acking_backup_200610
120942.bak'
WITH NOFORMAT, NOINIT, NAME = N'TfsWorkItemTrackin
g_backup_20061012094
246',
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 2006-10-24, 6:37 pm |
| I had the same problem.
Run system service "SQL Server FullText Search (MSSQLSERVER)" and backup
should start to work
"Greensombrero" wrote:
> I'm having a strange error when I try and backup several databases using a
> maintenance plan. The first couple will backup but then I get the following
> error:
>
> Failed:(-1073548784) Executing the query "BACKUP DATABASE
> & #91;TfsWorkItemTrack
ing] TO DISK =
> N'\\\\jefferson\\Tea
mFoundationServer\\F
ull\\\\TfsWorkItemTr
acking_backup_200610
120942.bak'
> WITH NOFORMAT, NOINIT, NAME = N'TfsWorkItemTrackin
g_backup_20061012094
246',
> 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
>
|
|
|
|
|