December 15, 2009 at 8:59 pm
Comments posted to this topic are about the item Automated SQL Job to Backup Database(s)
December 30, 2009 at 11:52 pm
Thanks 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.
Meldung 102, Ebene 15, Status 1, Zeile 7
Falsche Syntax in der Nähe von '?'.
Meldung 137, Ebene 15, Status 2, Zeile 36
Die "@BackupServerNameInput"-Skalarvariable muss deklariert werden.
Meldung 137, Ebene 15, Status 2, Zeile 37
Die "@BackupShareInput"-Skalarvariable muss deklariert werden.
Meldung 137, Ebene 15, Status 2, Zeile 38
Die "@DoAFullBackupInput"-Skalarvariable muss deklariert werden.
Meldung 102, Ebene 15, Status 1, Zeile 46
Falsche Syntax in der Nähe von '?'.
January 4, 2010 at 8:19 am
Hi,
Remove all '?' from the script and run it again.
Regards
January 8, 2010 at 2:20 pm
Mine 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.
Jason
http://dbace.us
😛
May 20, 2010 at 10:49 am
When I tested the scripts on SQL Server 2008 SP1, it runs into problems:
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '?'.
Msg 137, Level 15, State 2, Line 39
Must declare the scalar variable "@BackupServerNameInput".
Msg 137, Level 15, State 2, Line 40
Must declare the scalar variable "@BackupShareInput".
Msg 137, Level 15, State 2, Line 41
Must declare the scalar variable "@DoAFullBackupInput".
Msg 102, Level 15, State 1, Line 49
Incorrect syntax near '?'.
Msg 156, Level 15, State 1, Line 50
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Line 89
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 115
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 129
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 142
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 192
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 219
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 235
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 248
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 302
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 327
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 329
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 345
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 358
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 47
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 59
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 129
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 144
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 163
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 178
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 197
Incorrect syntax near '?'.
Msg 102, Level 15, State 1, Line 210
Incorrect syntax near '?'.
Please help.
Thanks,
Edwin
April 1, 2015 at 8:03 am
I can not get to article it says to many redirect loops??
<hr noshade size=1 width=250 color=#BBC8E5> Regards,Jeffery Williams http://www.linkedin.com/in/jwilliamsoh
May 23, 2016 at 7:16 am
Thanks for the script.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply