Post reply

The BackUP of the file Group of file is not permitted

  • December 15, 2008 at 9:18 pm

    #383581

    I have a DataBase with name called "Emp", when i perform Database backup it shows The file is not in Online Please choose file or fileGroup to perform back up.

    please help me.....................

    Suresh

  • December 15, 2008 at 9:48 pm

    #912931

    How are you performing the backup. Are you using SSMS or T-SQL? Does the database show as online in SSMS?

  • December 15, 2008 at 10:11 pm

    #912938

    I am using SSMS, can you please help us....

  • December 15, 2008 at 10:45 pm

    #912945

    You are not really providing much information.

    In SSMS, does the database show as online?

    What are you trying to accomplish here? Why a filegroup backup, why not a full backup?

  • December 16, 2008 at 12:26 am

    #912965

    Hi

    My DataBase Name is "EMP"

    The following are the steps to reproduce:

    1.Right Click on EMP and select TASKS BackUp option it opens BackUp window

    2.BackUp type is FULL

    3.BackUp Component FULL

    4.Destination Disk

    5.then Choose ADD Button

    6.Then Browse a file for saving and provide file name for backup

    7.Then click on OK

    8.Then click on OK Button in Database BackUp window

    9.Gives Error

    10.Error Occured

    Thanks

    Please help me...

  • December 16, 2008 at 12:31 am

    #912968

    Is the database online?

    Can you try and run a backup from the query window -

    BACKUP DATABASE Emp TO DISK = ' Full path to backup file here '

    If it gives an error, please paste the entire error.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 16, 2008 at 1:49 am

    #912986

    yes database is online....

  • December 16, 2008 at 2:38 am

    #912999

    Can you try and run a backup from the query window -

    BACKUP DATABASE Emp TO DISK = ' Full path to backup file here '

    If it gives an error, please paste the entire error.

    did you try that?

    what was the result?


    Pradeep Singh

  • December 16, 2008 at 3:03 am

    #913006

    Error Message:

    Sql Statement:

    BACKUP DATABASE wowzzy TO DISK = 'C:\www\wowzzy\Backupfiles\Prod_Dec_Backup\DecDBDackUp'

    Msg 3007, Level 16, State 1, Line 1

    The backup of the file or filegroup "wowzzytest" 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.

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    Please .....

  • December 16, 2008 at 3:26 am

    #913014

    suresh.maddali (12/16/2008)

    yes database is online....

    Are all the filegroups in the database online and readable?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 16, 2008 at 3:30 am

    #913018

    Gail, i searched and it seems the problem may be due of Full Text Catalog and database was perhaps upgraded from 2000 to 2005... not too sure on this..

    http://www.mydatabasesupport.com/forums/sqlserver-programming/188494-backup-help.html

    http://social.msdn.microsoft.com/forums/en-US/sqldisasterrecovery/thread/2ebcefec-16cd-483d-9e60-ebe3fd7d043d/

    http://www.redmountainsw.com/wordpress/archives/sql%20-express-2005-unable-to-backup-database#comments


    Pradeep Singh

  • December 16, 2008 at 4:04 am

    #913028

    How do i know all the files are in Online ?

    please i am new for DBA

  • December 16, 2008 at 4:10 am

    #913032

    I am NEW FOR DBA Please how do i know which files or filegroups are in online?

    Please..........

  • December 16, 2008 at 4:40 am

    #913044

    suresh.maddali (12/16/2008)

    I am NEW FOR DBA Please how do i know which files or filegroups are in online?

    No need to repeat yourself... Is there a senior DBA there?

    Query sys.database_files for that DB. Check the state is online. Or use this query

    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

    Additionally, do you have any full text catalogs?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 18, 2008 at 12:33 am

    #914324

    yes, I have full text Catalogs also.

    And i ran querry what i receive in this port it shows all are ONLINE.

    PRIMARYROWS_FILEGROUPwowzzytestC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\wowzzytest.mdfONLINE

    NULLNULLwowzzytest_logC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\wowzzytest_log.ldfONLINE

    PRIMARYROWS_FILEGROUPsysft_Profile_CatelogC:\www\wowzzy\FullTextSearch\Profiles\Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_Coupon_catelogC:\www\wowzzy\FullTextSearch\Coupons\Coupon_catelogONLINE

    PRIMARYROWS_FILEGROUPsysft_AE_Profile_CatelogC:\www\wowzzy\FullTextSearch\AE_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_AA_Profile_CatelogC:\www\wowzzy\FullTextSearch\AA_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_AD_Profile_CatelogC:\www\wowzzy\FullTextSearch\AD_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_V_AE_NewCatelogC:\www\wowzzy\FullTextSearch\V_AE_NewCatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_AK_Profile_CatelogC:\www\wowzzy\FullTextSearch\AK_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_AL_Profile_CatelogC:\www\wowzzy\FullTextSearch\AL_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_AP_Profile_CatelogC:\www\wowzzy\FullTextSearch\AP_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_AR_Profile_CatelogC:\www\wowzzy\FullTextSearch\AR_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_AS_Profile_CatelogC:\www\wowzzy\FullTextSearch\AS_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_AZ_Profile_CatelogC:\www\wowzzy\FullTextSearch\AZ_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_CO_Profile_CatelogC:\www\wowzzy\FullTextSearch\CO_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_CT_Profile_CatelogC:\www\wowzzy\FullTextSearch\CT_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_DC_Profile_CatelogC:\www\wowzzy\FullTextSearch\DC_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_DE_Profile_CatelogC:\www\wowzzy\FullTextSearch\DE_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_FL_Profile_CatelogC:\www\wowzzy\FullTextSearch\FL_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_FM_Profile_CatelogC:\www\wowzzy\FullTextSearch\FM_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_GA_Profile_CatelogC:\www\wowzzy\FullTextSearch\GA_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_GU_Profile_CatelogC:\www\wowzzy\FullTextSearch\GU_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_HI_Profile_CatelogC:\www\wowzzy\FullTextSearch\HI_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_IA_Profile_CatelogC:\www\wowzzy\FullTextSearch\IA_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_ID_Profile_CatelogC:\www\wowzzy\FullTextSearch\ID_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_IL_Profile_CatelogC:\www\wowzzy\FullTextSearch\IL_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_IN_Profile_CatelogC:\www\wowzzy\FullTextSearch\IN_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_KS_Profile_CatelogC:\www\wowzzy\FullTextSearch\KS_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_KY_Profile_CatelogC:\www\wowzzy\FullTextSearch\KY_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_LA_Profile_CatelogC:\www\wowzzy\FullTextSearch\LA_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_MA_Profile_CatelogC:\www\wowzzy\FullTextSearch\MA_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_MD_Profile_CatelogC:\www\wowzzy\FullTextSearch\MD_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_ME_Profile_CatelogC:\www\wowzzy\FullTextSearch\ME_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_MH_Profile_CatelogC:\www\wowzzy\FullTextSearch\MH_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_MI_Profile_CatelogC:\www\wowzzy\FullTextSearch\MI_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_MN_Profile_CatelogC:\www\wowzzy\FullTextSearch\MN_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_MO_Profile_CatelogC:\www\wowzzy\FullTextSearch\MO_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_MP_Profile_CatelogC:\www\wowzzy\FullTextSearch\MP_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_MS_Profile_CatelogC:\www\wowzzy\FullTextSearch\MS_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_MT_Profile_CatelogC:\www\wowzzy\FullTextSearch\MT_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_NC_Profile_CatelogC:\www\wowzzy\FullTextSearch\NC_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_NE_Profile_CatelogC:\www\wowzzy\FullTextSearch\NE_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_NH_Profile_CatelogC:\www\wowzzy\FullTextSearch\NH_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_NJ_Profile_CatelogC:\www\wowzzy\FullTextSearch\NJ_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_NM_Profile_CatelogC:\www\wowzzy\FullTextSearch\NM_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_NV_Profile_CatelogC:\www\wowzzy\FullTextSearch\NV_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_NY_Profile_CatelogC:\www\wowzzy\FullTextSearch\NY_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_OH_Profile_CatelogC:\www\wowzzy\FullTextSearch\OH_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_Ok_Profile_CatelogC:\www\wowzzy\FullTextSearch\Ok_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_OR_Profile_CatelogC:\www\wowzzy\FullTextSearch\OR_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_PA_Profile_CatelogC:\www\wowzzy\FullTextSearch\PA_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_PR_Profile_CatelogC:\www\wowzzy\FullTextSearch\PR_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_PW_Profile_CatelogC:\www\wowzzy\FullTextSearch\PW_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_RI_Profile_CatelogC:\www\wowzzy\FullTextSearch\RI_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_SC_Profile_CatalogC:\www\wowzzy\FullTextSearch\SC_Profile_CatalogONLINE

    PRIMARYROWS_FILEGROUPsysft_SD_Profile_CatelogC:\www\wowzzy\FullTextSearch\SD_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_TN_Profile_CatelogC:\www\wowzzy\FullTextSearch\TN_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_TX_Profile_CatelogC:\www\wowzzy\FullTextSearch\TX_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_UT_Profile_CatelogC:\www\wowzzy\FullTextSearch\UT_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_VA_Profile_CatelogC:\www\wowzzy\FullTextSearch\VA_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_VI_Profile_CatelogC:\www\wowzzy\FullTextSearch\VI_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_VT_Profile_CatelogC:\www\wowzzy\FullTextSearch\VT_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_WA_Profile_CatelogC:\www\wowzzy\FullTextSearch\WA_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_WI_Profile_CatelogC:\www\wowzzy\FullTextSearch\WI_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_WV_Profiles_CatelogC:\www\wowzzy\FullTextSearch\WV_Profiles_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_WY_Profile_CatelogC:\www\wowzzy\FullTextSearch\WY_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_ND_Profiles_CatelogC:\www\wowzzy\FullTextSearch\ND_Profiles_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_V_AK_NewCatelogC:\www\wowzzy\FullTextSearch\V_AK_NewCatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_CA_Profile_CatelogC:\www\wowzzy\FullTextSearch\CA_Profile_CatelogONLINE

    PRIMARYROWS_FILEGROUPsysft_CA_Profile_Catelog1C:\www\wowzzy\FullTextSearch\CA_Profile_Catelog1ONLINE

    PRIMARYROWS_FILEGROUPsysft_CA_Profile_Catelog2C:\www\wowzzy\FullTextSearch\CA_Profile_Catelog2ONLINE

    Above is out Put

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

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