Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ostinoh
Yak Posting Veteran
66 Posts |
 Posted - 2012-08-22 : 12:38:25
|
| Hello - I have an application that is currently on a SQL Server 2008 instance I'll call instance A. That department wants to upgrade the application and wouldn't you know it SQL Server 2008 is not supported (a surprise to me). 2008 R2 and SQL Server 2012 are supported.On this server also sits another instance of SQL 2008 I'll call instance B. So I don't want to take the chance of crashing those apps on instance B I will not upgrade instance A to 2008 R2 and affect the common files. But instead will install another instance of 2008 R2 so the common files will not be affected from instance B. I hope that made sense.There is limited space so restoring the database to the new R2 instance is out of the question. Do you know issues or concerns with detaching and reattach the db to the new instance? Basically redirecting the data files from the 2008 to 2008 R2. What scripts besides running sp_removedbreplication would I need to run or can recommend?Regards,David |
|
|
|
|
|
SQL 2008 Database Move To 2008 R2?