Database backup doesn't work (1 Viewer)

Hello,

when I try to make a backup from my sql database I get the following error:</SPAN>

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)


</SPAN>If I run the following query on the failing DB:

select * from sys.database_files

I get 2 files “Id = 65537” and “ID = 65538” that have the status
FULLTEXT in the column type_desc. Both of these files have the status offline!

Is this normal?
And if not, how do I get to change this so that the files are back online.

Thanks in advance,
Sven.

Hi

These are full text index files, does your database use fulltext indexing?

If so then you need to rebuild the full text indexes, else then delete the full text indexes.

Hello,

how can I delete or rebuild these full indexes?

Best regards,
Sven.

You can rebuild or delete fulltext catalogs in mamagement studio under

storage/fulltext catalogs

Hey guys i have also the problem with database. i am just wondering if anyone can tell me what is wrong when i am trying to restore my sql database (sorry if this is in the wrong section but i guess this is the only section that i think this will fit in)

SQL-query:
CREATE TABLE IF NOT EXISTS `e107_banlist` (
`banlist_ip` varchar( 100 ) NOT NULL default '',
`banlist_admin` smallint( 5 ) unsigned NOT NULL default '0',
`banlist_reason` tinytext NOT NULL ,
PRIMARY KEY ( `banlist_ip` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 6