备份没有全文目录的SQL Server 2008数据库

DROP FULLTEXT INDEX ON table1
DROP FULLTEXT INDEX ON table2
DROP FULLTEXT INDEX ON table3


DROP FULLTEXT CATALOG DBFullTextCatalog
EXEC sp_fulltext_database 'disable'

SET @BackupPath = @BackupPath + N'DB_17965_1_backup.bak'
BACKUP DATABASE [DB_17965_1]
TO  DISK = @BackupPath
WITH NOFORMAT, INIT,  NAME = N'DB_17965_1-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

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.
Processed 832 pages for database 'DB_17965_1', file 'CelebrityGet' on file 1.
Processed 8 pages for database 'DB_17965_1', file 'ftrow_CelebritygetFullTextCatalog' on file 1.
100 percent processed.
Processed 1 pages for database 'DB_17965_1', file 'CelebrityGet_log' on file 1.
BACKUP DATABASE successfully processed 841 pages in 0.431 seconds (15.244 MB/sec).