I come up with another solution like moving all the objects and data in to another data base for the corrupeted one. I have not used old data base.

Hi,

you just do the following steps.

Attach the data base --> Right click on Data base and choose attach. before this we need to complete following

...

Hi,

Yes, I am able to access the data base through GUI.

I had done all the operations on the data base except Data base backup.

Thanks,

Suresh

Hi Pradeep,

Following is the result for u r querry.

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

Name State Description

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

employeetest 0ONLINE

employee_log0ONLINE

I removed all full...

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...

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....

Thanks for u r reply.

But one thing,

i have indevidual files backup like (.mdf file, .log).

And restore the databse based on that mdf and log files.

It working fine. no...

I dont have full back up.

That is what my problem. When i want to take a backup it shows u r mdf file is not online.

when i am taking backup it shows .mdf file is not on-line, can u say how to bring .mdf file into on-line

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

Very Very thanks, i got solution by your great advise.

Thanks again.

Pradeep provides Good links but my problem is not solved.......

One Thing:

My .mdf, .log file names are

wowzzytest.mdf, wowzzytest.log files, error occured like

wowzzytest is not online, but when we...

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

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

Please..........

How do i know all the files are in Online ?

please i am new for DBA