Solved

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

Posted on 2011-09-05
2
540 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 250 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

724 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