Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Will upgrading from SQL Server 2008 to SQL Server 2008 R2 affect any existing databases?

I'm amazed at ReportBuilder 3.0. This might be just what I need for my job. I haven't thoroughly checked the differences between SQL Server 2008 and its R2 version so I don't know if upgrading would be a hassle.

like image 283
Jonn Avatar asked Apr 17 '26 02:04

Jonn


1 Answers

SQL Server 2008 to R2 is quite minor. Especially compared from SQL Server 2000, say.

Be warned: once your databases are upgraded, they can not be restored on an install of an older version. It's a quite common question on StackOverflow and ServerFault...

like image 55
gbn Avatar answered Apr 20 '26 09:04

gbn