Restoring DB with fulltext index to another server: index recreation steps?

When a database with fulltext indexes is restored to a different
server, what are the appropriate steps to take, and in what order,
to recreate the indexes on the new machine if it has a different
directory structure than the original server? Should the indexes
be removed and then recreated? Any problem removing the index if
the native file-system files cannot be located? The native file-
system index files are not brought over to the new machine as part
of the backup/restore process, is that right?
Thanks
TR
TR,
The best source of info on this is the KB article 240867 (Q240867) "INF: How
to Move, Copy, and Backup Full-Text Catalog Folders and Files" at
http://support.microsoft.com/default...b;EN-US;240867 This KB
article should answer most of your questions. However, in regards to the
following questions:
1. Any problem removing the index if the native file-system files cannot be
located?
A. It would be best to drop the FT Catalog prior to backing up the database
in this case.
2. The native file-system index files are not brought over to the new
machine as part of the backup/restore process, is that right?
A. That is correct. However, this will change in SQL Server 2005 (Yukon) as
the SQL Server backup & restore processes will be altered to include the FT
Catalog folder and files in the SQL Server 2005 database backup file.
Regards,
John
"TR" <TR@.anonymous.biz> wrote in message
news:MPG.1b2ba884d2593bac9896f7@.msnews.microsoft.c om...
> When a database with fulltext indexes is restored to a different
> server, what are the appropriate steps to take, and in what order,
> to recreate the indexes on the new machine if it has a different
> directory structure than the original server? Should the indexes
> be removed and then recreated? Any problem removing the index if
> the native file-system files cannot be located? The native file-
> system index files are not brought over to the new machine as part
> of the backup/restore process, is that right?
> Thanks
> TR

Restoring DB for files...

Hi
In order to copy a database from a server to a server, I cant detach the database as there are many users connected to it. The transaction log is large file while the data is about 46 MB, I made a backup for the data file only, zipped it and copied it to the target server.
Ex: the name of the source DB on the source server is x, the file I took as a backup for is x-data
From the Enterprise Manager, right-click the x DB, All tasks, Backup database, in the backup option click the File and Filegroup option and chose the primary file group with x_data file.
Then, I created a new database name it y with y_data , y_log files on primary filegroup. I want to restore my backup to have the DB x on my target server,
I tried:
RESTORE DATABASE y
FILE = 'y_data',
FILEGROUP = 'primary'
FROM disk= 'E:\VMS\DBFiles\test'
GO

But it did not work. Any help?

Thanks,what is the error you are getting ?

Restoring databases

Hi NG,
I have to backup several different databases, where the user can choose the
names of the backup image (bck).
In order to restore the correct database I have to distinguish between these
database images. I cannot assume that the backup image name says anything
about the database content. The user just likes to select a database image
file (bck) and restore it automatically. I solved this first by adding file
properties, but unfortunately such additional information got lost wehn
copying a backup image file to a USB memory stick.
My idea now is to write into the backup image with the DESCRIPTION option of
the BACKUP DATABASE command.
How can I retrieve this DESCRIPTION information in order to restore it to
the correct database?
Any idea?
thanks rene
You probably don't have to add anything. Just use RESTORE HEADERONLY to get database name etc from
the backup set.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Re Fo" <xrefox@.xnospamxesec.com> wrote in message news:%23tv73Kq3EHA.2804@.TK2MSFTNGP15.phx.gbl...
> Hi NG,
> I have to backup several different databases, where the user can choose the
> names of the backup image (bck).
> In order to restore the correct database I have to distinguish between these
> database images. I cannot assume that the backup image name says anything
> about the database content. The user just likes to select a database image
> file (bck) and restore it automatically. I solved this first by adding file
> properties, but unfortunately such additional information got lost wehn
> copying a backup image file to a USB memory stick.
> My idea now is to write into the backup image with the DESCRIPTION option of
> the BACKUP DATABASE command.
> How can I retrieve this DESCRIPTION information in order to restore it to
> the correct database?
> Any idea?
> thanks rene
>

Restoring databases

Hi NG,
I have to backup several different databases, where the user can choose the
names of the backup image (bck).
In order to restore the correct database I have to distinguish between these
database images. I cannot assume that the backup image name says anything
about the database content. The user just likes to select a database image
file (bck) and restore it automatically. I solved this first by adding file
properties, but unfortunately such additional information got lost wehn
copying a backup image file to a USB memory stick.
My idea now is to write into the backup image with the DESCRIPTION option of
the BACKUP DATABASE command.
How can I retrieve this DESCRIPTION information in order to restore it to
the correct database?
Any idea?
thanks reneYou probably don't have to add anything. Just use RESTORE HEADERONLY to get database name etc from
the backup set.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Re Fo" <xrefox@.xnospamxesec.com> wrote in message news:%23tv73Kq3EHA.2804@.TK2MSFTNGP15.phx.gbl...
> Hi NG,
> I have to backup several different databases, where the user can choose the
> names of the backup image (bck).
> In order to restore the correct database I have to distinguish between these
> database images. I cannot assume that the backup image name says anything
> about the database content. The user just likes to select a database image
> file (bck) and restore it automatically. I solved this first by adding file
> properties, but unfortunately such additional information got lost wehn
> copying a backup image file to a USB memory stick.
> My idea now is to write into the backup image with the DESCRIPTION option of
> the BACKUP DATABASE command.
> How can I retrieve this DESCRIPTION information in order to restore it to
> the correct database?
> Any idea?
> thanks rene
>

Restoring database with different sorting order

I am trying to restore a database (SQL server 7) with
sort ID 183 on a SQL server 7 with sort order ID 52.
I got this error message:
Microsoft SQL-DMO (ODBC SQLState: 42000):
The database you are attempting to restore was backed up
under different sort order ID(183) than the one currently
running on this server (52), and at least one of them is
a non-binary sort order.
Backup or restore operation terminating abnormally.
Any help please to restore this database on my server.
thanks
Database developerI'm afriad there is no way to restore different sort orders in SQL 7.
You could use DTS to transfer all objects over.
HTH
Ryan Waight, MCDBA, MCSE
"Database Developer" <database_udvikler@.hotmail.com> wrote in message
news:0c8301c38f0e$2d3ef280$a101280a@.phx.gbl...
> I am trying to restore a database (SQL server 7) with
> sort ID 183 on a SQL server 7 with sort order ID 52.
> I got this error message:
> Microsoft SQL-DMO (ODBC SQLState: 42000):
> The database you are attempting to restore was backed up
> under different sort order ID(183) than the one currently
> running on this server (52), and at least one of them is
> a non-binary sort order.
> Backup or restore operation terminating abnormally.
>
> Any help please to restore this database on my server.
> thanks
> Database developer|||Thank you Ryan for your quick reply.
Greetings
Database developer
>--Original Message--
>I'm afriad there is no way to restore different sort
orders in SQL 7.
>You could use DTS to transfer all objects over.
>
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Database Developer" <> wrote in message
>news:0c8301c38f0e$2d3ef280$a101280a@.phx.gbl...
>> I am trying to restore a database (SQL server 7) with
>> sort ID 183 on a SQL server 7 with sort order ID 52.
>> I got this error message:
>> Microsoft SQL-DMO (ODBC SQLState: 42000):
>> The database you are attempting to restore was backed
up
>> under different sort order ID(183) than the one
currently
>> running on this server (52), and at least one of them
is
>> a non-binary sort order.
>> Backup or restore operation terminating abnormally.
>>
>> Any help please to restore this database on my server.
>> thanks
>
>.
>