April 8, 2009 at 7:06 pm
Anyone know what databases control the full text search my systems people cannot start the services and saying they are rebuilding the entire SQL Server and all databases need to be restored.
Anyone got any ideas before this is done this seems a rather hugh tasks to under take.
Is the full text search a system database ? can it be reinstalled just by selecting this on the components when installing sql ?
Cheers
April 8, 2009 at 7:20 pm
I am not sure I understand you but Full Text Service is in configuration manager and if you don't have access to it something is wrong with your employer's policies because you need to make sure all needed services are running at least once a week. So go into configuration manager and turn it on and then you could just right click on the table and configure and the catalog population options are in the configuration wizard.
You must know if the service is not on configuring the service does not mean you are running the service.
Kind regards,
Gift Peddie
April 8, 2009 at 7:36 pm
The service will not start after we rolled the cluster let me go check and see what the guys are telling me ....and to check the policies.
April 8, 2009 at 7:49 pm
There are base accounts requirement for SQL Server Service, Agent and Full Text so check below and make the relevant account changes you can change the account by right clicking on the service and go to properties. Check below for details.
http://msdn.microsoft.com/en-us/library/ms179530(SQL.90).aspx
Kind regards,
Gift Peddie
April 9, 2009 at 6:02 am
It seems that the registry settings are corrupt.
Systems group saying they will rebuild the SQL Server instance.
So when this gets installed the master file needs to be restored from backup.
We are on a cluster setup
Steps...shutdown Node
--Find Instance and do the following in DOS
K:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>sqlservr -m
sqlcmd –E
RESTORE DATABASE master
FROM DISK ='K:\BACKUPS\master.bak';
GO
---will shutdown sql
--in query analyzer
--MSDB DATABASE
RESTORE DATABASE MSDB
FROM DISK = 'T:\BACKUPS\msdb.bak'
--MODEL DATABASE
RESTORE DATABASE MODEL
FROM DISK = 'T:\BACKUPS\model.bak'
WITH REPLACE
Then i can just attach all other databases.
Did i miss anything on the restore of master databases.
April 9, 2009 at 6:13 am
i think, you hv to check users' rights (if ur server is on remote machine) for each n every authenticated users for different sql server services.
"Don't limit your challenges, challenge your limits"
April 9, 2009 at 6:23 am
They have checked this and telling me the registry settings are damaged.
April 9, 2009 at 6:35 am
R u going to reinstall it?
"Don't limit your challenges, challenge your limits"
April 9, 2009 at 6:47 am
It seems that the registry settings are corrupt.
Systems group saying they will rebuild the SQL Server instance.
So when this gets installed the master file needs to be restored from backup.
I don't understand why you and your systems people did not go through that cluster check list I posted before setting up a cluster because the separate account for each service was number 18 of the checklist. I think you need to spend time with the BOL for all you need to know before you do anything. The reason if your registry is corrupted you may need to manually uninstall everything and start over, and I also think you need to create backup devices to restore your Master database because if you don't get it right nothing will work in your installation.
Kind regards,
Gift Peddie
April 9, 2009 at 7:44 am
This was all working in PRODUCTION and yesterday it got corrupt the registry settings.
They have been on phone with MS i am just preparing for the restores.
This is what i just got told yesterday so i need to get all the databases back after they wipe it all out and reinstall it.
April 9, 2009 at 11:39 am
The full text service has been removed completely and there no way to just reinstall this part on the SQL even if you forget to install it when setting up SQL too.........Anyone know of this seems rather odd.
April 9, 2009 at 12:14 pm
I think I know the reason since the cluster install require domain account with relevant permissions the 2005 setup does what it usually do remove items from setup without relevant requirements. That is how it disables SSRS if you don't have IIS installed. I think you could repair the install when you create the account just remember to backup all databases including SSRS and all system databases before the repair.
Kind regards,
Gift Peddie
April 9, 2009 at 3:20 pm
Hmm do a repair is that an option on the disk ........i don't recall seeing it or is that a command line action.
Worth shot at repair rather than uninstall and reinstall it again
April 9, 2009 at 3:24 pm
No I am not telling you to run command line anything rerun setup from your C drive and choose repair when you get to choose components choose all that you need because I don't see how you can run production without Full Text because most people look to improve the existing implementation.
Kind regards,
Gift Peddie
April 9, 2009 at 3:51 pm
Let me try that on a test somehow delete it and if i can resinstall it.
Is cluster so maybe difference with cluster.
Thanks
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply