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

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?"Jose A. Hernandez" <jhboricua@.gmail.com> wrote in message
news:b48aa821-eb8d-4b78-be58-cc20b7283745@.x41g2000hsb.googlegroups.com...
> 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?
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/314546 is a good place to start. Don't
forget jobs and SSIS packages if you have them.
John|||On Apr 9, 4:57=A0am, "John Bell" <jbellnewspo...@.hotmail.com> wrote:
> "Jose A. Hernandez" <jhbori...@.gmail.com> wrote in messagenews:b48aa821-eb=8d-4b78-be58-cc20b7283745@.x41g2000hsb.googlegroups.com...
>
>
> > Hi,
> > I'm trying to figure out the best way to do this with the less
> > headache. =A0I have a SQL 2005 server, let's call it SQL01. =A0It is on =a
> > Dell 1950. =A0I 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. =A0So 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?
> 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.