InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 00:27:02 GMT20http://www.sqlservercentral.com/Forums/Topic1422551-391-1.aspxI used this application:http://sqlbackupandftp.com/It's free and very good!Fri, 22 Feb 2013 13:45:57 GMTriver1http://www.sqlservercentral.com/Forums/Topic1422551-391-1.aspx[quote][b]river1 (2/22/2013)[/b][hr]What is IIRC?[/quote]If I Recall CorrectlyFri, 22 Feb 2013 08:58:46 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1422551-391-1.aspxIf I Recall Correctly.The kb article that Deque posted, titled "How to schedule and automate backups of SQL Server databases in SQL Server Express", gives detailed steps on how to schedule backups for a SQL Express instance.Fri, 22 Feb 2013 03:40:16 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1422551-391-1.aspxWhat is IIRC?Fri, 22 Feb 2013 03:19:33 GMTriver1http://www.sqlservercentral.com/Forums/Topic1422551-391-1.aspxYou could, but you'd likely need a SQLCMD or other way to make a connection to the other instance (with Express) and run the backup command. T-SQL commands, IIRC, only execute against the local instance.Thu, 21 Feb 2013 17:38:15 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1422551-391-1.aspxCan I use the agent of other SQL Server to backup this database?Example:I have a SQL Server 2005 database engine which has SQL Server Agent service installed.Can I use this SQL instance to backup the database present on Express Edition 2008?Thanks,PedroThu, 21 Feb 2013 17:17:51 GMTriver1http://www.sqlservercentral.com/Forums/Topic1422551-391-1.aspxThe link describes what you do, but you end up creating a scheduled task in Windows that will call the "sqlcmd" executable with a parameter that will execute the stored procedure you created in step A.You don't have to create a stored procedure, though, because I imagine you can just pass the BACKUP DATABASE command directly to sqlcmd.Thu, 21 Feb 2013 10:17:06 GMTDequehttp://www.sqlservercentral.com/Forums/Topic1422551-391-1.aspxThankyou for the link.I just don't undestand how i can make the automatic backup installing SQL Server Express Advanced Service or SQL Server Express Toolkit if SQL express don't has SQL Agent....Can you help me undertand?Thu, 21 Feb 2013 07:26:14 GMTriver1http://www.sqlservercentral.com/Forums/Topic1422551-391-1.aspxDid you see this link? [url=http://support.microsoft.com/kb/2019698]http://support.microsoft.com/kb/2019698[/url]Thu, 21 Feb 2013 07:08:41 GMTDequehttp://www.sqlservercentral.com/Forums/Topic1422551-391-1.aspxHi,I have SQL Server 2008 R2 Express Edition on a server.I need to backup my database (small db) on a daily basis.Since Express Edition does not allow automatic backups what can I use to do this backup?thanksThu, 21 Feb 2013 06:50:41 GMTriver1