Move ASP website with MS SQL 2005

Databases
1

Hello,

I have a website in ASP with MSSQL, which I want to move to another server.

I have moved the files but I dont know how to move the database and configure it so that it works fine in the new hosting.

Can anyone help. Thanks.

2

Hey schwarzes,

You’ll need to

  1. backup the database (either by performing a data dump or a extracting the database to sql)

  2. Load the data into your new server

  3. Change the references on your website to use the new server.

You can find out how to do 1 and 2 here: http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups