BES 5 and SQL Server Express - Database restore for resilience and recovery
Posted on 2011-09-05
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:
SqlCmd -E -S servername\sqlexpress –Q "BACKUP DATABASE [BESMgmt] TO DISK='D:\BESMgmtDB.bak' "
So we incorporated the above in a modified batch script.
I need a reverse approach now that allows us to rebuild a database server component following server breakdown using re-install the SQL Express and restore the backed up database.
I trust this is easy to do so would like kinda the opposite of above or some other reference material..