Solved

SQL 2005 restore Blackberry BES data files on SBS 2003 R2

Posted on 2011-03-14
4
230 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

Independent Software Vendors: 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

If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
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.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

749 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