Re: Sql Server 2005 and FTS backup
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Mon, 24 Apr 2006 09:34:23 -0400
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
--
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
"Frédérick Jacquet" <nospam@xxxxxxxxxxxx> wrote in message
news:OiVN2IVZGHA.508@xxxxxxxxxxxxxxxxxxxxxxx
Hi
Howto do a sqlserver 2005 backup WITHOUT the FTS catalog using BACKUP
DATABASE TO DISK T-SQL Command ?
Regards,
Frédérick
.
- References:
- Sql Server 2005 and FTS backup
- From: Frédérick Jacquet
- Sql Server 2005 and FTS backup
- Prev by Date: Re: Is full-text search what I am looking for? (Newbie)
- Next by Date: Re: relevance sorting with multiple search terms?
- Previous by thread: Sql Server 2005 and FTS backup
- Next by thread: How to use CONTAINS to search words partially?
- Index(es):
Relevant Pages
|
