DanneFr
ADSM.ORG Member
Hi,
I know this has been answered before but with the new 6.3 I'm wondering if there are any new instructions or "best practices" to backup an sql server with more than one instance.
With 5.5 we are using different tdpsql.cfg for each instance and one node (one dsm.opt) for all instances.
tdpsql_instanceA.cfg
SQLSERVER DBSRV\InstanceA
FROMSQLSERVER DBSRV\InstanceA
tdpsql_instanceB.cfg
SQLSERVER DBSRV\InstanceB
FROMSQLSERVER DBSRV\InstanceB
..
and then we have a scheduler that executes sqlfull.cmd
....
%sql_dir%\tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull_instanceA.log >> %sql_dir%\sqlsched.log /configfile=%sql_dir%\tdpsql_InstanceA.cfg
%sql_dir%\tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull_InstanceB.log >> %sql_dir%\sqlsched.log /configfile=%sql_dir%\tdpsql_InstanceB.cfg
....
How are you doing it? Any other suggestions?
Regards,
Dan
I know this has been answered before but with the new 6.3 I'm wondering if there are any new instructions or "best practices" to backup an sql server with more than one instance.
With 5.5 we are using different tdpsql.cfg for each instance and one node (one dsm.opt) for all instances.
tdpsql_instanceA.cfg
SQLSERVER DBSRV\InstanceA
FROMSQLSERVER DBSRV\InstanceA
tdpsql_instanceB.cfg
SQLSERVER DBSRV\InstanceB
FROMSQLSERVER DBSRV\InstanceB
..
and then we have a scheduler that executes sqlfull.cmd
....
%sql_dir%\tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull_instanceA.log >> %sql_dir%\sqlsched.log /configfile=%sql_dir%\tdpsql_InstanceA.cfg
%sql_dir%\tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt /logfile=%sql_dir%\sqlfull_InstanceB.log >> %sql_dir%\sqlsched.log /configfile=%sql_dir%\tdpsql_InstanceB.cfg
....
How are you doing it? Any other suggestions?
Regards,
Dan