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
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?
|||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
|||
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
No comments:
Post a Comment