The backup of the file or filegroup "CCT_MSCRM" is not permitted because it is not online

Question

The backup of the file or filegroup "CCT_MSCRM" is not permitted because it is not online

Viewing 4 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply

chris.caines Old Hand Points: 348 More actions · Answer 1

Interesting fact and partially related to your second suggestion, if I detach, copy and reattach the database to a different SQL server, I can back it up fine. So, I'm thinking there is something, somewhere within the SQL system tables which is returning a status of offline to the backup routine and it's not checking the database at all.

Where I go from here though, I haven't the foggiest!

SQLRNNR SSC Guru Points: 281344 More actions · Answer 2

chris.caines (8/6/2011)
Interesting fact and partially related to your second suggestion, if I detach, copy and reattach the database to a different SQL server, I can back it up fine. So, I'm thinking there is something, somewhere within the SQL system tables which is returning a status of offline to the backup routine and it's not checking the database at all.
Where I go from here though, I haven't the foggiest!

Interesting, there could be another place besides the places we have asked you to check. Usually by checking those though - it can be determined and fixed.

Time (for me) to research some more

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

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 3

chris.caines (8/6/2011)
Interesting fact and partially related to your second suggestion, if I detach, copy and reattach the database to a different SQL server, I can back it up fine. So, I'm thinking there is something, somewhere within the SQL system tables which is returning a status of offline to the backup routine and it's not checking the database at all.
Where I go from here though, I haven't the foggiest!

Call Microsoft. It sounds like this could be related to a bug.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

chris.caines Old Hand Points: 348 More actions · Answer 4

All,

Thanks for the suggestions. In the intervening time we didn't really get anywhere with this (amongst other head scratching from MS and Partners) so we opted to reattach the database to a new server which instantly cured the problem.

Obviously this will bug me now until my grave, but in the end sometimes you run out of time!

Cheers.