So both SA accounts have to have the same username and passwords?
The server names will have changed so I know I will have to let the clients know.
I was kind of swayed to detach the database. The SQL install directory can change yes?
Zberteoc
Is the old server the same version? If the old server is of an earlier version you have the choice to keep or change the compatibility level. There is also a advisor that can help with this kind of migration:
If you detach and attach the files you don't have to do anything with the location. Just move the files in the folder where you want to keep them on the new server. Database doesn't even has to exist on the new server.
Bransby-IT
ASKER
Great stuff, well I have just got the server ready to install SQL 2008, after the install I need to apply any patches ect. Which is my best option for this?
Bransby-IT
ASKER
Thanks for your help team. Back in the New Year!
Merry Christmas.......
by: ZberteocPosted on 2012-12-21 at 14:47:05ID: 38713123
Rank: Sage
Do you have any SQL jobs setup on the old server? If yes you will need to move them as well.
When you say this what do you mean? How can I tell?
Zberteoc
If you expand the SQLAgent node > Jobs > Right Ckick on the job, if there are any > Properties and then in the windows that opens check the steps details and see if any of them are executed against the database you need to move. If yes then you will help to recreate the jobs on the other server. You can actually script them out.
The server names will have changed so I know I will have to let the clients know.
I was kind of swayed to detach the database. The SQL install directory can change yes?