move the fulltext catalog while restoring the back

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

move the fulltext catalog while restoring the back

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-06-27 : 04:48:02

Hi All,
I have a backup file with full text index,while restoring the DB i need to move the .mdf,.ldf and fulltext file to different disk drive.
How we can do this.

Thanks,
Gangadhara

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-27 : 05:16:48

http://morten.lyhr.dk/2010/01/how-to-restore-to-another-database-with.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-06-28 : 02:18:31

Thanks you i have used move db option and its workign fine for me.

Thanks for your support Visakh

Thanks,
Gangadhara MS
SQL Developer and DBA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-28 : 02:31:22

you're welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources