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.
| Author |
Topic |
|
ksheikh
Starting Member
4 Posts |
 Posted - 2011-07-20 : 07:38:48
|
| Hi, We have migrated one of our database (Size 50+GB) from SQL 2005 to SQL 2008. when we tried to take a backup, it failed with following messageMsg 3636, Level 16, State 2, Line 1An error occurred while processing 'BackupMetadata' metadata for database id 21 file id 65537.Msg 3046, Level 16, State 2, Line 1Inconsistent metadata has been encountered. The only possible backup operation is a tail-log backup using the WITH CONTINUE_AFTER_ERROR or NO_TRUNCATE option.Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally.When we looked into the sys.database_files we found that there is some Full TEXT catalog file 'sysft_Catalog_Opm_Topics' (ID:65537) is missing which is physically not present. However looking into sys.master_files, there is no such file. We tried to remove this file by following commandALTER database [dbname] REMOVE FILE sysft_Catalog_Opm_TopicsBut we got following error:Msg 5020, Level 16, State 1, Line 1The primary data or log file cannot be removed from a database.We are unable to find the solution as the backup process for this Database is very important for our business needs. Our hosting team has opened this issue with Microsoft but didn't heard back yet. However i saw this problem was posted even in 2007 so there must be some solution of it. Can any one help?Thank you.Khurram. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-07-21 : 06:53:01
|
| What does DBCC CheckDB return ?Also try dropping the full text catalog and then taking a backup.PBUH |
 |
|
|
ksheikh
Starting Member
4 Posts |
Posted - 2011-07-21 : 08:27:05
|
| DBCC returns no errors and i mentioned above that when i try to drop the catalog it gives an error. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-07-21 : 08:36:44
|
I dont see anywhere you had mentioned that you tried to drop the full text catalog.and the drop catalog syntax looks something like this Drop FullText Catalog CatalogName PBUH |
|
|
|
ksheikh
Starting Member
4 Posts |
Posted - 2011-07-21 : 09:00:19
|
| There is no such catalog in database. If i run this command, i get this errorMsg 7641, Level 16, State 4, Line 1Full-Text catalog 'sysft_Catalog_Opm_Topics' does not exist in database [dbname] or user does not have permission to perform this action. |
|
|
|
Sachin.Nand
2937 Posts |
|
|
ksheikh
Starting Member
4 Posts |
Posted - 2011-07-21 : 09:40:03
|
| No, it doesn't work. |
|
|
|
|
|
|
|
|
Backup failed due to orphan FULL Text Catalog