Error running report: 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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
--
BUTTONS:
OK
--This is a multi-part message in MIME format.
--090909050607010708070209
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
>--
>BUTTONS:
>OK
>--
>
>
--090909050607010708070209
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>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</tt><tt>"). Either
bring all the filegroups online before doing your DB backup or backup
individual filegroups one at a time.</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson 
<a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a>

</div>
 
 
Kim Ellis wrote:
<blockquote cite="midOI3FO9baGHA.4580@.TK2MSFTNGP03.phx.gbl" type="cite">
<pre wrap="">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:
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476</a>">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476</a>
--
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:
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476</a>">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476</a>
--
BUTTONS:
OK
--
</pre>
</blockquote>
</body>
</html>
--090909050607010708070209--|||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:
>>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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
>>--
>>BUTTONS:
>>OK
>>--
>>
>>
>|||This is a multi-part message in MIME format.
--020703080600060407070601
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
You can read about files & filegroups in BOL:
Physical Database Files and Filegroups
<http://msdn2.microsoft.com/en-us/library/ms179316%28SQL.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/library/ms179401%28SQL.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...
>
>>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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
>>--
>>BUTTONS:
>>OK
>>--
>>
>>
>>
>
>
--020703080600060407070601
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>You can read about files & filegroups in BOL: 
<a
href="http://links.10026.com/?link=Physical">http://msdn2.microsoft.com/en-us/library/ms179316%28SQL.90%29.aspx">Physical
Database Files and Filegroups</a> 
 
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: 
<a
href="http://links.10026.com/?link=How">http://msdn2.microsoft.com/en-us/library/ms179401%28SQL.90%29.aspx">How
To: Back Up Files and Filegroups (Transact-SQL)</a> 
 
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 <a
href="http://links.10026.com/?link=ALTER">http://msdn2.microsoft.com/en-us/library/ms174269.aspx">ALTER
DATABASE</a> statement in BOL). 
 
To get information about the filegroups in your database you can query
the <a href="http://links.10026.com/?link=sys.filegroups</a>">http://msdn2.microsoft.com/en-us/library/ms187782.aspx">sys.filegroups</a>
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 <a
href="http://links.10026.com/?link=sys.database_files</a>">http://msdn2.microsoft.com/en-us/library/ms174397.aspx">sys.database_files</a>
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. 
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson 
<a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a>

</div>
 
 
Kim Ellis wrote:
<blockquote cite="mid%23xTe9%23eaGHA.4196@.TK2MSFTNGP03.phx.gbl"
type="cite">
<pre wrap="">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" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:e1minst3r@.gmail.com"><e1minst3r@.gmail.com></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:%23JI0SEcaGHA.4548@.TK2MSFTNGP04.phx.gbl">news:%23JI0SEcaGHA.4548@.TK2MSFTNGP04.phx.gbl</a>...
</pre>
<blockquote type="cite">
<pre wrap="">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*
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a>
Kim Ellis wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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:
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476</a>">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476</a>
--
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:
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476</a>">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476</a>
--
BUTTONS:
OK
--
</pre>
</blockquote>
</blockquote>
<pre wrap=""> I have the same problem :
/////////////////////////////////////////////////////////////
Error de Copia de seguridad para Servidor D (Microsoft.SqlServer.Smo)
Para obtener ayuda, haga clic en:
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Copia+de+seguridad+Server&LinkId=20476</a>">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Copia+de+seguridad+Server&LinkId=20476">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Copia+de+seguridad+Server&LinkId=20476</a>
--
INFORMACIÓN 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ón. No se puede ejecutar BACKUP con las
cláusulas FILEGROUP o FILE para restringir la selección de modo que
sólo se incluyan datos con conexión. (Microsoft.SqlServer.Smo)
Para obtener ayuda, haga clic en:
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476</a>">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476">http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476</a>
--
///////////////////
Did you solved? can you tell me what can I do? please hel me.
bye.
</pre>
</blockquote>
</body>
</html>
--080405040208020407000703--|||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?ProdName=3DMicrosoft+SQL+Server&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?ProdName=3DMicrosoft+SQL+Server&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:
>>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.
>>
>>--
>>
>> 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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Copia+de+seguridad+Server&LinkId=20476
>>--
>>INFORMACIÓN 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ón. No se puede ejecutar BACKUP con las
>>cláusulas FILEGROUP o FILE para restringir la selección de modo que
>>sólo se incluyan datos con conexión. (Microsoft.SqlServer.Smo)
>>Para obtener ayuda, haga clic en:
>>http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476
>>--
>>///////////////////
>>Did you solved? can you tell me what can I do? please hel me.
>>bye.
>>
>>
>|||The fix for this took me a while to find - I obviously had a moment of
"idiot" and was making it too complicated.
This is it people: The magic:
sp_fulltext_database enable
Run Query against your db - backup and move on with life
Woo hoo!!
Ian
"Wario" wrote:
> 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 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.
> > > >>--
> > 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?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Copia+de+seguridad+Server&LinkId=20476
> > --
> > INFORMACIÃ?N 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Ã³n. No se puede ejecutar BACKUP con las
> > clÃ¡usulas FILEGROUP o FILE para restringir la selecciÃ³n de modo que
> > sÃ³lo se incluyan datos con conexiÃ³n. (Microsoft.SqlServer.Smo)
> >
> > Para obtener ayuda, haga clic en:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476
> > --
> > ///////////////////
> >
> > Did you solved? can you tell me what can I do? please hel me.
> > bye.
>

Friday, February 24, 2012

Error trying to backup database in SQL 2005

No comments:

Post a Comment

Error running report

Blog Archive

About Me