March 15, 2010 at 9:56 am
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 ..
March 15, 2010 at 10:51 am
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 15, 2010 at 10:57 am
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?
March 16, 2010 at 6:50 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 16, 2010 at 8:16 am
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?
---------------------------------------------------------------------
March 16, 2010 at 10:16 am
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 16, 2010 at 10:31 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 16, 2010 at 11:07 am
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply