Automated SQL Job to Backup Database(s)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Venkatesh... » Automated SQL Job to Backup Database(s)

Automated SQL Job to Backup Database(s)

Rate Topic

Display Mode

Topic Options

Author

Message

Venkatesh Krishnamurthy

Posted Tuesday, December 15, 2009 8:59 PM

SSC-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

david.classen

Posted Wednesday, December 30, 2009 11:52 PM

Forum 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

rene-500237

Posted Monday, January 04, 2010 8:19 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:26 AM
Points: 2,293, Visits: 1,099

Hi,

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

Regards

Post #841508

jswong05

Posted Friday, January 08, 2010 2:20 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 18, 2013 7:54 AM
Points: 27, Visits: 421

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
Tongue

Post #844680

Ed7

Posted Thursday, May 20, 2010 10:49 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 9:02 AM
Points: 346, Visits: 885

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 »

Permissions