I have what I believe to be a bizarre scenario.
I have a series of databases that I've backed up and restored onto another
machine.
However, the full text catalogues were not included in the backup...should
they have been?
I see that the catalogues are actually stored in the folder
MSSQL/FTDATA/ - would it have been sufficient to have simply copies this
data across or does it need to be rebuilt locally?
I ask because I am creating a nightly job to backup the databases on
serverA, copy them to serverB and then restore them. I could use ROBOCOPY
to copy the contents of /MSSQL/FTDATA/ too if required.
Thanks
Griffhave a look at this kb article for more information on restored full text
catalogs with databases
http://support.microsoft.com/defaul...kb;en-us;240867
"GriffithsJ" <GriffithsJ_520@.hotmail.com> wrote in message
news:#0iD5B6#DHA.2804@.tk2msftngp13.phx.gbl...
> I have what I believe to be a bizarre scenario.
> I have a series of databases that I've backed up and restored onto another
> machine.
> However, the full text catalogues were not included in the backup...should
> they have been?
> I see that the catalogues are actually stored in the folder
> MSSQL/FTDATA/ - would it have been sufficient to have simply copies this
> data across or does it need to be rebuilt locally?
> I ask because I am creating a nightly job to backup the databases on
> serverA, copy them to serverB and then restore them. I could use ROBOCOPY
> to copy the contents of /MSSQL/FTDATA/ too if required.
> Thanks
> Griff
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment