Solved

SQL 2005 restore Blackberry BES data files on SBS 2003 R2

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

831 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