September 27, 2010 at 12:37 pm
When I am trying to do a back up, I get the following error:
The data of the file or filegroup "sysft" is not permited because it is not online. BACKUP CAN BE PERFORMETED by using the filegroup or file clauses to restrict the selection to include only online data.
What should I do?
Thank you
September 27, 2010 at 12:46 pm
You have a file or filegroup offline.
You would need to run a command like this to get it back online..substituting your db name of course:
ALTER DATABASE [DB_NAME] MODIFY FILE (NAME = sysft_sugar_fts_catalog, ONLINE);
GO
edit: I should mention that it would be wise to find out why this file/group was offline to begin with, if you should bring it back online, etc.
September 27, 2010 at 12:56 pm
If it will not come back online, you need to find a database backup that has the filegroup online. Then you would need to work out a method to get the data in that filegroup synced with a "restored" backup of the data.
You should also investigate to find what caused the problem.
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
September 27, 2010 at 1:10 pm
I get this error:
Msg 155, Level 15, State 1, Line 1
'ONLINE' is not a recognized CREATE/ALTER DATABASE option.
September 27, 2010 at 1:11 pm
Please post the command you issued - exactly as you typed it.
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
September 27, 2010 at 1:12 pm
You're right. There actually is no way to set the file back to online without restoring it from a backup. ref: http://msdn.microsoft.com/en-us/library/bb522469.aspx
edit: Odd that it behaves like this. This is one of the very, very few one-way streets in SQL.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply