Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Automated SQL Job to Backup Database(s) Expand / Collapse
Author
Message
Posted Tuesday, December 15, 2009 8:59 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, March 13, 2011 9:27 PM
Points: 158, Visits: 331
Comments posted to this topic are about the item Automated SQL Job to Backup Database(s)
Post #834826
Posted Wednesday, December 30, 2009 11:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 15, 2010 3:22 AM
Points: 1, Visits: 7
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 ' '.
Post #840688
Posted Monday, January 04, 2010 8:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 29, 2014 4:33 AM
Points: 2,488, Visits: 1,134
Hi,

Remove all ' ' from the script and run it again.

Regards
Post #841508
Posted Friday, January 08, 2010 2:20 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 8:35 AM
Points: 27, Visits: 454
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
Post #844680
Posted Thursday, May 20, 2010 10:49 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:22 PM
Points: 353, Visits: 913
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
Post #925370
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse