Back-up faild - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

Back-up faild

Author

Topic

bsanders
Starting Member

3 Posts

Posted - 2009-05-29 : 17:38:23

My database is not backing up I get the following errors when trying a manual backup:

BACKUP DATABASE [NonstopMusic]
TO DISK = N'E:\Backups\NSM05-29-2009.bak' WITH NOFORMAT, INIT,
NAME = N'NonstopMusic-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

Error:

Msg 9987, Level 16, State 1, Line 1
The backup of full-text catalog 'Phrase_Catalog' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally

The phrase catalog is working just fine since the site is not down. What's happening here?

Here is the series of errors in the error log "\MSSQL\Log" when attempting a back up:

(Where is the "backup application log" by the way?)

2009-05-29 14:31:31.82 spid59 Error: 3633, Severity: 16, State: 1.
2009-05-29 14:31:31.82 spid59 The operating system returned the error '2(The system cannot find the file specified.)' while attempting 'CreateFile' on 'G:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\NonstopMusic_2.Phrase_Catalog\SQL.HDR' at 'fulltext.cpp'(529).

2009-05-29 14:31:31.83 Backup Error: 3041, Severity: 16, State: 1.
2009-05-29 14:31:31.83 Backup BACKUP failed to complete the command BACKUP DATABASE NonStopMusic. Check the backup application log for detailed messages.

2009-05-29 14:33:49.81 spid59 Error: 3633, Severity: 16, State: 1.
2009-05-29 14:33:49.81 spid59 The operating system returned the error '2(The system cannot find the file specified.)' while attempting 'CreateFile' on 'G:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\NonstopMusic_2.Phrase_Catalog\SQL.HDR' at 'fulltext.cpp'(529).

2009-05-29 14:33:49.81 Backup Error: 3041, Severity: 16, State: 1.
2009-05-29 14:33:49.81 Backup BACKUP failed to complete the command BACKUP DATABASE NonStopMusic. Check the backup application log for detailed messages.

2009-05-29 14:37:47.61 spid63 Error: 3633, Severity: 16, State: 1.
2009-05-29 14:37:47.61 spid63 The operating system returned the error '2(The system cannot find the file specified.)' while attempting 'CreateFile' on 'G:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\NonstopMusic_2.Phrase_Catalog\SQL.HDR' at 'fulltext.cpp'(529).

2009-05-29 14:37:47.61 Backup Error: 3041, Severity: 16, State: 1.
2009-05-29 14:37:47.61 Backup BACKUP failed to complete the command BACKUP DATABASE NonstopMusic. Check the backup application log for detailed messages.

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2009-05-29 : 22:27:51

can you do a manual backup of database and it definately on line.
Can you backup to a local drive. Do you have enough space.

bsanders
Starting Member

3 Posts

Posted - 2009-05-30 : 18:06:08

Manual back-up does not work. I think I may need to rebuild the phrase catalog, but I've had problems with that before too. What I will do is use our stage db, move all the data from live to stage, point the sight to stage and then try the rebuild...

sanjayzalke
Starting Member

1 Post

Posted - 2009-09-04 : 04:37:05

Hi,
You need to rebuild the catalogue.

USE [NonstopMusic]
EXEC sp_fulltext_database 'enable'

OR

In management studio,

Under databases --> [NonstopMusic] --> Storage --> Full Text Catalogs
Right click [Phrase_Catalog] and select Rebuild

Hopefully this will solve your problem.

Sanjay

bsanders
Starting Member

3 Posts

Posted - 2009-09-04 : 13:25:14

Actually, I tried that and it did not work...

I also had to move all data over to the stage database then I had to point the sight to that database (which did not have the corruption in the catalog). I then made a bk-up of stage and copied onto live. Then pointed back to live db. Thank God for previous backups!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources