New to SQL

[jakess]

We have a few SQL databases on SBS 2003 and we are buying new server hardware.
I need to move the databases from the old server to the new server but the new server will have a new servername and the databases needs to be on a seperate drive.
What actions should i take keeping in mind i'm new to database management?

 

[ptheriault]

There are a few ways you can migrate these databases. It depends on your requirements. Are users still going to accessing this server while you are building the new one? If so you will need to use the backup/restore method to migrate to the new server.
Here is what I would do.
1. Install SQL and proper SP
2. create logins. There is an FAQ on how to use sp_help_revlogins to move your logins. You want to move your logins this way so the SIDS don't change.
3. Backup your databases include the msdb database if you have jobs you need on your new server.
4. Copy the backups to the new server and restore them using the 'With Move' option so you can place the .mdf and .ldf files where you want.

If users don't need to access the databases you can use the detach and attach method instead of backup/restore.

You would right click on the database in Enterprise Manager select all tasks -> detach. Then copy the .mdf and .ldf files to the new server where you would then attach them.

Let me know if you need more details on any of these steps

- Paul
- If at first you don't succeed, find out if the loser gets anything.