NDF File in a Secondary File group was lost

Thanks Uri for your reply, but I dont have backup and It doesn´t matter. My
question is: I need the put the database online without a secondary
filegroup. I know that SQL SERVER retain that information about the data
files in a header page in *.mdf file and in the master database. Hence my
doubt is how I do for the change that information in a header page in
*.mdf?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ukbO2yAiDHA.2448@.TK2MSFTNGP12.phx.gbl...
> > claudio
> > Do you have a last backup of your database?
> > Please refer to BOL for more details about how to perfom restore
> filegroups
> > and files.
> >
> >
> > "claudio" <claudio.lucio&SPAM@.coresynesis.com.br> wrote in message
> > news:eMYwYb3hDHA.336@.tk2msftngp13.phx.gbl...
> > > Hi people,
> > > I have a big problem here. I have one database with the following
> > > configuration:
> > > 1- Primary FileGroup - teste.mdf
> > > 2- Secondary FileGroup - teste.ndf
> > >
> > > My trouble is: I lost my datafile that belongs to Secondary FileGroup.
I
> > > don´t need to recover my data in teste.ndf, but my database was in
> > Suspect
> > > State and I need to change to Online State.
> > > What Should I do?
> > >
> > > thanks
> > >
> > >
> >
> >
>
>Assuming you didn't get my reply due to ng problems, here's a reply:
You probably cannot do that, at least there's no documented, supported way. Opening a case with MS
Support *might* help. Another option can be to set the db in emergency mode (search google etc for
how to do it and more info) to be able to get to your data.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"claudio" <claudio.lucio&SPAM@.coresynesis.com.br> wrote in message
news:%23npbmhPiDHA.752@.TK2MSFTNGP12.phx.gbl...
> Thanks Uri for your reply, but I dont have backup and It doesn´t matter. My
> question is: I need the put the database online without a secondary
> filegroup. I know that SQL SERVER retain that information about the data
> files in a header page in *.mdf file and in the master database. Hence my
> doubt is how I do for the change that information in a header page in
> *.mdf?
>
>
> > "Uri Dimant" <urid@.iscar.co.il> wrote in message
> > news:ukbO2yAiDHA.2448@.TK2MSFTNGP12.phx.gbl...
> > > claudio
> > > Do you have a last backup of your database?
> > > Please refer to BOL for more details about how to perfom restore
> > filegroups
> > > and files.
> > >
> > >
> > > "claudio" <claudio.lucio&SPAM@.coresynesis.com.br> wrote in message
> > > news:eMYwYb3hDHA.336@.tk2msftngp13.phx.gbl...
> > > > Hi people,
> > > > I have a big problem here. I have one database with the following
> > > > configuration:
> > > > 1- Primary FileGroup - teste.mdf
> > > > 2- Secondary FileGroup - teste.ndf
> > > >
> > > > My trouble is: I lost my datafile that belongs to Secondary FileGroup.
> I
> > > > don´t need to recover my data in teste.ndf, but my database was in
> > > Suspect
> > > > State and I need to change to Online State.
> > > > What Should I do?
> > > >
> > > > thanks
> > > >
> > > >
> > >
> > >
> >
> >
>