Create backup of MS SQL 2005 DB without full-text indexes and catalogs

Question

Good day!

My new hosting provider doen't support restoring MS SQL backups with full-text indexes\catalogs inside.

I can't found any way to create a backup without full-text capabilities inside. One way is to drop fulltext catalog and indexes, do a backup and then revert changes back, but if there any better way?

Thanks in advance!

score 0 · Accepted Answer · edited Apr 13 '17 at 12:13

0

This doesn't look like it's that easy or even possible.

https://serverfault.com/questions/1/how-to-exclude-indexes-from-backups-in-sql-server-2008

Never tried it myself but seems an odd request from your hosting provider.

edited Apr 13 '17 at 12:13

Community

1
1

answered Nov 04 '10 at 20:31

MrEdmundo

5,105
13
46
58

I finally drop my index before on a local copy, restore it on the server and recreate it by hand on the server... – artvolk Nov 05 '10 at 08:54

Create backup of MS SQL 2005 DB without full-text indexes and catalogs

1 Answers1