Solved

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

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

When a user’s mailbox is first created and his Blackberry account enabled how do we provision the device and what happens in the background? Stage 1 – Activation The user of the BlackBerry device types the email address and activation password i…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

778 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