prairdon
Newcomer
Hello all,
I am having trouble getting TDP to work on a cluster. This is my first cluster install. If I call up the GUI I can run a successful backup. If I try to kick off the back up from the CMD file it fails with the following error:
Backup of master failed.
ACO5422E Received the following from the MS SQL server:
An exception occurred while executing a Transact-SQL statement or batch.
Cannot open backup device 'TDPSQL-00001688-0000'. Operating system error 0x80070002(The system cannot find the file specified.).
BACKUP DATABASE is terminating abnormally.
This is a two server active/passive cluster. I have TDP set up identically on both servers with the clusternode set to yes in the dsm.opt. My CMD files are located in a directory just off of c: and this is the line that is used to call the backup:
%sql_dir%\tdpsqlc backup master full /sqlserver=sqlserver01 /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\masterFull.log >> %sql_dir%\sqlsched.log
I have a feeling this has something to do with the clustering but I can't figure out what. Any help would be appreciated. Thank you.
I am having trouble getting TDP to work on a cluster. This is my first cluster install. If I call up the GUI I can run a successful backup. If I try to kick off the back up from the CMD file it fails with the following error:
Backup of master failed.
ACO5422E Received the following from the MS SQL server:
An exception occurred while executing a Transact-SQL statement or batch.
Cannot open backup device 'TDPSQL-00001688-0000'. Operating system error 0x80070002(The system cannot find the file specified.).
BACKUP DATABASE is terminating abnormally.
This is a two server active/passive cluster. I have TDP set up identically on both servers with the clusternode set to yes in the dsm.opt. My CMD files are located in a directory just off of c: and this is the line that is used to call the backup:
%sql_dir%\tdpsqlc backup master full /sqlserver=sqlserver01 /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\masterFull.log >> %sql_dir%\sqlsched.log
I have a feeling this has something to do with the clustering but I can't figure out what. Any help would be appreciated. Thank you.