October 5, 2016 at 6:40 am
Hi All, our storage team is planning to do San migration(from old to new). From application point of view what all steps should I follow to perform complete validity post migration ? We use SQL 2008 DB servers.
October 5, 2016 at 9:02 am
Hi, all the SAN migrations I have been a part of usually consisted of (post migration) checking the Sql Server services and access to the instance, databases, and maybe a select count query on a random table in one or more databases. From the application side, ensure the application can connect and perform a few functions. SAN migrations have become so advanced that many of them are transparent to the Sql environment and sometimes no downtime from a Sql Server perspective is required. To be safe though, it would not hurt to run backups on all the databases under the instance. If there is an issue, it most likely will be with the storage during or following the migration. It is great to have all full database backups just in case you would need to totally rebuild your sql environment.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply