tag:blogger.com,1999:blog-5812558148803847895.post3924141237656530567..comments2023-11-24T08:34:55.711-08:00Comments on Made By SQL: How to upgrade to SQL Server 2008 R2 with minimal downtime: 1-2 minutesDan Pretselmanhttp://www.blogger.com/profile/15931530494260744354noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5812558148803847895.post-21160969589888444972011-08-24T10:04:18.005-07:002011-08-24T10:04:18.005-07:00We used different LUNsWe used different LUNsDanphttp://madebysql.blogspot.com/noreply@blogger.comtag:blogger.com,1999:blog-5812558148803847895.post-47890544617975655712011-08-24T07:41:05.851-07:002011-08-24T07:41:05.851-07:00Did you use different LUNS for this setup or were ...Did you use different LUNS for this setup or were you able to use the same disk resource?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5812558148803847895.post-36414523640533857502011-06-27T13:06:12.360-07:002011-06-27T13:06:12.360-07:00Database size: about 100 GB
Multiple DBs: No,only ...Database size: about 100 GB<br />Multiple DBs: No,only 1 DB was mirrored<br />Storage: The files path was different than the<br /> original due to the Mirroring.Dan Pretselmanhttp://madebysql.blogspot.comnoreply@blogger.comtag:blogger.com,1999:blog-5812558148803847895.post-41218175871065008282011-06-27T07:18:41.399-07:002011-06-27T07:18:41.399-07:00What size databases were you working with and did ...What size databases were you working with and did you have multiple ones? I am looking to do the same thing but with detach/reattach but after reading this it would limit steps and decrease downtime. I am also curious about the shared storage. When you were done with everything I am assuming the DB files were on the same san storage but they had to be within different directories then the original locations!?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5812558148803847895.post-57409180577611005902011-05-05T12:08:21.357-07:002011-05-05T12:08:21.357-07:00Because in my scenario
we do NOT do In-place Upgra...Because in my scenario<br />we do NOT do In-place Upgrade of <br />existing SQL Server,<br /><br />It more likely 'Side by Side Upgrade'Dan Pretselmanhttps://www.blogger.com/profile/15931530494260744354noreply@blogger.comtag:blogger.com,1999:blog-5812558148803847895.post-19353235007564214462011-05-05T05:52:33.150-07:002011-05-05T05:52:33.150-07:00Why do you break the cluster (unless you change th...Why do you break the cluster (unless you change the cluster architecture)? You should just run upgrade wizard on each node.Anonymousnoreply@blogger.com