September 7, 2006 at 6:42 am
Hy!
I know that SQL Server 2005 also backups full-text catalog when backuping the database. But when it's doing backup it pauses the catalog. In the SQL log it says:
---
Changing the status to PAUSE for full-text catalog "XXX" (8) in database "YYY" (5). This is an informational message only. No user action is required.
---
And after half a minute it resumes it:
---
Changing the status to RESUME for full-text catalog "XXX" (8) in database "YYY" (5). This is an informational message only. No user action is required.
---
I don't like this.
I know there is a possibility to backup only full-text catalog. But is there a possibility to backup only database without full-text catalog.
Thank you!
Tomaz
September 7, 2006 at 8:21 am
I don't think taking only database backup is possible (without FT)
As per BOL
Generally, SQL Server performs these tasks during a BACKUP operation:
1. Temporarily suspends Microsoft Full-Text Engine for SQL Server (MSFTESQL) service and flushes to disk all pending changes to the full-text catalog. Also, SQL Server stops all write activity on the catalog and queues all changes that have not yet been processed at the start of the backup in the notification log so that these changes could be committed to the full-text catalogs when the backup is complete.
The catalog status is persisted on disk. At this point, you can still query the catalog.
2. Backs up all table and full-text catalog data, change tracking log, and metadata.
3. Backs up all data, in the transaction log, that has occurred since the backup process started.
4. Resumes MSFTESQL service as well as the population of full-text indexes.
September 8, 2006 at 4:19 am
Hy!
I read this before.
If I understand this right at point 2. you are not able to query catalog. And after point 4. you are back in business.
So there is no way to hold catalog online all the time. Isn't this a little stupid? As database should go offline when making backup. Grrrrr....
Tomaz
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply