Error trying to backup database in SQL 2005

Can someone please tell me what this gibberish is about? Trying to backup
database in SQL 2005. Life used to be simple under 2000
Thanks.
TITLE: Microsoft SQL Server Management Studio
--
Backup failed for Server 'MENGYUAN6'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The backup of the file or filegroup
"sysft_ix_STS_mengyuan6_2085264542" 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)
For help, click:
http://go.microsoft.com/fwlink?Prod...>
LinkId=20476
BUTTONS:
OK
--The way I read it is this: You're doing a full DB backup but one of the
filegroups making up your database is offline (specifically the
filegroup called "sysft_ix_STS_mengyuan6_2085264542"). Either bring all
the filegroups online before doing your DB backup or backup individual
filegroups one at a time.
*mike hodgson*
http://sqlnerd.blogspot.com
Kim Ellis wrote:

>Can someone please tell me what this gibberish is about? Trying to backup
>database in SQL 2005. Life used to be simple under 2000
>Thanks.
>
>TITLE: Microsoft SQL Server Management Studio
>--
>Backup failed for Server 'MENGYUAN6'. (Microsoft.SqlServer.Smo)
>For help, click:
>http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
>--
>ADDITIONAL INFORMATION:
>System.Data.SqlClient.SqlError: The backup of the file or filegroup
>"sysft_ix_STS_mengyuan6_2085264542" 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)
>For help, click:
>http://go.microsoft.com/fwlink?Prod...
&LinkId=20476
>--
>BUTTONS:
>OK
>--
>
>|||Mike, Thanks. What is it? Some system index file? How do I bring it online?
Where does it come from? I have never encountered it before SQL 2005. Any
elaboration will be greatly appreciated.
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message
news:%23JI0SEcaGHA.4548@.TK2MSFTNGP04.phx.gbl...
> The way I read it is this: You're doing a full DB backup but one of the
> filegroups making up your database is offline (specifically the
> filegroup called "sysft_ix_STS_mengyuan6_2085264542"). Either bring all
> the filegroups online before doing your DB backup or backup individual
> filegroups one at a time.
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Kim Ellis wrote:
>
>|||You can read about files & filegroups in BOL:
Physical Database Files and Filegroups
<http://msdn2.microsoft.com/en-us/li...8SQL.90%29.aspx>
They're basically the building blocks (albeit the larger ones - extents
& pages being the smaller ones) of a SQL Server database (and have been
for several SQL Server versions now). This is not new to SQL 2005 but
it looks a bit different because the GUI tools are using .net framework
components now so the error message is very ".net"ish.
You can backup individual files & filegroups using the BACKUP statement:
How To: Back Up Files and Filegroups (Transact-SQL)
<http://msdn2.microsoft.com/en-us/li...8SQL.90%29.aspx>
An offline file (if that is indeed what the problem is) can only be
brought online by restoring that file from a backup (see the note about
the OFFLINE <filespec> property in the ALTER DATABASE
<http://msdn2.microsoft.com/en-us/library/ms174269.aspx> statement in BOL).
To get information about the filegroups in your database you can query
the sys.filegroups
<http://msdn2.microsoft.com/en-us/library/ms187782.aspx> catalog view
(in the context of the database). To get information about the files
making up those filegroups in your database you can query the
sys.database_files
<http://msdn2.microsoft.com/en-us/library/ms174397.aspx> catalog view
(in the context of the database) - this will also tell you the
ONLINE/OFFLINE state of each file making up your DB.
Hope this helps.
*mike hodgson*
http://sqlnerd.blogspot.com
Kim Ellis wrote:

>Mike, Thanks. What is it? Some system index file? How do I bring it online?
>Where does it come from? I have never encountered it before SQL 2005. Any
>elaboration will be greatly appreciated.
>"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message
>news:%23JI0SEcaGHA.4548@.TK2MSFTNGP04.phx.gbl...
>
>
>|||My guess is that it is your full-text index catalog (which is treated as a f
ile group in 2005).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kim Ellis" <kimellis@.mengyuan.com.au> wrote in message
news:%23xTe9%23eaGHA.4196@.TK2MSFTNGP03.phx.gbl...
> Mike, Thanks. What is it? Some system index file? How do I bring it online
? Where does it come
> from? I have never encountered it before SQL 2005. Any elaboration will be
greatly appreciated.
> "Mike Hodgson" <e1minst3r@.gmail.com> wrote in message
> news:%23JI0SEcaGHA.4548@.TK2MSFTNGP04.phx.gbl...
>|||hello Kim Ellis this is Mario Andres.[vbcol=seagreen]
I have the same problem :
/////////////////////////////////////////////////////////////
Error de Copia de seguridad para Servidor D (Microsoft.SqlServer.Smo)
Para obtener ayuda, haga clic en:
http://go.microsoft.com/fwlink?Prod...r&ProdVer=3D9.=
00.1399.00&EvtSrc=3DMicrosoft.SqlServer.Management.Smo.ExceptionTemplates.F=
ailedOperationExceptionText&EvtID=3DCopia+de+seguridad+Server&LinkId=3D20476
--
INFORMACI=D3N ADICIONAL:
System.Data.SqlClient.SqlError: La copia de seguridad del archivo o el
grupo de archivos "sysft_ix_STS_srvntpta_573554118_4427" no se permite
porque no tiene conexi=F3n. No se puede ejecutar BACKUP con las
cl=E1usulas FILEGROUP o FILE para restringir la selecci=F3n de modo que
s=F3lo se incluyan datos con conexi=F3n. (Microsoft.SqlServer.Smo)
Para obtener ayuda, haga clic en:
http://go.microsoft.com/fwlink?Prod...r&ProdVer=3D9.=
00.1399.00&LinkId=3D20476
--
///////////////////
Did you solved? can you tell me what can I do? please hel me.
bye.|||Mario, If you find out how to solve the problem, please let me know. If I
work out how to solve it, I will let you know. So far I have read a lot, but
have not been able to solve it. Since it prevents a backup, one would think
Microsoft would have published a solution, but if they have, I have not been
able to find it. Regards, Kim.
"Wario" <marioandres05@.gmail.com> wrote in message
news:1146661667.891376.248710@.j33g2000cwa.googlegroups.com...
hello Kim Ellis this is Mario Andres.[vbcol=seagreen]
I have the same problem :
/////////////////////////////////////////////////////////////
Error de Copia de seguridad para Servidor D (Microsoft.SqlServer.Smo)
Para obtener ayuda, haga clic en:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
--
INFORMACIN ADICIONAL:
System.Data.SqlClient.SqlError: La copia de seguridad del archivo o el
grupo de archivos "sysft_ix_STS_srvntpta_573554118_4427" no se permite
porque no tiene conexin. No se puede ejecutar BACKUP con las
clusulas FILEGROUP o FILE para restringir la seleccin de modo que
slo se incluyan datos con conexin. (Microsoft.SqlServer.Smo)
Para obtener ayuda, haga clic en:
http://go.microsoft.com/fwlink?Prod...>
LinkId=20476
--
///////////////////
Did you solved? can you tell me what can I do? please hel me.
bye.|||Kim & Mario,
Do you have a full-text catalog on your DB? If so, have you tried
rebuilding it (and then doing a full backup to see if the backup now
works)? Have you tried dropping your FT catalog (and then doing a full
backup to see if the backup now works)? Have you verified if the
problem is associated with full-text or not?
*mike hodgson*
http://sqlnerd.blogspot.com
Kim Ellis wrote:

>Mario, If you find out how to solve the problem, please let me know. If I
>work out how to solve it, I will let you know. So far I have read a lot, bu
t
>have not been able to solve it. Since it prevents a backup, one would think
>Microsoft would have published a solution, but if they have, I have not bee
n
>able to find it. Regards, Kim.
>"Wario" <marioandres05@.gmail.com> wrote in message
>news:1146661667.891376.248710@.j33g2000cwa.googlegroups.com...
>hello Kim Ellis this is Mario Andres.
>
> I have the same problem :
>/////////////////////////////////////////////////////////////
>Error de Copia de seguridad para Servidor D (Microsoft.SqlServer.Smo)
>Para obtener ayuda, haga clic en:
>http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
>--
>INFORMACIN ADICIONAL:
>System.Data.SqlClient.SqlError: La copia de seguridad del archivo o el
>grupo de archivos "sysft_ix_STS_srvntpta_573554118_4427" no se permite
>porque no tiene conexin. No se puede ejecutar BACKUP con las
>clusulas FILEGROUP o FILE para restringir la seleccin de modo que
>slo se incluyan datos con conexin. (Microsoft.SqlServer.Smo)
>Para obtener ayuda, haga clic en:
>http://go.microsoft.com/fwlink?Prod...
&LinkId=20476
>--
>///////////////////
>Did you solved? can you tell me what can I do? please hel me.
>bye.
>
>|||Mr Aras told me this...
and it help.
It was the full-search catalogs that was cusing this, I went into the
SQL 2000 original database, killed those and then backed up teh
database and restored it into SQL 2005 and had it quickly rebuild the
catalogs.
Hoep this helps.
Kim Ellis ha escrito:

> Mario, If you find out how to solve the problem, please let me know. If I
> work out how to solve it, I will let you know. So far I have read a lot, =
but
> have not been able to solve it. Since it prevents a backup, one would thi=
nk
> Microsoft would have published a solution, but if they have, I have not b=
een
> able to find it. Regards, Kim.
> "Wario" <marioandres05@.gmail.com> wrote in message
> news:1146661667.891376.248710@.j33g2000cwa.googlegroups.com...
> hello Kim Ellis this is Mario Andres.
> I have the same problem :
> /////////////////////////////////////////////////////////////
> Error de Copia de seguridad para Servidor D (Microsoft.SqlServer.Smo)
> Para obtener ayuda, haga clic en:
> http://go.microsoft.com/fwlink?Prod...ver&ProdVer=3D=
9=2E00.1399.00&EvtSrc=3DMicrosoft.SqlServer.Management.Smo.ExceptionTemplat=
es.FailedOperationExceptionText&EvtID=3DCopia+de+seguridad+Server&LinkId=3D=
20476
> --
> INFORMACI=D3N ADICIONAL:
> System.Data.SqlClient.SqlError: La copia de seguridad del archivo o el
> grupo de archivos "sysft_ix_STS_srvntpta_573554118_4427" no se permite
> porque no tiene conexi=F3n. No se puede ejecutar BACKUP con las
> cl=E1usulas FILEGROUP o FILE para restringir la selecci=F3n de modo que
> s=F3lo se incluyan datos con conexi=F3n. (Microsoft.SqlServer.Smo)
> Para obtener ayuda, haga clic en:
> http://go.microsoft.com/fwlink?Prod...ver&ProdVer=3D=
9=2E00.1399.00&LinkId=3D20476
> --
> ///////////////////
> Did you solved? can you tell me what can I do? please hel me.
> bye.|||I gave up trying to work out what was going on technically, and in disgust
just plain deleted the index file. SQL 2005 sprang to life and everything
that was broken or stupid, came good and worked.
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message
news:u0tcDm9bGHA.1260@.TK2MSFTNGP05.phx.gbl...
> Kim & Mario,
> Do you have a full-text catalog on your DB? If so, have you tried
> rebuilding it (and then doing a full backup to see if the backup now
> works)? Have you tried dropping your FT catalog (and then doing a full
> backup to see if the backup now works)? Have you verified if the
> problem is associated with full-text or not?
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Kim Ellis wrote:
>
>