Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Server Express - automatic Backup Expand / Collapse
Author
Message
Posted Thursday, February 21, 2013 6:50 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, October 23, 2014 2:26 PM
Points: 752, Visits: 1,071
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
Posted Thursday, February 21, 2013 7:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 27, 2014 6:27 PM
Points: 37, Visits: 1,659
Did you see this link? http://support.microsoft.com/kb/2019698
Post #1422567
Posted Thursday, February 21, 2013 7:26 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, October 23, 2014 2:26 PM
Points: 752, Visits: 1,071
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
Posted Thursday, February 21, 2013 10:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 27, 2014 6:27 PM
Points: 37, Visits: 1,659
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
Posted Thursday, February 21, 2013 5:17 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, October 23, 2014 2:26 PM
Points: 752, Visits: 1,071
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
Posted Thursday, February 21, 2013 5:38 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:15 PM
Points: 31,210, Visits: 15,654
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
Posted Friday, February 22, 2013 3:19 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, October 23, 2014 2:26 PM
Points: 752, Visits: 1,071
What is IIRC?
Post #1422951
Posted Friday, February 22, 2013 3:40 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 6:05 AM
Points: 40,258, Visits: 36,681
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
Posted Friday, February 22, 2013 8:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:15 PM
Points: 31,210, Visits: 15,654
river1 (2/22/2013)
What is IIRC?


If I Recall Correctly







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1423112
Posted Friday, February 22, 2013 1:45 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, October 23, 2014 2:26 PM
Points: 752, Visits: 1,071
I used this application:

http://sqlbackupandftp.com/

It's free and very good!

Post #1423247
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse