473,651 Members | 3,068 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to recover SQL database from a removed laptop hard drive?

Dear group:

I have removed my hard drive from my laptop (which is now toast) and
have managed to recover nearly all the data from it by installing the
drive into my desktop. I was hoping to reboot the dektop to see if I
could load the operating system on the laptop's hard drive so I could
do a manual backup of the SQL database on it. This does not work.

Does anyone know of a way to recover my SQL database and all its tables
given the circumstances above?

TIA
ISZ

Jul 23 '05 #1
5 4945
Nevermind... I found the answer. I was able to successfully use the
follwing transact...

EXEC sp_attach_db @dbname = N'****',
@filename1 = N'g:\Program Files\Microsoft SQL
Server\MSSQL$** **\Data\****_DB _Data.MDF',
@filename2 = N'g:\Program Files\Microsoft SQL
Server\MSSQL$** **\Data\****_DB _Log.LDF'

Jul 23 '05 #2
Nevermind... I found the answer. I was able to successfully use the
follwing transact...

EXEC sp_attach_db @dbname = N'****',
@filename1 = N'g:\Program Files\Microsoft SQL
Server\MSSQL$** **\Data\****_DB _Data.MDF',
@filename2 = N'g:\Program Files\Microsoft SQL
Server\MSSQL$** **\Data\****_DB _Log.LDF'

Jul 23 '05 #3
Nevermind... I found the answer. I was able to successfully use the
follwing transact...

EXEC sp_attach_db @dbname = N'****',
@filename1 = N'g:\Program Files\Microsoft SQL
Server\MSSQL$** **\Data\****_DB _Data.MDF',
@filename2 = N'g:\Program Files\Microsoft SQL
Server\MSSQL$** **\Data\****_DB _Log.LDF'

Jul 23 '05 #4
Restore from a backup. You do have backups of your laptop of course...?
:-)
--
David Portas
SQL Server MVP
--

Jul 23 '05 #5

<q2****@hotmail .com> wrote in message
news:11******** **************@ l41g2000cwc.goo glegroups.com.. .
Dear group:

I have removed my hard drive from my laptop (which is now toast) and
have managed to recover nearly all the data from it by installing the
drive into my desktop. I was hoping to reboot the dektop to see if I
could load the operating system on the laptop's hard drive so I could
do a manual backup of the SQL database on it. This does not work.

Does anyone know of a way to recover my SQL database and all its tables
given the circumstances above?

TIA
ISZ


If you can recover the .mdf and .ldf files from the laptop hard drive, you
could try attaching the database with sp_attach_db (or
sp_attach_singl e_file_db if you only have the .mdf file). But this may not
work at all, and your best option is, as David said, to restore from a
backup of the database.

Simon
Jul 23 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2943
by: Nate | last post by:
Hello, I am trying to recover a SQL Server 7 database from another hard disk drive that has a corrupted Windows 2000 Advanced Server installation. I am not able to repair the corrupted Windows 2000 Advanced Server installation but the file system is intact. I have installed a new copy of SQL Server 7 onto a new hard disk and have used the sp_attach_db system stored procedure to attach the database from the old hard drive into the new...
5
3686
by: premmehrotra | last post by:
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops. Following problems occur: 1. Access is way too slow in WAN environment. Server is located in New Jersey and users are in California and Puerto Rico. 2. Database often becomes corrupt 3. When one user updates some data in the database, other users...
4
2008
by: robert d via AccessMonster.com | last post by:
When my app starts up, it creates a temporary database. This temp database is created from a 'model' database that is in the same folder as the application. Because there is a model, the creation is essentially to just copy the 'model' database and give it the name of the application with the extension ".tmp". Then code opens the temp database and links to the tables. This has always worked flawlessly until today. Today, I needed to...
1
2185
by: deiopajw | last post by:
I have a Back end database on a network drive. The copies of the front end are located on individual pc's (in their C drive). The problem arises when a laptop user naturally hooks up to the network but then the link from the front end (in the C drive of the laptop) to the back end (network drive) is lost. I have to then go to the tables section of the database window of the Front End and remove the links then link them again with the Back...
0
1188
by: xz | last post by:
i've got mysql 5.0 and I have 50 million records in a text file on an external USB 2.0 hard drive. I can import the file into a mySQL database on my laptop - but I don't want the database on my laptop. I want that database to be physically located on that usb connected hard drive instead of my laptop. Can anyone tell me how to set up the database on my laptop, but with a physical location of the data on the external hard drive? Oh -...
3
3226
by: nethajireddy | last post by:
what are the reasons if a laptop is not detecting hard drive i tried replacing another hard drive it's working.. can any one plz... thanks in advance..techi's
4
1717
tpgames
by: tpgames | last post by:
The Error Message: If you have NTFS installed on your hard drive, you need to create a MS DOS boot partition for windows. Also, the icon that says HD does not even come up. The diagnostic test have said: Hard Drive NONE found. All NTFS MS DOS programs we've tried, have not worked. So, as a work around, we were wondering if the following would work: Can one hook up an external hard drive to it, toss on XP (onto external HD), and use the...
15
1731
by: Andrew Meador | last post by:
I am working on an application that will store data in SQL Server 2005 Express. The database will reside on our server at the office. I need to write an application that can work with this data off site during the day and then synch the changes back to the database at the end of the day (or next morning). I have been reading up on ADO.NET and see that you can use a DataSet and a DataAdaptor to manage change tracking and updating of the...
3
1638
by: mazdotnet | last post by:
Hi guys, I'm thinking of buying a laptop time this time and I was wondering if anyone has any experience with running VisualStudio 2008 and MSSQL 2005 on a laptop? Please include your processor, and memory as well. I'm looking at this one which has 2 Gigs RAM. http://www.futureshop.ca/catalog/proddetail.asp?sku_id=0665000FS10100176&catid=25315&logon=&langid=EN
0
8279
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8703
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8589
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6160
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4145
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4291
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2703
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1914
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1591
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.