InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:02:56 GMT20http://www.sqlservercentral.com/Forums/Topic834826-1716-1.aspxWhen I tested the scripts on SQL Server 2008 SP1, it runs into problems:Msg 102, Level 15, State 1, Line 7Incorrect syntax near ' '.Msg 137, Level 15, State 2, Line 39Must declare the scalar variable "@BackupServerNameInput".Msg 137, Level 15, State 2, Line 40Must declare the scalar variable "@BackupShareInput".Msg 137, Level 15, State 2, Line 41Must declare the scalar variable "@DoAFullBackupInput".Msg 102, Level 15, State 1, Line 49Incorrect syntax near ' '.Msg 156, Level 15, State 1, Line 50Incorrect syntax near the keyword 'ELSE'.Msg 102, Level 15, State 1, Line 89Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 115Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 129Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 142Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 192Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 219Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 235Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 248Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 302Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 327Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 329Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 345Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 358Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 47Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 59Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 129Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 144Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 163Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 178Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 197Incorrect syntax near ' '.Msg 102, Level 15, State 1, Line 210Incorrect syntax near ' '.Please help.Thanks,EdwinThu, 20 May 2010 10:49:47 GMTEd7http://www.sqlservercentral.com/Forums/Topic834826-1716-1.aspxMine actually created jobs in English version. You have to be careful with that hostname and sharefolder. I can it is useful if you start out many db servers you have to set up at once. It is nice the author spent so much time to code and test this script. If it is one host at a time, it is a slight advantage over maintenance plan.Fri, 08 Jan 2010 14:20:45 GMTjswong05http://www.sqlservercentral.com/Forums/Topic834826-1716-1.aspxHi,Remove all ' ' from the script and run it again.RegardsMon, 04 Jan 2010 08:19:09 GMTrene-500237http://www.sqlservercentral.com/Forums/Topic834826-1716-1.aspxThanks for youre article.I want to use your script to create the jobs in SQL Server 2005 (german version).By checking the script i got a lot of syntax errors.[code="plain"]Meldung 102, Ebene 15, Status 1, Zeile 7Falsche Syntax in der Nähe von ' '.Meldung 137, Ebene 15, Status 2, Zeile 36Die "@BackupServerNameInput"-Skalarvariable muss deklariert werden.Meldung 137, Ebene 15, Status 2, Zeile 37Die "@BackupShareInput"-Skalarvariable muss deklariert werden.Meldung 137, Ebene 15, Status 2, Zeile 38Die "@DoAFullBackupInput"-Skalarvariable muss deklariert werden.Meldung 102, Ebene 15, Status 1, Zeile 46Falsche Syntax in der Nähe von ' '.[/code]Wed, 30 Dec 2009 23:52:34 GMTdavid.classenhttp://www.sqlservercentral.com/Forums/Topic834826-1716-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Backup+%2f+Restore/69022/">Automated SQL Job to Backup Database(s)</A>[/B]Tue, 15 Dec 2009 20:59:01 GMTVenkatesh Krishnamurthy