Comprehensive Backup Script

  • Comments posted to this topic are about the item Comprehensive Backup Script

  • In file cleanup job on sqlserver 2005, I get the following error

    Executed as user: NT AUTHORITY\SYSTEM. Conversion failed when converting datetime from character string. [SQLSTATE 22007] (Error 241).

    Any help appreciated


  • A well crafted masterpiece, however I need a similar for use with linked servers, would be highly obliged to get help.

  • Hope that the naming convention when creating stored procedure must not be sp_ it should usp_ or whatsoever, but not sp_. What is the implications? It might have a performance degradation due to systems stored procedures name will start also sp_. SQL server will try to look first on the systems stored procedure first before users created procedure. But maybe the stored procedure that you created has some reasons why you do it that way. 🙂

  • Thanks for the script.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply