Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Express

Automatic Backup SQL Server Express

Is there any way to have an automatic backup of a database in SQL Server Express?
[82 byte] By [KevinGW] at [2008-3-1]
«« How to build OLE DB tests in MDAC 2.8? (can't find "msxmloledb.h")
»» Determine if error provider control has errors
# 1


Its not fully automated, but you can use a OS scheduled job, running a Backup statement like those shown in the BOL. In SQL Server Express you would probably use the SQLCMD.EXE to issue any commands against the database. Look for more explanation about the calling syntax in the BOL as well.

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

JensSuessmeyer at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Express...
# 2

So I would be using the OS scheduler to run something like a script file to do the backup?

One of the Admin tools with Express looks like it creates scripts. For backup would I need write the script myself?

KevinGW at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Express...
# 3
That shouldn′t be a problem. There are many samples inthe BOL about that and the syntax is suprisingly well described :)

If you have any questions, just raise a hand.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

JensSuessmeyer at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Express...
# 4

When you say BOL do you mean SQL Server Express Books Online. I have looked through this and I don't see anything directly applicable. I did see the sqlcmd utility. I expected that there would be commandes for disconnecting the database and copying it to a location on disk, but I did not see any.

Are there other BOL that I should be looking at? In the BOL which I have there were only 2 examples for sqlcmd.

Any help is appreciated

KW

KevinGW at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Express...
SQL Server
SQL Server Express

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified