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
Solved

SQL 2005 restore Blackberry BES data files on SBS 2003 R2

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Strange msg in the SSMS pane 13 58
Query to return total 6 21
DNS issues after a power outage 3 43
SQLsvr.exe SBS 2011memory issues 3 25
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
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.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

808 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