| Author |
Topic |
|
psteja2000
Starting Member
9 Posts |
 Posted - 2004-09-13 : 09:49:51
|
| Hi,server: mssql 8.0I haven't done server administration before but right now my task is to get a database up and running. The server previously crashed and they could scavenge all the mdf,ldfs. This is on a client site and the ones incharge there reinstalled sqlserver with previous settings. But the problem is, they have installed in different paths now. The master db I think has references to paths and drives that don't exist. The main problem is, one of the databases needs fulltext search to be enabled. in the list of catalogs, it shows one, but the path is no longer valid. I tried creating a new catalog using the sp_fulltext_database to enable it but it would complain that the path doesn't exist. Will someone plz tell me what to do :(Still waiting guys....Basically what happened is this, I think whoever that took the backup of the database by "detach"ing, didn't know that it has fulltext search enabled. I have read somewhere that detaching the database will not take care of the catalogs. So now I am in soup, with the database up and running, the catalog path refering to a non existant location. I cann't even delete the catalog and build a new one because it complains that the fulltext search is not enabled for the database. But it wouldn't let me enable it. Any pointers are greatly appreciated. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-14 : 22:19:45
|
| >> took the backup of the database by "detach"ingShould be shot. There's a reason that the backup statement is named backup.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-15 : 07:43:54
|
| Backup the database (real backup this time), detach the database, enable fulltext searching, attach the database, delete the catalog, recreate the catalog, fire someone.You might want to move the last step up the chain somewhat.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
psteja2000
Starting Member
9 Posts |
Posted - 2004-09-15 : 09:45:48
|
| Hi Derrick,thanks for the reply.. I did exactly what you told me to but it wouldn't let me delete the catalog. It comes up witha msg saying full-text search is not enabled for the database yet (which is because the path it shows for the catalog is non existent.). What do I do?thanks,Teja |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-15 : 20:07:51
|
| And can you enable full-text search for the database now?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
psteja2000
Starting Member
9 Posts |
Posted - 2004-09-16 : 10:54:21
|
| No, it is not enabled for hte database. If I try to enable it, it still comes up with msg saying the path is not valid. It doesn't let me do anything on the catalog. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-16 : 11:38:57
|
| Personally, I would call Microsoft PSS. It's $210 per call. If you don't want to do that, try deleting the entries manually out of the system tables.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
psteja2000
Starting Member
9 Posts |
Posted - 2004-09-17 : 13:20:52
|
| Thanks a lot derrick.. I think it will also have to do with registry entries??? |
|
|
|
psteja2000
Starting Member
9 Posts |
Posted - 2004-09-27 : 18:12:07
|
| Hello,Can anyone plz tell me how to configure the db such that ad hoc updates to the system catalogs can be done? The problem is, a database has full text search disabled, but has a catalog which points to a invalid location. One of the system tables for the database has the record where it stores the location. I wish to remove this record completely. So then I can start building a new catalog from scratch. So my task is to configure the database such that I can run a delete statement on that table. Any help is greatly appreciated..regards |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-27 : 19:49:01
|
| Sp_configure 'allow updates', 1 Reconfigure with override==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
psteja2000
Starting Member
9 Posts |
Posted - 2004-09-30 : 09:38:19
|
| Back to square one.. After lot of digging around, I found a record in sysfulltextcatalogs table where the path column has the invalid path. Because it didn't allow me to delete/rebuild/repopulate/enable the fulltext catalog previously because of this invalid path, I simply used reconfigured the db to allow ad hoc updates and deleted the record (may be stupid thing to do.. but atleast I don't see the path any more). Now, when I try to build a new catalog for the database, it comes up msg saying. "Full text catalog '' has been lost. Use sp_full.... to rebuild and repopulate...." But if I do all this using he wizard or any other way still it comes up with the same message at the end of the process..Is there no way that I can completely remove all the links to the old fulltext catalog and build a new one?? IS THERE NO SOLUTION?? :(( |
|
|
|
|
backup messup...