June 22, 2011 at 9:36 am
Is this the article that you were following?
http://support.microsoft.com/kb/923355
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 22, 2011 at 9:39 am
Also, what is the edition, SP, and version (enterprise, standard, other) of this instance?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 22, 2011 at 10:36 am
Thanks for jumping in, guys. I appreciate the assist.
June 23, 2011 at 6:06 am
Jason,
Yes, I've beaten the Full Text Catalogues to death, I think I've tried every possible permutation of advice as to what could be done with the FTC to resolve this issue 🙂
SQLRNNR (6/22/2011)
Also, what is the edition, SP, and version (enterprise, standard, other) of this instance?
SQL Server 2005 Standard SP3 CU8 - 9.00.4285.00
June 23, 2011 at 6:39 am
Chris,
Is this an upgraded database from SQL 2000?
June 23, 2011 at 6:53 am
Brandie Tarvin (6/23/2011)
Chris,Is this an upgraded database from SQL 2000?
No, this was a straight 2005 install originally. The backups have worked a long time in the past, but one day they began to report this issue and we've never been able to resolve since.
June 23, 2011 at 7:06 am
chris.caines (6/23/2011)
Brandie Tarvin (6/23/2011)
Chris,Is this an upgraded database from SQL 2000?
No, this was a straight 2005 install originally. The backups have worked a long time in the past, but one day they began to report this issue and we've never been able to resolve since.
What else has changed on the server? Service packs for SQL or the OS? Changes to the database? Changes to server properties?
June 23, 2011 at 9:01 am
chris.caines (6/23/2011)
Jason,Yes, I've beaten the Full Text Catalogues to death, I think I've tried every possible permutation of advice as to what could be done with the FTC to resolve this issue 🙂
SQLRNNR (6/22/2011)
Also, what is the edition, SP, and version (enterprise, standard, other) of this instance?SQL Server 2005 Standard SP3 CU8 - 9.00.4285.00
Thanks. I just wanted to confirm what troubleshooting steps had been taking so we can gauge a starting point (hence the technet article question).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 23, 2011 at 9:02 am
To verify, You are using native SQL backup, right?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 23, 2011 at 9:05 am
Was a filegroup restore ever performed on this particular database?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 29, 2011 at 2:53 am
To verify, You are using native SQL backup, right?
Yes, all through the Management Studio.
Was a filegroup restore ever performed on this particular database?
No, we've never restored this database, it's been as it is since it was created.
June 29, 2011 at 12:38 pm
Have you by chance tried the modify filegroup suggestion from Brandie?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 29, 2011 at 12:40 pm
Also, try to enable full-text index.
sp_fulltext_database enable
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 1, 2011 at 12:58 am
Hi, really sorry about the long delay to your suggestions.
Have tried both of those. Enabling the Full-Text Index doesn't help resolve the issue.
I think what is most frustrating as every solution I've seen regarding this seems to point to a full-text index issue, but trying any of them still puts me in the same situation of being unable to back up which is why I think it's unrelated.
SQLRNNR (6/29/2011)
Also, try to enable full-text index.
sp_fulltext_database enable
August 1, 2011 at 5:39 am
You have two options at this point. Call Microsoft (recommended) or create a work around.
The work around method is dirty and you will probably forget something (hence the reason I recommend # 1), but this method might help you find the problem.
Script all database objects (Tables, Triggers, Indexes, Logins, etc.) to a new copy of the database (slightly different name). Export all data to the new database. See if a backup of the new database causes the same issue.
It's a lot of work, but you never know what method 2 might uncover.
Viewing 15 posts - 16 through 30 (of 34 total)
You must be logged in to reply to this topic. Login to reply