SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Automated SQL Job to Backup Database(s)


Automated SQL Job to Backup Database(s)

Author
Message
Venkatesh Krishnamurthy
Venkatesh Krishnamurthy
SSC-Enthusiastic
SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)

Group: General Forum Members
Points: 158 Visits: 331
Comments posted to this topic are about the item Automated SQL Job to Backup Database(s)
david.classen
david.classen
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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 ' '.

rene-500237
rene-500237
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2791 Visits: 1186
Hi,

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

Regards
jswong05
jswong05
Say Hey Kid
Say Hey Kid (701 reputation)Say Hey Kid (701 reputation)Say Hey Kid (701 reputation)Say Hey Kid (701 reputation)Say Hey Kid (701 reputation)Say Hey Kid (701 reputation)Say Hey Kid (701 reputation)Say Hey Kid (701 reputation)

Group: General Forum Members
Points: 701 Visits: 476
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
:-P
Ed7
Ed7
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1733 Visits: 930
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
Jeffery Williams
Jeffery Williams
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1241 Visits: 913
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
Iwas Bornready
Iwas Bornready
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22474 Visits: 885
Thanks for the script.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search