Sql Server 2005 and FTS backup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frédérick Jacquet - 21 Apr 2006 15:45 GMT

Hi

Howto do a sqlserver 2005 backup WITHOUT the FTS catalog using BACKUP
DATABASE TO DISK T-SQL Command ?

Regards,
Frédérick

Reply to this Message

Hilary Cotter - 24 Apr 2006 14:34 GMT

Basically its a file group backup. Here is an example. I have a single
filegroup called primary. My database name is fulltext, by default the files
inside my primary file group are called fulltext and the full-text catalog
file is called sysft_MyCatalogName where MyCatalogName is the name of my
full-text catalog.

So my backup statement would look like this:

BACKUP DATABASE [fulltext] FILE = N'fulltext' TO DISK =
N'c:\FullTextBak.bak' WITH NOFORMAT, NOINIT, NAME =
N'fulltext-Full File Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi
>
[quoted text clipped - 3 lines]
> Regards,
> Frédérick

Reply to this Message