Solved

SQL 2005 restore Blackberry BES data files on SBS 2003 R2

Posted on 2011-03-14
4
232 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
[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
  • 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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
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 we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

615 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