Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pitmanfan
Starting Member
25 Posts |
 Posted - 2007-06-25 : 06:52:47
|
| i'm trying to backup a database with a full-text catalogue and keep getting the following errorMsg 7694, Level 16, State 1, Line 1Failed to pause catalog for backup. Backup was aborted.Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally.the account thats running the full text service and doing the backup has permission to the directory where the catalogue is stored.any ideas?thanks!! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-25 : 06:57:05
|
| your catalog seems to be in use while you're trying to back up your db. you have to stop using it for the duration of the backup_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
pitmanfan
Starting Member
25 Posts |
Posted - 2007-06-25 : 07:16:49
|
| in BOL, it says the service is temporarily suspended when a backup is started. i thought this would stop it being in use. i've also tried to stop the service and changing it to manual but it automatically starts again and the backup fails.... |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-25 : 08:01:45
|
| do you have an open transaction that's using the full text while you're trying to do a backup?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
pitmanfan
Starting Member
25 Posts |
Posted - 2007-06-25 : 09:22:16
|
| doesnt look like theres any open trans.as a workaround i'm backing the database up with the file = <logical name> option and it seems to work. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-25 : 09:25:50
|
| interesting...how were you backing it up before?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
pitmanfan
Starting Member
25 Posts |
Posted - 2007-06-25 : 09:54:59
|
| backup database <db_name> to disk = '<disk location>'added in the file = <logical name> and it seems to work.doing a restore filelistonly shows the fulltext catalogue has been backed up aswell.... :-/ |
|
|
|
|
|
|
backing up a db with a full-text catalogue