Solved

SQL 2005 restore Blackberry BES data files on SBS 2003 R2

Posted on 2011-03-14
4
224 Views
Last Modified: 2012-05-11
I had a Blue Screen event.

SQL would not start. I had to uninstall and reinstall SQL 2005 plus all the service packs.

I have a full system back up of all the SQL files.

I need to reattach some data bases, in particular the ones relating to Blackberry Enterprise Server (BES). How do I do that, please?
0
Comment
Question by:MarcusN
  • 3
4 Comments
 
LVL 7

Accepted Solution

by:
mkobrin earned 500 total points
ID: 35127470
In your SQL enterprise manager, after connecting to your instance of SQL, right click on data bases, select the All Tasks option, then select the attach database option. Browse to and select your mdf file, click on OK. Your DB will be attached.
0
 

Author Comment

by:MarcusN
ID: 35127476
Will it also automatically attach or interfqace with the appropriate ldf files?
0
 
LVL 7

Assisted Solution

by:mkobrin
mkobrin earned 500 total points
ID: 35127481
To restore a db, create a new one with the same filenames as the one that you previoulsy backed up and then right click on the new DB, select All Tasks, then backup/restore select the option to restore a DB from a device, select your backup file, and thens set the options to overwrite the original files, and then restore the DB.
0
 
LVL 7

Expert Comment

by:mkobrin
ID: 35127497
Yes your LDF files will automatically be included with the attach process
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Last night I received a weird phone call, from a number I didn’t recognized.  I answered it and no one responded back so I hung up.   Didn’t look at my phone until my husband said “Your phone is doing something weird”.   I had what I’ll consider the…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

705 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now