473,890 Members | 1,218 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server drive died, data drive is OK... now what?

5 New Member
We've just had a server go down. The operating system seems to be corrupted, so we'll likely need to reinstall everything on that drive.

The operating system and programs, including SQL Server, are on the C: drive.

The databases are all on the D: drive. D: seems OK. I've never run into this case. What happens now?

If we have to rebuild the C: drive and reinstall SQL Server, what state will the databases be left in? Will they think they're still "attached" to something, or will I be able to simply boot up SSMS and attach each of them to the new instance without issue?

If anyone with experience could let me know what to expect in this scenario, I would greatly appreciate it. The databases seem fine. How do I go about getting them back up and running if we have to reinstall everything?
Oct 13 '11 #1
1 1779
NeoPa
32,584 Recognized Expert Moderator MVP
If the database is fine it can be reattached later when the SQL Server is rebuilt.
Oct 13 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3744
by: Marsha | last post by:
Does anyone know how to add a new data provider to Visual Studio - to the Provider list in Server Explorer. I am using Sybase's ADO.NET Data Provider. It has been added to my GAC and appears in my References. However, I would like to add the provider to the Provider list in Server Explorer. Thanks. ~Marsha
2
3417
by: m00nm0nkey | last post by:
Hello. My organisation has been developing in VB.NET for a couple of months. We've been sucessfully implementing our software on a server with the dot net framework installed for a couple of weeks. Although we are still able to install and run VB.Net Windows Services, we are now unable to run ASP.Net web applications. This problem all started, without warning, a few days ago.
2
6979
by: Todd Beauchemin | last post by:
We installed MS SQL Server to our drive D drive E was the CDROM Drive. We wanted to move the CDROM drive to drive D and the hard drive to drive E. We change that around and corrected the registry entries - repointing everything to drive E instead of D. SQL Server however will not start it says it cannot find the databases. Where is this information stored. How can I go about changing it? ~Todd
1
1295
by: wangzhi0417 | last post by:
I want to write a application monitering program to collect the SQL Server 2000 performance data, such as pages/sec, bytes total/sec, etc, BUT I don't know how to do it , In Oracle , there are the v$ views and DBA view , which I can find the information I interested, the question is , is there a similar suit of view in SQL Server 2000 to provide the performance information ? Thank you very much, I will be mad by this question, for I have...
4
2055
by: turtle | last post by:
This may be so elementary that no one has ever had to ask it. How do I copy an Excel workbook that is on drive E to drive F using Visual Basic 6.0? I have tried several different ways without success. I don't get error messages, it just doesn't happen. Thanks very much, Turtle
1
2551
by: Bill Nguyen | last post by:
One of my apps (running in a terminal server session) needs to access a local USB drive /fash card. Is there a way to access local drives programmatically? Thanks Bill
0
4546
by: vinodpatel | last post by:
HI I am loading some files using bulk insert from store procedure. Iand I am also using sp_OA... to move files to other folder Some time while Executing this store procedure I am getting ERROR "Restricted data type attribute violation" and Query Analyzer is hanging up
3
1902
by: scoots987 | last post by:
I have a Windows 2003 server with SQL Server 2005 installed. The server is on small drive and we would like to upgrade to much larger harddrives. I've been hearing of problems using Ghost to get an image and placing the image onto the new drive. I think this is more of a Windows 2003 problem, but this server is for nothing but the SQL Server databases. Does anyone have a clear method of moving this server to the larger drives? TIA.
4
1875
by: =?ISO-8859-9?B?Wf1sbWF6?= | last post by:
Hello, I need to learn where mssql server stores its data. I knew it was in Program files\Common files\ But I cant find.. Its urgent pls.. Thanx
5
21818
by: sangeethass | last post by:
How to export sql server-2005 table data into excel sheet .. Can u tell me how can i do this both my manually and by programmewise using perl please help me... thanks Sangeetha.S
0
9820
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
10814
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
10462
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...
0
9630
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8016
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
7169
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5849
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
6041
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4676
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

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.