Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 548
  • Last Modified:

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

0
dl_ee
Asked:
dl_ee
1 Solution
 
NormanMainaCommented:

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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now