Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Moving SQL Server DB's Expand / Collapse
Author
Message
Posted Thursday, July 31, 2014 12:04 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 12, 2014 8:08 AM
Points: 52, Visits: 162
We have a SQL Server located in India; We need to move all the DB's on that server to a server residing locally for various legal reasons. The Server in India is a 2008 running 24 databases. 3 of these DB's are over 100GB and all 3 of them are being replicated from a third server in India. I am looking for high-level steps I will need to perform this so as to make sure I don't miss anything. Please advise, especially on problems I can expect to run into.

thanks!
Post #1598421
Posted Thursday, July 31, 2014 12:10 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 40,632, Visits: 37,094
Back up databases
Script logins (with SIDs and passwords)
Script any linked servers
Script any jobs

Copy backups, restore on new server, run the scripts you created.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1598424
Posted Thursday, July 31, 2014 2:16 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 12, 2014 8:08 AM
Points: 52, Visits: 162
Thanks for the response Gila. Any comments or experience on moving the files of VLDB's over the net? I am particularly concerned about the time it might take to copy the files over.
Post #1598478
Posted Friday, August 1, 2014 2:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 12:56 AM
Points: 210, Visits: 679
Use robocopy for transferring the backup files... Cant really comments on time taken to transfer... depends on your network speed
If you can use a compressed backup , even better...
Try breaking backup into multiple files instead of one big file..


Cheers
Post #1598610
Posted Friday, August 1, 2014 3:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:39 PM
Points: 6,760, Visits: 14,412
Like2SQL (7/31/2014)
We have a SQL Server located in India; We need to move all the DB's on that server to a server residing locally for various legal reasons. The Server in India is a 2008 running 24 databases. 3 of these DB's are over 100GB and all 3 of them are being replicated from a third server in India. I am looking for high-level steps I will need to perform this so as to make sure I don't miss anything. Please advise, especially on problems I can expect to run into.

thanks!

What network connection facilities do you have between sites if any?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1598633
Posted Friday, August 1, 2014 6:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 2, 2014 11:16 AM
Points: 2, Visits: 11
Excellent. I was about to ask the same basic question.

Do I need to copy the system databases to the new location?
Post #1598658
Posted Friday, August 1, 2014 7:07 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 40,632, Visits: 37,094
Like2SQL (7/31/2014)
Any comments or experience on moving the files of VLDB's over the net?


Be patient, take a good book.
Or copy the files to an external drive and courier/drive it to the new location.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1598669
Posted Friday, August 1, 2014 7:44 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 7:25 AM
Points: 510, Visits: 1,895

Or copy the files to an external drive and courier/drive it to the new location.



It genuinely can be quicker to get on a plane with a hard drive yourself.
Post #1598691
Posted Friday, August 1, 2014 8:15 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 2:04 PM
Points: 492, Visits: 2,043
Beatrix Kiddo (8/1/2014)

Or copy the files to an external drive and courier/drive it to the new location.



It genuinely can be quicker to get on a plane with a hard drive yourself.


I'm about to copy 25 terabytes worth of databases from DAS to SAN.

Gonna be a lot of pencils in the ceiling.

A lot of pencils.

Post #1598707
Posted Friday, August 1, 2014 11:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 14, 2014 11:01 AM
Points: 11, Visits: 33
you mentioned that 3 of databases are part of replication. then there may be a publisher and distributer.

when you move these databases then you need to generate new publications and then subscribe to these database.

restore MSDB backup ,all jobs will be restored.
Post #1598770
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse