473,387 Members | 1,398 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > microsoft sql server > questions > sql server drive died, data drive is ok... now what?

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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

5
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

✓ answered by NeoPa

If the database is fine it can be reattached later when the SQL Server is rebuilt.

1 1759
NeoPa
32,556 Expert Mod 16PB
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
Server Explorer - Add Data Connection - Add new Data Provider to l
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...
C# / C Sharp
2
Dot Net Web Server has died - aspnet_wp.exe Problem - Help !!
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...
ASP.NET
2
Moving SQL Server to a new drive
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...
Microsoft SQL Server
1
## How to acquire the SQL Server 2000 Performance data? ##
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...
Microsoft SQL Server
4
copy an Excel workbook from one drive to another drive
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...
Visual Basic 4 / 5 / 6
1
How to access a local drive (including removable drive) in a terminal server session programmatically?
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
Visual Basic .NET
0
[Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation
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...
Microsoft SQL Server
3
SQL Server moving to larger drive
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...
Microsoft SQL Server
4
I need to know where mssql server stores its data.
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
Microsoft SQL Server
5
how to export sql server-2005 table data into excel sheet
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
Microsoft SQL Server
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Basic Javascript concepts
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
Javascript
0
Merging data from multiple Excel files
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Data Management
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
C / C++
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Changing the language in Windows 10
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...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++

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.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!