0

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?

Thanks

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.

2

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.