Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2005-12-04 : 07:53:36
|
| hellowe are moving from a win2k to a win2003 server and have to move our db as wellWhats the best way(s) of doing this ?Afrika |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-04 : 14:41:47
|
http://weblogs.sqlteam.com/derrickl/archive/2005/12/04/8484.aspxI've answered this question a LOT, so I finally figured that I should just blog it.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-12-05 : 00:58:52
|
| Hi,may suggest this too FYI :http://vyaskn.tripod.com/moving_sql_server.htm:-)RegardsAndy DavisActivecrypt Team--------------------------------------------SQL Server Encryption Softwarehttp://www.activecrypt.com |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-05 : 03:32:59
|
| very very nice articlesthanks Derrick, Andy for your advice |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-05 : 05:20:58
|
| "I've answered this question a LOT, so I finally figured that I should just blog it"Very useful Derrick"Move system databases"Why not choose the appropriate default location during INSTALL - and then the system databases will be in the right place?This link might help too:http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=44537My understanding of TLog restore at that time was shaky! but it has a detailed list of actions to move a database to a new server where the database is being accessed by a web site (there was no downtime for the web site, although there was some "Please wait 2 minutes and then Click Here" time!)Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-05 : 23:29:48
|
quote:
Why not choose the appropriate default location during INSTALL - and then the system databases will be in the right place?
We don't do this because we only want the database files moved, not the error logs and other things that get moved. We also want the log and data files in seperate directories. quote:
My understanding of TLog restore at that time was shaky! but it has a detailed list of actions to move a database to a new server where the database is being accessed by a web site (there was no downtime for the web site, although there was some "Please wait 2 minutes and then Click Here" time!)
We would actually just move the LUNs over if we were going with this option. If you don't have that option though, then your method would be quicker. I have updated the document to link to your post.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-06 : 03:48:13
|
"I have updated the document to link to your post"Cheers  |
|
|
|
|
|
|
Moving servers