BES 5 and SQL Server Express - Database restore for resilience and recovery
I expect this is an easy question. But I don't use SQL Express so...its not an easy one for me!.
Previously I sought information on how to backup a database using SQL Server Express 2005.
We have a batch script already where we run as a Windows Schedule Task and we decide to copy the backups created to an alternate server location.
One answer I was given is:
You could create a batch file to run as a scheduled task and the following SQLCMD command line: