Best way to move SQL 6.5 to new hardware

Hi,
Can anyone tell me the best way to moving MS SQL 6.5 System to new
Hardware Box?
I already setup new SQL Server using different computer name, just want
to copy all data and security info to new one.
Many thanks in advance.
Regards,
Chris Lee
Chris,
there's a huge amount of things to take into account, but when I did it I
found this article very helpful:
http://www.microsoft.com/technet/pro...y/sqlugrd.mspx
HTH,
Paul Ibison
|||Dear Paul,
Thanks for your reply, but the article apply to SQL 6.5 to SQL 6.5 upgarde?
Regards,
Chris Lee
|||Hi,
Did you installed the SQL Server with the same directory structure as actual
(Old) SQL server. If yes then:-
1. Apply the same service pack in the new server (Probably sp5a + post
update 5a)
2. Stop the SQL server in old server and new server
3. Copy all the DAT (Including system databases) files from (
drive:\mssql\data) old server to
new server
4. Start SQL server in new server
5. Using ISQLw login to SQL Server and execute the below script
sp_dropserver 'old_server_name',
go
sp_addserver 'new_server_name', 'local'
6. Stop and Start the SQL Server service
Thanks
Hari
MCDBA
"Chris Lee" <c_h_r_i_s_l_e_e_@.h_o_t_m_a_i_l_._c_o_m> wrote in message
news:ca93g0$2pf8@.imsp212.netvigator.com...
> Hi,
> Can anyone tell me the best way to moving MS SQL 6.5 System to new
> Hardware Box?
> I already setup new SQL Server using different computer name, just want
> to copy all data and security info to new one.
> Many thanks in advance.
> Regards,
> Chris Lee
|||Apologies - just assumed you were upgrading. Please refer
to Hari's post then.
Regards,
Paul Ibison
|||Thanks Hari,
It's work!!! Great Thanks!
Regards,
Chris Lee

Best way to move SQL 6.5 to new hardware

Hi,
Can anyone tell me the best way to moving MS SQL 6.5 System to new
Hardware Box?
I already setup new SQL Server using different computer name, just want
to copy all data and security info to new one.
Many thanks in advance.
Regards,
Chris LeeChris,
there's a huge amount of things to take into account, but when I did it I
found this article very helpful:
http://www.microsoft.com/technet/pr...oy/sqlugrd.mspx
HTH,
Paul Ibison|||Dear Paul,
Thanks for your reply, but the article apply to SQL 6.5 to SQL 6.5 upgarde?
Regards,
Chris Lee|||Hi,
Did you installed the SQL Server with the same directory structure as actual
(Old) SQL server. If yes then:-
1. Apply the same service pack in the new server (Probably sp5a + post
update 5a)
2. Stop the SQL server in old server and new server
3. Copy all the DAT (Including system databases) files from (
drive:\mssql\data) old server to
new server
4. Start SQL server in new server
5. Using ISQLw login to SQL Server and execute the below script
sp_dropserver 'old_server_name',
go
sp_addserver 'new_server_name', 'local'
6. Stop and Start the SQL Server service
Thanks
Hari
MCDBA
"Chris Lee" <c_h_r_i_s_l_e_e_@.h_o_t_m_a_i_l_._c_o_m> wrote in message
news:ca93g0$2pf8@.imsp212.netvigator.com...
> Hi,
> Can anyone tell me the best way to moving MS SQL 6.5 System to new
> hardware Box?
> I already setup new SQL Server using different computer name, just want
> to copy all data and security info to new one.
> Many thanks in advance.
> Regards,
> Chris Lee|||Apologies - just assumed you were upgrading. Please refer
to Hari's post then.
Regards,
Paul Ibison|||Thanks Hari,
It's work!!! Great Thanks!
Regards,
Chris Lee

Best way to move SQL 6.5 to new hardware

Hi,
Can anyone tell me the best way to moving MS SQL 6.5 System to new
Hardware Box?
I already setup new SQL Server using different computer name, just want
to copy all data and security info to new one.
Many thanks in advance.
Regards,
Chris LeeChris,
there's a huge amount of things to take into account, but when I did it I
found this article very helpful:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
HTH,
Paul Ibison|||Dear Paul,
Thanks for your reply, but the article apply to SQL 6.5 to SQL 6.5 upgarde?
Regards,
Chris Lee|||Hi,
Did you installed the SQL Server with the same directory structure as actual
(Old) SQL server. If yes then:-
1. Apply the same service pack in the new server (Probably sp5a + post
update 5a)
2. Stop the SQL server in old server and new server
3. Copy all the DAT (Including system databases) files from (
drive:\mssql\data) old server to
new server
4. Start SQL server in new server
5. Using ISQLw login to SQL Server and execute the below script
sp_dropserver 'old_server_name',
go
sp_addserver 'new_server_name', 'local'
6. Stop and Start the SQL Server service
Thanks
Hari
MCDBA
"Chris Lee" <c_h_r_i_s_l_e_e_@.h_o_t_m_a_i_l_._c_o_m> wrote in message
news:ca93g0$2pf8@.imsp212.netvigator.com...
> Hi,
> Can anyone tell me the best way to moving MS SQL 6.5 System to new
> Hardware Box?
> I already setup new SQL Server using different computer name, just want
> to copy all data and security info to new one.
> Many thanks in advance.
> Regards,
> Chris Lee|||Apologies - just assumed you were upgrading. Please refer
to Hari's post then.
Regards,
Paul Ibison|||Thanks Hari,
It's work!!! Great Thanks!
Regards,
Chris Lee

Best Way to migrate databases

Hi all,
What is the best way to migrate all databases from one sql server to
another?
We are buying a new hardware for the database server and we need to move all
databases to the new machine.
Thanks in advance,
Fabio
I like BACKUP and RESTORE, but sp_detach_db and sp_attach_db also work.
Here are some KB articles for you:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Fabio" <fabio@.glb.com.br> wrote in message
news:ugv$2CF6EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move
all
> databases to the new machine.
> Thanks in advance,
> Fabio
>

Best way to migrate databases

Hi all,
What is the best way to migrate all databases from one sql server to
another?
We are buying a new hardware for the database server and we need to move all
that new hardware.
Thanks in advance,
Fbio Augusto
First option I would go about is backup/restore. You can consider
detach/attach also.
Thanks
GYK
"Fabio" wrote:

> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move all
> that new hardware.
> Thanks in advance,
> Fábio Augusto
>
>
|||http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Fabio" <fabio@.glb.com.br> wrote in message
news:%23ZYDHJg4EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move
> all
> that new hardware.
> Thanks in advance,
> Fbio Augusto
>

Best way to migrate databases

Hi all,
What is the best way to migrate all databases from one sql server to
another?
We are buying a new hardware for the database server and we need to move all
that new hardware.
Thanks in advance,
Fábio AugustoFirst option I would go about is backup/restore. You can consider
detach/attach also.
Thanks
GYK
"Fabio" wrote:
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move all
> that new hardware.
> Thanks in advance,
> Fábio Augusto
>
>|||http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Fabio" <fabio@.glb.com.br> wrote in message
news:%23ZYDHJg4EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move
> all
> that new hardware.
> Thanks in advance,
> Fábio Augusto
>

Best Way to migrate databases

Hi all,
What is the best way to migrate all databases from one sql server to
another?
We are buying a new hardware for the database server and we need to move all
databases to the new machine.
Thanks in advance,
FabioI like BACKUP and RESTORE, but sp_detach_db and sp_attach_db also work.
Here are some KB articles for you:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Fabio" <fabio@.glb.com.br> wrote in message
news:ugv$2CF6EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move
all
> databases to the new machine.
> Thanks in advance,
> Fabio
>

best way to change servers for a live database?

I have a 24/7 live Sql Server 7 database. The server hardware is old. I
have a new computer for this Sql Server, and I will also be switching to SQL
Server 2000. What's the best way to transition from one to the other? I
can install everything on the 2nd server, and start using a different server
name, and I can tolerate 20 minutes of downtime when I finally switch from
one machine to the other. But I don't know the best way to get the
database from one machine to the new machine, in a fast way. Other times
I've moved databases, I've found problems with the user records not matching
to the same user IDs in the Master System tables. And stored procedures
that have "dbo" owners suddenly freak out because that dbo isn't a valid
user ID anymore, etc.Safest way of copying the data is backup and restore, if it will fit in =your 20 minute window.
To avoid problems of user mismatches make all the guids for the logins =the same on both systems - sp_grantlogin or ap-addlogin (can't remember =which) allowyou to force the internal id to ensure your second machine =is same as first.
dbo should always be a valid db user - can be fixed by =sp_changeuserslogin, this happens if the internal login ids are out of sync.
As an alternative to backup restore you could detach sp_detachdb, copy =the f iles and then sp_attachdb, but personally I always prefer the =backup./restore route.
Good Luck
Mike John
"AFN" <DELETEnewsgroupCAPSaccount@.yahoo.com> wrote in message =news:%vjLb.46123$C87.11549@.twister.socal.rr.com...
> I have a 24/7 live Sql Server 7 database. The server hardware is =old. I
> have a new computer for this Sql Server, and I will also be switching =to SQL
> Server 2000. What's the best way to transition from one to the =other? I
> can install everything on the 2nd server, and start using a different =server
> name, and I can tolerate 20 minutes of downtime when I finally switch =from
> one machine to the other. But I don't know the best way to get the
> database from one machine to the new machine, in a fast way. Other =times
> I've moved databases, I've found problems with the user records not =matching
> to the same user IDs in the Master System tables. And stored =procedures
> that have "dbo" owners suddenly freak out because that dbo isn't a =valid
> user ID anymore, etc.
> >|||You could use the Database Copy/Move wizard. It will detach the database
from SQL7, copy it to the destination server, re-attached the database on
the new machine and resolve all the logins. It's pretty slick.
Jim
"AFN" <DELETEnewsgroupCAPSaccount@.yahoo.com> wrote in message
news:%vjLb.46123$C87.11549@.twister.socal.rr.com...
> I have a 24/7 live Sql Server 7 database. The server hardware is old.
I
> have a new computer for this Sql Server, and I will also be switching to
SQL
> Server 2000. What's the best way to transition from one to the other?
I
> can install everything on the 2nd server, and start using a different
server
> name, and I can tolerate 20 minutes of downtime when I finally switch from
> one machine to the other. But I don't know the best way to get the
> database from one machine to the new machine, in a fast way. Other times
> I've moved databases, I've found problems with the user records not
matching
> to the same user IDs in the Master System tables. And stored procedures
> that have "dbo" owners suddenly freak out because that dbo isn't a valid
> user ID anymore, etc.
>|||Hi,
Try sp_help_revlogin to migrate the logins. This article has the details.
http://support.microsoft.com/default.aspx?kbid=246133
Backup and restore like you do for a standby server and with minimum
downtime can commission the new server of.
Sankar Renganathan DBA
SPAR Group Inc.,
sankariahr@.hotmail.com
1-248-568-7164
"Mike John" <Mike.John@.knowledgepool.spamtrap.com> wrote in message
news:e%23fRUti1DHA.2324@.TK2MSFTNGP09.phx.gbl...
Safest way of copying the data is backup and restore, if it will fit in your
20 minute window.
To avoid problems of user mismatches make all the guids for the logins the
same on both systems - sp_grantlogin or ap-addlogin (can't remember which)
allowyou to force the internal id to ensure your second machine is same as
first.
dbo should always be a valid db user - can be fixed by sp_changeuserslogin,
this happens if the internal login ids are out of
sync.
As an alternative to backup restore you could detach sp_detachdb, copy the f
iles and then sp_attachdb, but personally I always prefer the
backup./restore route.
Good Luck
Mike John
"AFN" <DELETEnewsgroupCAPSaccount@.yahoo.com> wrote in message
news:%vjLb.46123$C87.11549@.twister.socal.rr.com...
> I have a 24/7 live Sql Server 7 database. The server hardware is old.
I
> have a new computer for this Sql Server, and I will also be switching to
SQL
> Server 2000. What's the best way to transition from one to the other?
I
> can install everything on the 2nd server, and start using a different
server
> name, and I can tolerate 20 minutes of downtime when I finally switch from
> one machine to the other. But I don't know the best way to get the
> database from one machine to the new machine, in a fast way. Other times
> I've moved databases, I've found problems with the user records not
matching
> to the same user IDs in the Master System tables. And stored procedures
> that have "dbo" owners suddenly freak out because that dbo isn't a valid
> user ID anymore, etc.
>|||If you can copy the files within the window I like copy wizard or
attach/detach.
If the files are TOO big then backup the orig, restore it on the new..
(Users are still working on the orig.)
When the restore is complete, kick users OFF of orig.. Backup log on orig,
restore on new, and you should be good to go. (with the exception of
matching up logins, which can be done while users are still using the orig
database.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"AFN" <DELETEnewsgroupCAPSaccount@.yahoo.com> wrote in message
news:%vjLb.46123$C87.11549@.twister.socal.rr.com...
> I have a 24/7 live Sql Server 7 database. The server hardware is old.
I
> have a new computer for this Sql Server, and I will also be switching to
SQL
> Server 2000. What's the best way to transition from one to the other?
I
> can install everything on the 2nd server, and start using a different
server
> name, and I can tolerate 20 minutes of downtime when I finally switch from
> one machine to the other. But I don't know the best way to get the
> database from one machine to the new machine, in a fast way. Other times
> I've moved databases, I've found problems with the user records not
matching
> to the same user IDs in the Master System tables. And stored procedures
> that have "dbo" owners suddenly freak out because that dbo isn't a valid
> user ID anymore, etc.
>