Moving DB from local disk to SAN.

• InterestedInT-SQL

  Newbie

  Points: 6

  More actions

  August 12, 2013 at 10:59 am

  #281047

  Dear SSC team,

  I hope your day is going well. I am tasked to move SQL Server 2008 DB, 2TB, which is in Simple Recovery Model, from local disk to a SAN, and it is on Developer Edition. The compatibility level is 90, I do not know if it will affect moving the database. It goes without saying NO DOWNTIME is allowed. Any suggestions? I have been considering backup/restore as an option.

  Thanks for your response.

  Dan.

• sqlsurfing

  SSCarpal Tunnel

  Points: 4883

  More actions

  August 13, 2013 at 3:56 am

  #1640844

  berhanem 9188 (8/12/2013)

  ---

  Dear SSC team,

  I hope your day is going well. I am tasked to move SQL Server 2008 DB, 2TB, which is in Simple Recovery Model, from local disk to a SAN, and it is on Developer Edition. The compatibility level is 90, I do not know if it will affect moving the database. It goes without saying NO DOWNTIME is allowed. Any suggestions? I have been considering backup/restore as an option.

  Thanks for your response.

  Dan.

  I think the challenge is having no downtime, it sounds like you will be moving to a new server?

  You can do as you stated "back up and restore the DB to it's new location by using "MOVE" command within your restore t-sql to assign new path. In SSMS you should be able to do the same, but that would take longer than t-sql due to time navigating the interface.

  However moving to a new server-you will have to consider things such as user logins/jobs/ssis packages/etc.. so you will need to restore the rest of the dbs, with exception of tempdb. If you are only moving the User DB (it does sound like you are moving a completely new server?), you will have to gather all the information for DB logins, you can do that by writing or finding a script that will help you.

  If you run a google/bing search there should be websites full instructions.

  --------------------------------------------------
  ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

• durai nagarajan

  SSCoach

  Points: 15778

  More actions

  August 13, 2013 at 5:04 am

  #1640858

  2TB DB in Simple Recovery Model in local disk , how was the performance?

  recently i restored a 1TB backup available from SAN drive to SAN drive took around 4.5 hours. so you can expect more delay for backup and restoration.

  for no downtime(try the below but zero downtime never possible)

  Change DB to full recovery.

  Take full backup from old server.

  Schedule log backup for 1 hour or so.

  Create login,job,SSIS, alerts,DB mails etc on new server.

  Restore it on new server in fullbackup and log sequence.

  change applciation to point to new server and check.

  (in case of any issue rollback to old server and backup and log backup will be helpful for another restore)

  Regards
  Durai Nagarajan