Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

BES 5 and SQL Server Express - Database restore for resilience and recovery

Posted on 2011-09-05
2
Medium Priority
?
544 Views
Last Modified: 2012-05-12
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
Comment
Question by:dl_ee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
NormanMaina earned 1000 total points
ID: 36483617

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

Open in new window

0
 

Author Closing Comment

by:dl_ee
ID: 36538164
simple really
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question