Can't change filegroup
Hello
I'm having problems with selecting a filegroup for the fulltext catalog.
how should i fix this?
Failed to finish full-text operation. Filegroup 'FULLTEXT' is empty,
read-only, or not online. (Microsoft SQL Server, Error: 9964)
.
Relevant Pages
- Re: SQL Server 2005 - filegroup backup/restore problem
... I still have a problem of empty table after last backup/restore+recovery. ... now I can recover the database and make it online. ... Say that there is a SalesOrder table which is in the Primary group. ... If the filegroup would be available after the filegroup restore, ...
(comp.databases.ms-sqlserver) - stripe single file to multiple files
... When adding files to a database's filegroup. ... add a 3rd file, empty the main file, empty and drop the 3rd file ... Is there a common best practice to use here? ...
(microsoft.public.sqlserver.datawarehouse) - Empty data files completely?
... Is there a way to completely empty some data files in the same filegroup so ... remove RmEaMkOnViEoTHvIoS from my email ...
(microsoft.public.sqlserver.server) - Re: Cant delete filegroup, even though it is empty
... Then use ALTER DATABASE to remove the filegroup. ... > I have a SQL 2000 database that I had created a seperate file group for to ... > cannot be removed because it is not empty' ...
(microsoft.public.sqlserver.server) - RE: filegroup
... You can move data to a different filegroup by rebuilding the clustered index ... When you have moved all your tables you can use the 'Alter database' command ... As you noted the filegroup must be empty first. ...
(microsoft.public.sqlserver.server) |
|
