InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 01:58:07 GMT20http://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspxTry SQL Backup Master. It can do the job, and is free:[url=http://www.sqlbackupmaster.com]http://www.sqlbackupmaster.com[/url]Thu, 17 Jan 2013 08:13:26 GMTTodd Bellerhttp://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspxThanks for the feedback, adding to briefcase.Wed, 03 Aug 2011 09:17:44 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspxSorted and for all of you that are interested....Set up a simple windows scheduled task that executes a batch file. Within the batch file I have the following[b]rem @echo offsqlcmd -S localhost -d dbname -i backup.sql -U myusername -P mypassword[/b]This then calls 'backup.sql'which contains the following syntaxUSE [dbname]GODECLARE @return_value intEXEC @return_value = [dbo].[prc_db-backup] @db_name = N'dbname', @db_datafile = N'datafilename', @db_backup_path = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup'SELECT 'Return Value' = @return_valueGOWhich executes a stored procedure 'prc_db-backup' which contains my T-sql to create my backupsSimple.Wed, 03 Aug 2011 09:13:56 GMTAHWBhttp://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspx[quote][b]Ninja's_RGR'us (8/3/2011)[/b][hr][quote][b]GilaMonster (8/3/2011)[/b][hr]You don't need any software at all. Use the windows scheduler.[/quote]Go sample backup code for that option? Never tried to make it work that way :ermm:.[/quote]I don't, but I know that a google search will turn some up.Wed, 03 Aug 2011 08:08:42 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspx[quote][b]AHWB (8/3/2011)[/b][hr]so can anyone help with the syntax required as im not familiar with sqlcmd[/quote]SQLCMD /? prints out the command-line options (like with most similar programs) or [url]http://msdn.microsoft.com/en-us/library/ms162773.aspx[/url]Wed, 03 Aug 2011 08:06:57 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspx[quote][b]AHWB (8/3/2011)[/b][hr]Thanks for the link http://standalonesqlagent.codeplex.com/ but need something that's not in Beta.[/quote]ok, nothing else to offer beying what Gail already provided.Wed, 03 Aug 2011 08:04:06 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspxThanks for the link http://standalonesqlagent.codeplex.com/ but need something that's not in Beta.Wed, 03 Aug 2011 07:53:51 GMTAHWBhttp://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspxI understand that you can set up a backup task using windows scheduler, but how, I need help with the syntax.Looking at windows scheduler, Windows 7click create task (all the other options within windows scheduler are self explanatory)on the 'actions' tab click 'new'there is a 'program/script' files (with a browse button next to it)I entered the following - path to sqlcmd[b]"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE"[/b]and then within the add argument (optional) field the following[b]backup database database_name to disk = 'c:\database_name.bak'[/b]this did not work, i expect i need to add a login or something....so can anyone help with the syntax required as im not familiar with sqlcmdWed, 03 Aug 2011 07:49:15 GMTAHWBhttp://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspx[quote][b]GilaMonster (8/3/2011)[/b][hr]You don't need any software at all. Use the windows scheduler.[/quote]Go sample backup code for that option? Never tried to make it work that way :ermm:.Wed, 03 Aug 2011 07:32:57 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspxYou don't need any software at all. Use the windows scheduler.Wed, 03 Aug 2011 07:27:51 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspx[url]http://standalonesqlagent.codeplex.com/[/url]Wed, 03 Aug 2011 07:21:36 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1153499-1550-1.aspxThis is my first look at SQL Express 2008r2 and I have realised that SQL agent isn't part of the express edition. Normally on 2005/2008 std/ent I use SQL agent to schedule database backups and backup the transaction log etc.My first question is;1) How do you set up a scheduled task to back up a database, initial search suggests you have to use windows task scheduler but how is this done, or is there a better way?2) Following on from question 1, is there good, preferably free, software which can do what MS SQL agent does. I know MSDE Vale have their own SQL agent, is this any good or are there other options.3) linked with questions 1 and 2, I assume SQLexpress still requires the transaction log to be backed up, should this be set up using as per question 1 & 2 above, I'm thinking of setting the recovery method to simple as the system that this is used on doesn't really require Full.I have searched the web but couldn't find much on these specific questions.Wed, 03 Aug 2011 07:17:09 GMTAHWB