Thanks, Mark - this was exactly the info I needed! -steve -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mark Yakushev Sent: Wednesday, December 12, 2007 5:10 PM To: [email protected] Subject: Re: [ADSM-L] problem cloning sql server db
Steve, You will need to relocate full-text catalogs also. When relocating databases that contain full-text catalogs, the full text catalog names will also need to be specified as values to /relocate ... /to options. E.g. tdpsqlc restore SQLDB1 /relocate=datafile1,datafile2,log1,sysft_PageCatalog /to=d:\SQLDB1_copy2\datafile1.mdf, d:\SQLDB1_copy2\datafile2.ndf,d:\SQLDB1_copy2\log1.ldf,d:\SQLDB1_copy2\P ageCatalog /into=SQLDB1_copy2 Please note that the full-text catalog logical name is pre-pended with sysft_. In the example above, directory d:\SQLDB1_copy2 has to exist before that restore. Here is the full example. I have a full backups for the database SQLDB1. The database has 2 data files, datafile1 and datafile2, 1 log - log1, and a full-text catalog PageCatalog. C:\Program Files\Tivoli\TSM\TDPSql.524>tdpsqlc q tsm SQLDB1 /all IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server Version 5, Release 2, Level 1.06 (C) Copyright IBM Corporation 1997, 2006. All rights reserved. Backup Object Information ------------------------- SQL Server Name ........................ ******\SECOND SQL Database Name ........................ SQLDB1 Backup Object Type ....................... Full Backup Object State ...................... Active Backup Creation Date / Time .............. 10/09/2007 11:10:53 Backup Size .............................. 4,280,832 Database Object Name ..................... 20071009111053\00000D80 Number of stripes in backup object ....... 1 Restoring another backup of database into a new DB and new location: C:\Program Files\Tivoli\TSM\TDPSql.524>mkdir d:\SQLDB1_copy2 C:\Program Files\Tivoli\TSM\TDPSql.524>tdpsqlc restore SQLDB1 /OBJECT=2007100911 1048\00000E48 /relocate=datafile1,datafile2,log1,sysft_PageCatalog /to=d:\SQLDB1 _copy2\datafile1.mdf,d:\SQLDB1_copy2\datafile2.ndf,d:\SQLDB1_copy2\log1. ldf,d:\S QLDB1_copy2\PageCatalog /into=SQLDB1_copy2 IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server Version 5, Release 2, Level 1.06 (C) Copyright IBM Corporation 1997, 2006. All rights reserved. Starting Sql database restore... Querying Tivoli Storage Manager server for a list of database backups, please wa it... Restoring metadata ... Beginning full restore of backup object SQLDB1, 1 of 1, to database SQLDB1_copy2 Full: 0 Read: 4280832 Written: 4280832 Rate: 4,231.28 Kb/Sec Restore of SQLDB1 completed successfully. Total database backups inspected: 1 Total database backups requested for restore: 1 Total database backups restored: 1 Total database skipped: 0 Throughput rate: 4,227.00 Kb/Sec Total bytes transferred: 4,280,832 Elapsed processing time: 0.99 Secs Prior to TSM version 5.5, relocation of full-text catalogs can only be done via command-line interface. Regards, Mark Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
