Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Rebuilding full-text catalogs in SQL Server 2005 for the Helpdesk DB

Updated: 21 May 2010 | 1 comment
Vinh Huynh's picture
0 0 Votes
Login to vote

We moved our Incident DB from a SQL2000 to a SQL2005 SP2 server. Does anyone know if we rebuild the DB, will it cause any problem to the helpdesk?

Right now, we are having failures in a BackupExec because it is a full-text catalogs in the SQL2005.

discussion Filed Under:

Comments

Eisenkarl's picture
20
Apr
2009
0 Votes 0
Login to vote

Hi, plese refer the

Hi,

plese refer the KB-article 40605 for further informations.
I've done this with the Altiris database, but the steps for the altiris_inicidents database are the same, I think.

Dont't forget the Backup (with SQL Management Studio (or Enterprise Manager) before you start with the migration. Also the collation must be the same on both SQL-Servers.

Regards,

Eisenkarl