Script to restore backup with Full Text Search

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  January 28, 2014 at 10:46 am

  #303834

  I have a backup script and it has been working fine but now I have a situation where there is a full text search file.

  This is what I used prior to the FT Search being added. It worked fine:

  RESTORE DATABASE DW

  FROM DISK = 'D:\Backup\DW_backup.bak'

  WITH RECOVERY,

  MOVE 'DW' TO 'D:\MSSQL\Data\DW.mdf',

  MOVE 'DW_Objects' TO 'D:\MSSQL\Data\Objects.NDF',

  MOVE 'DW_log' TO 'D:\MSSQL\Log\DW.ldf'

  Now I simply want to add the Text File to the backup:

  D:\MSSQL\Text\TextFile

  What is the syntax please?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  January 28, 2014 at 11:55 am

  #1684027

  I got it, just simply add another line with the logical and physical file name.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/