10 pts.
 Moving a SQL database from one host to another
I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site. Can anyone offer advice or point me to some utlities that can do this?

Software/Hardware used:
ASKED: April 28, 2008  2:54 AM
UPDATED: May 8, 2008  1:29 AM

Answer Wiki:
Does the current hosting provider offer you a way to backup the database, and get access to that backup? What sort of access to the SQL Server do you have? Do you have to use thier web based tool, or can you connect directly to the SQL Server using the native SQL Server tools? The answers to these questions will greatly impact your ability to move the database.
Last Wiki Answer Submitted:  April 29, 2008  5:18 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,520 pts.