Post reply

The backup of a file or file group is not online

  • November 12, 2009 at 11:22 pm

    #216701

    Hi All,

    I have .mdf, .log files all those files are online, I conform with the following querry

    select fg.name as FilegroupName, fg.type_desc as FileGroupType, df.name as FileName, df.physical_name, df.state_desc

    from sys.database_files df left outer join sys.filegroups fg on df.data_space_id = fg.data_space_id

    [/center][/left]

    But i am uable to take back up, Please help me, it's important.

    Note: I dont have full back up.

  • November 13, 2009 at 1:08 am

    #1078729

    Hi Suresh,

    What is the error that you get while taking the backup?

    Regards,

    Pradeep Adiga

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • November 13, 2009 at 1:27 am

    #1078734

    How you are trying to take backup..?

    What error are you geting.?

  • November 13, 2009 at 1:34 am

    #1078736

    Thanks Pradeep for u r quick response.

    Error Message:

    Backup failed for server 'Employee'

    System.data.sqlclient. Sqlerror: The backup of the file or folegroup 'Emplyeetest' is not permitted because it is not online. Backup can be performed by using the FILEGROUP or FILE clauses to restrict the

    selection to include only online data.(Microsoft .sqlserver.Smo)

    Emplyeetest is My MDF file name.

  • November 13, 2009 at 1:35 am

    #1078737

    I am trying to take back up by using back up wizard.

    Error Message:

    Backup failed for server 'Employee'

    System.data.sqlclient. Sqlerror: The backup of the file or folegroup 'Emplyeetest' is not permitted because it is not online. Backup can be performed by using the FILEGROUP or FILE clauses to restrict the

    selection to include only online data.(Microsoft .sqlserver.Smo)

    Emplyeetest is My MDF file name.

  • November 13, 2009 at 2:13 am

    #1078750

    Hi Suresh,

    On the outset I feel that the FULL TEXT index which you might have created earlier is OFFLINE. You can try deleting it under "FULL TEXT CATALOGS" in SSMS.

    This query might help you to locate the OFFLINE one in that database

    select name, state, state_desc from sys.database_files

    Hope this helps !

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • November 13, 2009 at 2:22 am

    #1078754

    Hi Pradeep,

    Following is the result for u r querry.

    ...................................................

    Name State Description

    ................................................

    employeetest 0ONLINE

    employee_log0ONLINE

    I removed all full text indexes and catalogs, I have only mdf and log files

Viewing 7 posts - 1 through 6 (of 6 total)

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