July 18, 2008 at 3:07 am
When I attempt to create the a backup job on the SQL 2005 DB Server for a remote SQL 2000 Database, it generates the following error. The dbo.xp_create_subdir is an stored procedure in SQL 2005 but when the job is executed, it ran against the SQL 2000 database and it fails to locate the stored procedure.
Executing the query "EXECUTE master.dbo.xp_create_subdir N'\\\\SQLbackups.com\\sqlserver\\Argosrv\\DAP\\test\\Argosys'
" failed with the following error: "Could not find stored procedure 'master.dbo.xp_create_subdir'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Many thanks.
July 18, 2008 at 6:50 am
Just a guess here, but I suspect that the xp that SQL 2005 is calling is nowhere to be found in a SQL 2000 installation.
Try running a TSQL backup job writing the file to an existing directory and see if you have better results.
Regards, Irish
September 11, 2008 at 3:38 pm
Agreed. Xp_Create_Subdir did not exist in SQL 2000.
May 20, 2009 at 4:23 am
Xp_Create_Subdir did not exist in SQL 2005
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply