At the same time the FTS went down there were some sharepoint sites upgrade to 3.0 to use the search feature for sharepoint. When setting this up does it...

Is there a method for moving databases with catalogs from one server to another.

When viewing sysfulltextcatalogs on test this is path D: but on Production we have no D path.

So...

Thanks for article. Im not sure where to begin but we had some databases for sharepoint and wanted to use the search feature within sharepoint application which is...

Let me try that on a test somehow delete it and if i can resinstall it.

Is cluster so maybe difference with cluster.

Thanks

Ok i just installed SQL 2005 then added a few databases testa, testb and sql logins testalogin testblogin

Then backup master.bak model.bak msdb.bak

Uninstalled the whole sql

Reinstalled the sql again.

Performed the...

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...

Thanks that worked ............

Restored the master.bak using SQLCMD

Brought back up SQL and restored model and msdb using query analyzer

That all worked.

Now to unistall SQL Server instance on test and...

This command

k:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>sqlservr -m

I was trying on a developer edition i assume this only works on enterprise as i tried sqlservr -m sqlservername and it keeps saying instance...

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...

Thanks for the clarification.

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...

Yes that is actually what we doing...same instance name.

They have checked this and telling me the registry settings are damaged.

Cluster Node Instance restore.

One of the clusters has registry edit settings and a rebuild of the instance is needed on Production

So following along i have the steps outlined.

1. install...

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...