Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL SERVER - ADMINISTRATION - BACKUP - FULL TEXT

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-12-11 : 07:56:48
Bernard writes "Hello,

Environment :
. SQL SERVER 2005.
. Cluster.
. Windows 2003.

I have a database with a Full Text Catalog. I created a Plan Maintenance with a schedule. When I executed it I have the following error :

SQL 2005 Backup Failed:(-1073548784)

Any help will be appreciate.

Best regards"

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-12-12 : 15:39:29
Not enough information, I'm afraid, to be of any help.

Ken
Go to Top of Page

vonpato
Starting Member

1 Post

Posted - 2006-12-21 : 13:08:41
I have the same issue:

Executing the query "BACKUP DATABASE [OakwoodBI] TO DISK = N'\\\\OAKWOOD8006s\\SQLBackups6\\DWHPRDDB\\OakwoodBI_backup_200612202030.bak'
WITH NOFORMAT, NOINIT, NAME = N'OakwoodBI_backup_20061220203011', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "The backup or restore was aborted.
BACKUP DATABASE is terminating abnormally.
A severe error occurred on the current command. The results, if any, should be discarded.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I think it's something to do with SQL Server puts double "\" in all over the path for teh backup destination
Go to Top of Page
   

- Advertisement -