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 |
|
sven2
Yak Posting Veteran
57 Posts |
 Posted - 2009-12-23 : 04:01:09
|
| Hello,when I try to make a backup from my sql database I get the following error:Inconsistent metadata has been encountered.How can I solve this problem? There is almost no data in the database ...Best regards,Sven. |
|
|
sven2
Yak Posting Veteran
57 Posts |
Posted - 2009-12-23 : 06:01:53
|
| Hello,this is the error message ...TITLE: Microsoft SQL Server Management Studio Express------------------------------Backup failed for Server 'PPBE01-133\SQLEXPRESS'. ------------------------------ADDITIONAL INFORMATION:System.Data.SqlClient.SqlError: An error occurred while processing 'BackupMetadata' metadata for database id 5 file id 65537. (Microsoft.SqlServer.Express.Smo) |
 |
|
|
sven2
Yak Posting Veteran
57 Posts |
Posted - 2009-12-23 : 06:07:36
|
| Hello,I run on the failing DB:select * from sys.database_files and I get 2 files Id = 65537 and 65538 that have the statusFULLTEXT in the column type_descIs this normal?Both of the files are offline! Is there a way to drop these files?Best regards,Sven. |
|
|
|
sven2
Yak Posting Veteran
57 Posts |
Posted - 2009-12-23 : 12:01:48
|
| Hello,is there a way to force a backup?I removed all the data and stil then i get an error!Thanks in advance,Sven. |
|
|
|
|
|
|
backup