Moving SQL Server 2005 x86 from Dell 1950 to Dell 2950 running SQL2005 x64

Hi,
I'm trying to figure out the best way to do this with the less
headache. I have a SQL 2005 server, let's call it SQL01. It is on a
Dell 1950. I want to move the SQL services to a Dell 2950 running 64
bit OS and SQL 2005 x64 but I want to keep the server name the same
and also retain login permissions on the databases that get moved.
I'm trying to see if I can leverage Backup Exec for this. So I would:
1. Perform a Full SQL Database backup on server SQL01 with Backup
Exec.
2. Remove Dell 1950 SQL01 server from Domain and reset computer
account in AD.
3. Join Dell 2950 to domain as SQL01 and Install SQL 2005 x64,
including any patches.
4. Perform SQL restore on new SQL01 server with Backup Exec
5. Bring up applications and test applications.
Is this reasonable or not?
Is there a better way?
On Apr 9, 4:57Xam, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> "Jose A. Hernandez" <jhbori...@.gmail.com> wrote in messagenews:b48aa821-eb8d-4b78-be58-cc20b7283745@.x41g2000hsb.googlegroups.com...
>
>
>
>
>
> Hi
> If you are using windows security and the access is granted by membership of
> domain groups your transfer of logins will be the simplest.
> http://support.microsoft.com/kb/314546is a good place to start. Don't
> forget jobs and SSIS packages if you have them.
> John- Hide quoted text -
> - Show quoted text -
Thanks for the KBs John, I'll check them up.