? on xp_sqlmaint and the -Rpt option

microsoft.public.sqlserver.tools

15 Feb 2007 7:01 PM

JoeyD

I'd like to know if there is an internal (to xp_sqlmaint) limit on the
length of the input parameter for the -Rpt option?

We have a procedure that we use for our backups that have worked for
several years with out any problems. Recently however, and SharePoint
database servers has been added to our backups. The problem we are
having is with the SharePoint_AdminContent_<guid> database. The
database is backed up correctly. However, the -Rpt parameter to create
a text report file is not working this database. We use a Stored
Procedure that passes in some user defined variables such as the
backup location, and the file path for the report file. I have
checked, double checked, tripled checked that the variables are large
enough to handle the path and report file name. All together the
variable that handles the report file name & path is set to a
varchar(300). Which is about 5 characters more then what is needed.

So to recap, is there a limit to the -Rpt option that is less then 265
characters? (like 255 maybe?)

thanks so much,
Joe

p.s. I have done a bit of searching on the web on at microsoft.com
about this but have not found anything that would tell me.