SQL Server Express - automatic Backup

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server Express - automatic Backup

SQL Server Express - automatic Backup

Rate Topic

Display Mode

Topic Options

Author

Message

river1

Posted Thursday, February 21, 2013 6:50 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

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

Post #1422551

Deque

Posted Thursday, February 21, 2013 7:08 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 2:44 PM
Points: 31, Visits: 1,116

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

Post #1422567

river1

Posted Thursday, February 21, 2013 7:26 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

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?

Post #1422578

Deque

Posted Thursday, February 21, 2013 10:17 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 2:44 PM
Points: 31, Visits: 1,116

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.

Post #1422699

river1

Posted Thursday, February 21, 2013 5:17 PM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

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

Post #1422827

Steve Jones - SSC Editor

Posted Thursday, February 21, 2013 5:38 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:26 PM
Points: 31,425, Visits: 13,738

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1422833

river1

Posted Friday, February 22, 2013 3:19 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

What is IIRC?

Post #1422951

GilaMonster

Posted Friday, February 22, 2013 3:40 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:38 AM
Points: 37,725, Visits: 29,981

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 2008, MVP
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

Post #1422964