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

any document on Moving databases from One Server to another Expand / Collapse
Author
Message
Posted Monday, March 15, 2010 9:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 19, 2014 2:20 PM
Points: 140, Visits: 543
Any document on Moving databases from One Server to another

I have 2 Active Server , I can't stop there Server . I want to move these databases from one server to another server ..lot of DTS packages are running on the Server ..

any document/ Planning Document will be really appreicated ..


Thanks
John ..
Post #883092
Posted Monday, March 15, 2010 10:51 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:51 PM
Points: 21,644, Visits: 15,317
What versions of SQL Server? What kind of environment (clustered, replication)?

A little more information might be helpful.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #883144
Posted Monday, March 15, 2010 10:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 20, 2013 9:25 AM
Points: 389, Visits: 357
CirquedeSQLeil (3/15/2010)
What versions of SQL Server? What kind of environment (clustered, replication)?

A little more information might be helpful.


And is it complete server migration? or just few databases? how big those databases are?


EnjoY!
Post #883148
Posted Tuesday, March 16, 2010 6:50 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 15,662, Visits: 28,055
What about a simple backup and restore? Or are you trying to build some sort of deployment mechanism?

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #883724
Posted Tuesday, March 16, 2010 8:16 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:55 AM
Points: 5,989, Visits: 12,927
John Paul, please don't duplicate post

http://www.sqlservercentral.com/Forums/Topic883258-5-1.aspx#bm883447

now we don't know whether this is SQL 2000 or 2005?

or are you doing one of each?


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

Post #883802
Posted Tuesday, March 16, 2010 10:16 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:51 PM
Points: 21,644, Visits: 15,317
Grant Fritchey (3/16/2010)
What about a simple backup and restore? Or are you trying to build some sort of deployment mechanism?


Backup and restore would be my first inclination for users databases. However, if they are moving from SQL 2K to SQL 2K8, there are some other nuances to be addressed (dts, ssis, jobs) that would be different.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #883961
Posted Tuesday, March 16, 2010 10:31 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 15,662, Visits: 28,055
CirquedeSQLeil (3/16/2010)
Grant Fritchey (3/16/2010)
What about a simple backup and restore? Or are you trying to build some sort of deployment mechanism?


Backup and restore would be my first inclination for users databases. However, if they are moving from SQL 2K to SQL 2K8, there are some other nuances to be addressed (dts, ssis, jobs) that would be different.


Even if I was moving between 2K & 2K8, I'd do a backup and restore, but, as you say, stuff before and stuff after. Without knowing what's really desired here, it's all just guess work.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #883976
Posted Tuesday, March 16, 2010 11:07 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:51 PM
Points: 21,644, Visits: 15,317
Grant Fritchey (3/16/2010)
CirquedeSQLeil (3/16/2010)
Grant Fritchey (3/16/2010)
What about a simple backup and restore? Or are you trying to build some sort of deployment mechanism?


Backup and restore would be my first inclination for users databases. However, if they are moving from SQL 2K to SQL 2K8, there are some other nuances to be addressed (dts, ssis, jobs) that would be different.


Even if I was moving between 2K & 2K8, I'd do a backup and restore, but, as you say, stuff before and stuff after. Without knowing what's really desired here, it's all just guess work.


It's the stuff before and after that has me concerned. Thus agreed, that it is a bunch of guesswork until the Op returns with more info.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #884013
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse