The integration into our databases and the assistance given with bulk uploads and a general helpful attitude was outstanding. – Project Manager, General Retailer, France LEFT OUTER JOIN _hadr_database_replica_states AS dbrs ON dbcs.replica_id = dbrs.replica_id AND oup_database_id = oup_database_id WHERE ISNULL(arstates.role, 3) = 2 AND ISNULL(dbcs.is_database_joined, 0) = 1)" -c -T master.Very pleased particularly with the quality of the product.
#ODBC DRIVER FOR SQL SERVER SDK FULL#
SET ='bcp "SELECT DISTINCT + ""%sql_dir%\tdpsqlc backup "" + rtrim(ltrim(a.name)) + "" full /configfile=%cfg_dir%\' + + '_tdpsql.cfg /tsmoptfile=%cfg_dir%\SQLServer_dsm.opt Have I placed the double quotes in the wrong spot? SET =' "C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\bcp.exe" "SELECT DISTINCT + ""%sql_dir%\tdpsqlc backup "" + rtrim(ltrim(a.name)) + "" full /configfile=%cfg_dir%\'ģ) = 2 AND ISNULL(dbcs.is_database_joined, 0) = 1)" queryout -c -T master.xp_cmdshell is not recognized as an internal or external command,
#ODBC DRIVER FOR SQL SERVER SDK CODE#
So then I tried to place quotes around the executable but I must have place them inappropriatly? Here is the code now. 'C:\Program' is not recognized as an internal or external command, _replicas AS AR ON AG.group_id = AR.group_id INNER JOIN _hadr_availability_replica_states AS arstates ON AR.replica_id = arstates.replica_id AND arstates.is_local = 1 INNER JOIN _hadr_database_replica_cluster_statesĪS dbcs ON arstates.replica_id = dbcs.replica_id LEFT OUTER JOIN _hadr_database_replica_states AS dbrs ON dbcs.replica_id = dbrs.replica_id AND oup_database_id = oup_database_id WHERE ISNULL(arstates.role,ģ) = 2 AND ISNULL(dbcs.is_database_joined, 0) = 1)" queryout -c -T master.xp_cmdshell then I get the message ''OFFLINE'' AND a.name NOT IN (SELECT DISTINCT dbcs.database_name AS FROM _groups AS AG LEFT OUTER JOIN _hadr_availability_group_states as agstates ON AG.group_id = oup_id INNER JOIN + + '_tdpsql.cfg /tsmoptfile=%cfg_dir%\SQLServer_dsm.opt /logfile=%cfg_dir%\BACKUP_FULL_User_Databases.rpt > %rpt_dir%\BACKUP_FULL_User_Databases.rpt"" FROM sys.databases a WHERE a.database_ID > 4 AND state_desc !=
SET =' C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\bcp.exe "SELECT DISTINCT + ""%sql_dir%\tdpsqlc backup "" + rtrim(ltrim(a.name)) + "" full /configfile=%cfg_dir%\' So I attempted to place the full path for the bcp. I get the following error message.Įrror = Unable to open BCP host data-file
Just changing the parameter for the server name and instance name. LEFT OUTER JOIN _hadr_database_replica_states AS dbrs ON dbcs.replica_id = dbrs.replica_id AND oup_database_id = oup_database_id WHERE ISNULL(arstates.role, 3) = 2 AND ISNULL(dbcs.is_database_joined, 0) = 1)" -c -T master.xp_cmdshell I go onto a second server, Server B, and run the same code. JOIN _hadr_availability_replica_states AS arstates ON AR.replica_id = arstates.replica_id AND arstates.is_local = 1 INNER JOIN _hadr_database_replica_cluster_states AS dbcs ON arstates.replica_id = dbcs.replica_id logfile=%cfg_dir%\BACKUP_FULL_User_Databases.rpt > %rpt_dir%\BACKUP_FULL_User_Databases.rpt"" FROM sys.databases a WHERE a.database_ID > 4 AND state_desc != ''OFFLINE'' AND a.name NOT IN (SELECT DISTINCT dbcs.database_name AS įROM _groups AS AG LEFT OUTER JOIN _hadr_availability_group_states as agstates ON AG.group_id = oup_id INNER JOIN _replicas AS AR ON AG.group_id = AR.group_id INNER SET =' bcp "SELECT DISTINCT + ""%sql_dir%\tdpsqlc backup "" + rtrim(ltrim(a.name)) + "" full /configfile=%cfg_dir%\' + + '_tdpsql.cfg /tsmoptfile=%cfg_dir%\SQLServer_dsm.opt On Server A I run the following code and it runs successfully.
0 kommentar(er)
