SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Moving DB from local disk to SAN.


Moving DB from local disk to SAN.

Author
Message
InterestedInT-SQL
InterestedInT-SQL
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 452
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
sqlsurfing
Old Hand
Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)

Group: General Forum Members
Points: 392 Visits: 1185
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 :-D
durai nagarajan
durai nagarajan
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1629 Visits: 2775
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search