Failed to Pause Catalog - can''t find this error anywhere!

  • Hi All,

    First off, let me thank anyone who replies to this.  I've posted the errors in a bunch of different places, but so far, no help 🙁

    When using SQL Server Management Studio, trying to backup my SPS2003 (Sharepoint Portal Server) database (SPS_SITE), i get the following error:

    Backup failed for Server 'SERVERNAME'. (Microsoft.SqlServer.Smo)

    Additional Information:

    System.Data.SQLClient.SqlError:  Failed to pause the catalog for backup.  Backup was aborted. (Microsoft.SqlServer.Smo)

    I can't get the database to backup in any program, whether a 3rd party thing, the official Sharepoint Backup and Restore program, nor can i export the database, or use the 'copy database' function in SQL Management Studio.  It all seems to come back to this 'Failed to pause the catalog for backup'.

    There are the 'Show technical details' of the error:

    Program Location:

       at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

       at Microsoft.SqlServer.Management.SqlManagerUI.BackupPropOptions.OnRunNow(Object sender) 

    And again, Program Location:

       at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)

       at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)

       at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

    It's funny that i can use this database without problems, but i cannot back it up, make a copy, or export it!

    Any help would be greatly appreciated.  I can't find ANY information about this error online.  My backups haven't worked since a restore a couple of months ago!  Furthermore, i need to move the database!  Eeek!

    Thanks!

    Brent McCulloch

  • Tell please - what is your OS\SP

    and SP for Sql server 2005- edition\version too

    Make sure it is SP1-

    check if SPS2003 is OK about the Sql server 2005 SP1

    also - what are your sql server permissions on the box?

    also - what NT account's permissions under what your Sql server services are running?

    Does the NT login - has NTFS permissions to use Backup destination?

     

    ---One more -

    can you check if there is not another sql server backup (for example from Tape backup SW) is running?

     

    Can you backup on the sql server any DB?

    Can you create new one and to try to backup it?

    Can you try to backup from T-Sql Code?

  • Hi Eugene,

    Thanks for your message!

    The server is Windows 2003 Server Standard Edition (64-bit).  The SQL is SQL 2005 without SP1.

    The version information is SQL Server 9.0.2047.

    The database permissions are all NT type.  I am using a domain admin account with DBO access on the database to attempt the backup.  The SQL service is running as "Local System".

    The NT login definitely has NTFS permissions where the file is being backed up to.  I have tried a couple of different destinations incase there was something funny.

    There are no other SQL backups running at that time.

    The SQL server has about 15 different databases, and they ALL back up without any problems, except for this one!  (SPS_SITE - sharepoint portal server 2003 data repository)

    I can create new databases in general, and then successfully back them up, but i cannot make a copy or export of the SPS_SITE database in any way (that i know of!)

    I don't know T-SQL code... so, i'm not sure if i could back it up that way or not...

    Maybe i could back it up with T-SQL code, then restore it to a different database, and then perhaps that new database would back up properly?  Is that what you were thinking?

    Thanks!

    Brent McCulloch.

  • Hi, i'm having this same problem as well, this appears to be the only page on google that has any related info, hopefully someone can help us out here!

  • This sounds like a bug to me more than a technical problem. I saw your post on the Microsoft tech forum as well. You might consider posting this under the Microsoft SQL Database Engine forum, rather than the tools (where you did post), as the problem may stem from the engine rather than the gui itself. To test this, you can run the Backup Database command (see below for syntax example) directly as a query and see if you get the same error:

     

    BACKUP DATABASE SPS_SITE TO DISK = 'C:\whateverpathyouchoose\SPS_SITE_Backup.bkp' WITH STATS = 10

     

    See what error you get in the Query window. This might give you something new to research. If you get the same thing, I'd seriously consider calling Microsoft for support.

    Also, when you say there isn't a current backup running on this database, did you check this using the gui? or did you run sp_who2 in the query window to see what processes show up in the results window?

    Lezza

  • Hi Lezza,

    Thanks for your response!  i tried running the BACKUP DATABASE command through a query window, and got this result:

    Msg 7694, Level 16, State 1, Line 1

    Failed to pause catalog for backup. Backup was aborted.

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    :'(

    I will post on this on the sql engine section.

    Also, i checked the current jobs in the SQL gui, to ensure that a backup wasn't already running...  sp_who2 indicates that SPS_SITE is sleeping...

    Thanks,

    Brent.

     

  • Don't know if this is still important to anyone, but I encountered this exact error today when trying to backup.  As in the orginal post above, my SQL server does NOT have sp1 installed. 

    I discovered the solution, at least a partial one - I had disabled the Full Text service a couple of days ago.  The backup was failing ever since.  So once I turned the service back on, the backup happened just fine.

    I did notice that the database was set to "use full-text indexing."  But when I deselect that option (even while the service is turned on) the backup error returns. 

    So this last part is a bit of a mystery.  I will continue to dig in and try to resolve it, and when I do I will post it here.  But of course if you have already solved it I welcome your post.  Of course I will eventually upgrade my server to sp1, but I didn't see this bug on the sp1 fix list. 

    Thanks

    Paul

     

     

    - Paul

    http://paulpaivasql.blogspot.com/

  • Thanks Paul!!!

    I will try that today!

    Cheers,

    Brent McCulloch

  • Woooooooooo!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Paul, thanks so much!!!!

    Turns out the problem was because the FullTextSearch was running under the Network Service account.  Trying your solution revealed a different error, this time access denied.  So, I changed that FullTextSearch service to use 'Local System' as the account, and after re-enabling it on the database, i'm able to take a backup!!!!

    Thanks again! I'd been struggling with this problem for weeks!

    Brent McCulloch

  • I had the same problem... Thanks!

  • I hope this helps:

    I was able to locate the offending index (from the error message within the sql logs) and rebuilt it using the SQL Server 2005 Management Studio GUI.  This allowed me to backup the database with no further errors.

     

     


    Matika Y. Garrison
    OPERS

  • I had this same problem and my Full Text service was turned off - turned it on and backup was successful.  Thanks for the quick and easy fix.

  • when you backup the database, the backup job also want to backup data of full-text index. if the full-text index has been stop or don't have priority, the error will occur.

  • I too had this issue, seems one should not change the full text service through the services gui or a wmi script.  instead Use SQL Server Configuration Manager to reapply the changes to the SQL Server Service Account. This enables permissions to be checked when the Full-Text Search Service starts.

    http://msdn2.microsoft.com/en-us/library/aa337365.aspx

    (and make sure FT and SQL server are same accounts)


    Cheers,

    Todd

  • check out if the full text sql service is running

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply