GregE
ADSM.ORG Senior Member
I am trying to restore an SQL DB to a completely different server (different physically server and different SQL server instance).
My command launches the GUI just fine, and shows me the databases:
When attempting restore, I get this error:
02/04/2010 16:12:42 Restore of DB1 failed.
02/04/2010 16:12:42 An exception occurred while executing a Transact-SQL statement or batch.
02/04/2010 16:12:42 Cannot create the full-text catalog in the directory "R:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ftCatalog_DB1" for the clustered server. Only directories on a disk in the cluster group of the server can be used.
02/04/2010 16:12:42 File 'sysft_ftCatalog_DB1' cannot be restored to 'R:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ftCatalog_DB1'. Use WITH MOVE to identify a valid location for the file.
02/04/2010 16:12:42 Problems were identified while planning for the RESTORE statement. Previous messages provide details.
02/04/2010 16:12:42 RESTORE DATABASE is terminating abnormally.
02/04/2010 16:12:42 Changed database context to 'master'. (HRESULT:0x80131501)
That directory path on "R:" is where the files came FROM. I specifed in the GUI to put them into "F:\MSSQL\Data\DB1\" on this new server. It's ignoring that.
I've had the SQL DBA ensure that I have sysadmin rights to SQL server to make sure my problem isn't due to permissions.
I've also found this technote, but did not change anything.
http://www-01.ibm.com/support/docview.wss?rs=667&uid=swg21395947
Anyone have this issue figured out a way around it?
My command launches the GUI just fine, and shows me the databases:
Code:
tdpsql.exe /tsmoptfile=F:\TSM\TDPSql\dsm_SERVER_A.opt /sqlserver=SERVER_B\INSTANCE1 /configfile=tdpsql.cfg
When attempting restore, I get this error:
02/04/2010 16:12:42 Restore of DB1 failed.
02/04/2010 16:12:42 An exception occurred while executing a Transact-SQL statement or batch.
02/04/2010 16:12:42 Cannot create the full-text catalog in the directory "R:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ftCatalog_DB1" for the clustered server. Only directories on a disk in the cluster group of the server can be used.
02/04/2010 16:12:42 File 'sysft_ftCatalog_DB1' cannot be restored to 'R:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ftCatalog_DB1'. Use WITH MOVE to identify a valid location for the file.
02/04/2010 16:12:42 Problems were identified while planning for the RESTORE statement. Previous messages provide details.
02/04/2010 16:12:42 RESTORE DATABASE is terminating abnormally.
02/04/2010 16:12:42 Changed database context to 'master'. (HRESULT:0x80131501)
That directory path on "R:" is where the files came FROM. I specifed in the GUI to put them into "F:\MSSQL\Data\DB1\" on this new server. It's ignoring that.
I've had the SQL DBA ensure that I have sysadmin rights to SQL server to make sure my problem isn't due to permissions.
I've also found this technote, but did not change anything.
http://www-01.ibm.com/support/docview.wss?rs=667&uid=swg21395947
Anyone have this issue figured out a way around it?
Last edited: