Comprehensive Backup Script

• Simon Facer

  SSCertifiable

  Points: 5427

  More actions

  January 30, 2008 at 12:47 am

  #186078

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

• Howard Perry

  Right there with Babe

  Points: 761

  More actions

  September 9, 2009 at 8:27 am

  #1051156

  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

  Howard

• vikash.mca

  Grasshopper

  Points: 16

  More actions

  November 21, 2009 at 1:35 pm

  #1082682

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

• mcvilbar

  Say Hey Kid

  Points: 711

  More actions

  December 21, 2011 at 10:15 pm

  #1424565

  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.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 11, 2016 at 11:44 am

  #1878343

  Thanks for the script.