replacing 3 drives out of 8 in a server [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 7 years ago. Improve this question We have a Dell R510 server running SQL 2008 R2 with 8 x 300GB drives running Raid 5. We (just noticed) we had … Read more

Server for SQL 2008 [closed]

It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 10 years ago. What will be the best Server Configuration for … Read more

System databases are in standby…how can I make them editable?

My System Databases are stuck in a standby/read-only state. RESTORE DATABASE msdb WITH RECOVERY does not seem to have had any affect. How can I get them out of the standby state? Answer This could be a lot of things. Did your server crash? Have you made any changes? First of all, just for giggles: … Read more

SQL Server 2008 R2 Express accepts only local connections? [closed]

It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago. Coming from question SQL Server 2008 connection tagged … Read more

Compatibility issues with sql server 2008 data center edition on windows 8 [closed]

Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Server Fault. Closed 9 years ago. Improve this question I am trying to install Sql Server 2008 R2 Data Center Edition on Windows 8 but I am getting this message: “This program … Read more

60Gb of Memory, 32-bit OS and PAE vs 64-bit OS

I have 60 Gb of RAM on server. Windows 2008, 32bit with PAE. One Sql Server 2008 Express Instance can use 1 Gb of RAM. So if I install 60 instances, each can use 1 Gb of RAM, right? And the second question, what will be if I install 64bit system and use many Express … Read more

Uninstall SQL Server

how do I uninstall SQL Server 2008 manually? Add/remove programs does not uninstall everything. Thanks in advance. Answer To uninstall SQL all the way, use the uninstaller to remove the instance and services. Then delete the install directories. Or, check out this link from Microsoft. AttributionSource : Link , Question Author : Community , Answer … Read more

Processing data faster using ssis and an ssd drive

We have a new local server that processes data using sql server 2008 and ssis. in this server i have dedicated drive to do different things. the c drive is for the os and software. the d drive is for db storage , and the ssis . The e drive is a ssd drive that … Read more

How to solve connection isuse [closed]

It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 10 years ago. Connection problem error message: NHibernate.ADOException: cannot open connection … Read more