Link to home
Start Free TrialLog in
Avatar of lrbarrios
lrbarrios

asked on

How to move websites and SQL databases from Windows 2003 server to new Windows 2008 server

I am in a tight position here.  The data center that my production server (Windows 2003) is sitting in will be shutting down in a week.  In preparation for this, my hosting company built me a new Windows 2008 server in another one of their nearby data centers.  It's up and running and ready to go.  It has been for some time.  I was originally going to have the personal who developed the website and databases to help me with this migration.  I can't seem to contact him now.  I'm a little desperate to make this happen quickly.  I need to transfer (probably via FTP) all of my existing websites (and their SQL databases) from the old server to the new server.  This is the first time I've seen 2008 and its IIS.  It looks a bit different from the IIS that I'm running on the old server (I don't know what version -- it doesn't say).  Both servers are running MS SQL 2008.  Can someone please guide me through this process?
SOLUTION
Avatar of becraig
becraig
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Emmanuel Adebayo
Emmanuel Adebayo
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lrbarrios
lrbarrios

ASKER

Thanks all for the help.  For the most part, it was fairly painless.  My sites are up and running.  The biggest problem that I am dealing with is trying to transfer a 126GB database file from the old server (in the old data center) to the new server (in the new data center) across the public Internet.  Slow-going and prone to interruptions.  I've broken up the file (using 7zip) into 700MB chuncks -- a total of 157 files.  If there are any corrupted files on the destination, I will just create PAR2 recovery files for those files using the original source files still on the old server.  Then I'll only need to transfer the PAR2 files (which will be much smaller).  Hoping this works.  Fingers crossed.  Thanks again.