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:

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..

Thanks.
dl_ee

dl_eeAsked:
Who is Participating?
 
Norman MainaCommented:

SqlCmd -E -S servername\sqlexpress –Q "RESTORE DATABASE [BESMgmt] FROM DISK='D:\BESMgmtDB.bak8
'

Open in new window

0
 
dl_eeAuthor Commented:
simple really
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.