I am in the process of testing DR for our BES 4.1 on exchange 2003 and SQL 2005 (all on one box).
So far I have managed to do a backup from SQL server management express but just doing a right click on "BESMgmt" and selecting backup.
Once this was done, I then uninstalled SQL, deleted all databases and when through the restore process:
1. Reinstall SQL
2. use createdb to erm .. create an empty db
3. Open a command prompt and type osql -E
Type the following commands in the specified order: 1> restore database BESMgmt from disk = "c:\backup.bak" with recovery,replace
And it all works!
cut a long story short (too late!)
How can i automate the initial backup of the database, so i dont have right click - select backup.
Can i do it from the command line using Osql ?
Will the command line create a new file for every backup everyday or will it just append to a big file. Ideally i would like a history of 7days (7 files), which will then cycle.
I thank you in advance