I have a desktop PC (Windows 7) with 1 TB HDD which has SQL Server 2008 R2 installed. Now it is getting replaced by a laptop with 500G SSD drive. This would be first experience working with a SSD. But I have been told not to install SQL Server 2008 R2 on SSD drive. Can I buy an external hard disk and install SQL Server 2008 R2 on it? Will the database work transparently with the laptop in this way?


closed as off-topic by Massimo, Sven Dec 29 '16 at 11:38

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions on Server Fault must be about managing information technology systems in a business environment. Home and end-user computing questions may be asked on Super User, and questions about development, testing and development tools may be asked on Stack Overflow." – Sven
If this question can be reworded to fit the rules in the help center, please edit the question.


Aside from this question being OT in the first place, there is no reason at all to not install SQL Server on a SSD drive; and even if there was one, or if you just didn't want to install it on your system drive... installing it on an external disk makes definitely a lot less sense.

That said, you can do that and it will work (as long as you keep the external disk plugged in); but it's just an astonishingly bad setup.

  • Laptop has only 1 Hard Disk Drive bay. And I did not get permission to install SQL Server on it; the reason I was given: the Hard Disk is SSD and it is not recommended to install any database on SSD. What other option I have to get SQL Server other than an external disk? – srh Jan 7 '17 at 6:08
  • "Not recommended" by whom? That statement doesn't make any sense without some context (and even with context...). – Massimo Jan 7 '17 at 12:39
  • "Not recommended" by the IT support personnel in my company. These are the guys who setup PCs/laptops in my company and would report me if I installed something which they have not recommended which in case may result in my firing. – srh Jan 7 '17 at 20:33
  • @srh sorry for your company, but this still doesn't make any sense. Please advise them to get a f**kin' clue. And change company as you can. – Massimo Jan 8 '17 at 6:44

Not the answer you're looking for? Browse other questions tagged or ask your own question.