Post reply

Database backups

  • August 7, 2009 at 9:32 am

    #385141

    When I try to backup a database on sqlserver2005,I get the below error message.

    "The backup of full-text catalog 'ix_WSS_Content_Chart' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

    BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  • August 7, 2009 at 12:02 pm

    #1036210

    Sreedevi,

    Read this article.[/url] I think the user is trying to explain the fix for the same issue that you are having. But read carefully before you actually do something.

    I have not faced this issue nor have I tried the methods that are provided there.

    -Roy

  • August 7, 2009 at 12:14 pm

    #1036219

    when i am taking back up it shows my .mdf file is not in online

  • August 10, 2009 at 9:08 pm

    #1037203

    Sreedevi,

    The two possible action that you could do is

    1. Update the system catalog by using alter database command by dropping that filegroup that is offline. So that the system will not look for offline files or missing files when backing up.

    2. Bring that particular filegroup online.

    refer this link for adding or removing a file and filegroup from a database

    http://msdn.microsoft.com/en-us/library/bb522469.aspx

    PS: Pls consider the practicality of your own environment before updating system catalog files or deleting filegroups .

    Cheers

    Leks

Viewing 4 posts - 1 through 3 (of 3 total)

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