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 |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2003-06-06 : 18:01:36
|
| I just wanted to thank everyone who's helped answer my various questions over the past couple of months. From RAID config to moving MSDB jobs to filegroup config, you all really helped me out.Thanks to your kind advice and feedback, we managed out big server switchover with about 90 minutes of downtime, compared to our budgeted 3 hours. The file copies alone took about 60 of those 90 minutes.So it was a tremendous success, and I look good, in large part thanks to the help here.Cheers -- I'm off to get a margarita or six. I'd get a couple of pitchers for the SQLTeam folk, but I'm told they don't ship well.-b |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-06 : 18:04:10
|
| Well I'm glad it all worked out for you. Typically, the file copies here take a long time too, so we always zip them up first, then copy them over to the destination server, then unzip them. This works very well for us.Tara |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-06-06 : 18:47:22
|
| now you tell him! ;) |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-06 : 18:55:07
|
DAMN!Do you know how much time I spent bcp'ing out the data, printing it out, and tapping it out on the morse transmitter to the other DBA, just so he could reverse the process? |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-06-06 : 19:01:34
|
| Rob, why not get with the times and use a Punch Card!! Load em up in a trailer and pull it with a Yak to the destination. Now that's a SQLTeam solution!!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2003-06-07 : 01:01:14
|
| And here I thought our 600 mile relay chain of smoke signals was state-of-the-art!Actually, we considered the ZIP or RAR approach, but decided that between the compression and decompression, it would save no more than 20 minutes of the 60 minute transfer, and counted as two more steps that could go wrong. For our purposes, a 3 hour downtime window was acceptable, and as it turned out the 90 minute downtime meant I got to get to sleep earlier than planned :)Cheers-b |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-07 : 01:43:32
|
| >> and counted as two more steps that could go wrong.yep>>I got to get to sleep earlier than planned sleep - I remember that>>And here I thought our 600 mile relay chain of smoke signals was state-of-the-art!hmmm - our drums suffer in thunderstorms - do you think it's worth a go?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
|
|
Thanks, everyone!