Post reply

SQL Server Express - automatic Backup

  • February 21, 2013 at 6:50 am

    #268901

    Hi,

    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?

    thanks

  • February 21, 2013 at 7:08 am

    #1589944

    Did you see this link? http://support.microsoft.com/kb/2019698

  • February 21, 2013 at 7:26 am

    #1589954

    Thankyou 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?

  • February 21, 2013 at 10:17 am

    #1590060

    The 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.

  • February 21, 2013 at 5:17 pm

    #1590165

    Can 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,

    Pedro

  • February 21, 2013 at 5:38 pm

    #1590170

    You 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.

  • February 22, 2013 at 3:19 am

    #1590261

    What is IIRC?

  • February 22, 2013 at 3:40 am

    #1590272

    If 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.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 22, 2013 at 8:58 am

    #1590405

    river1 (2/22/2013)

    What is IIRC?

    If I Recall Correctly

  • February 22, 2013 at 1:45 pm

    #1590517

    I used this application:

    http://sqlbackupandftp.com/

    It's free and very good!

  • July 13, 2015 at 3:55 pm

    #1812162

    You also can use http://www.sqlserverbooster.com

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply