|
Home > Archive > MS SQL Server > October 2006 > SQL Server 2000 databases transfrmation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server 2000 databases transfrmation
|
|
| Maikal 2006-10-24, 6:30 pm |
| Hello
We have one SQL data base server, on Windows Server 2000 5.00.2195 Serveice
Pack 4 Build 2195 and
Result of SQL server for
select @@version
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.0 (Build 2195: Service Pack 4)
and i want to transfer my all data bases from this server to new VMWare
environment. I have been installed new Windows Server 2003 Std Ed with SP 1
and SQL server 2000 with SP 4.
Result of new SQL server for
select @@version
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 1)
I need your tips and help that what is best way to transfer all databases
from old to new SQL server? All databases we are using for Axapta 2.5, or
Axapta 3.0.
--
Maikal
| |
| Tracy McKibben 2006-10-24, 6:30 pm |
| Maikal wrote:
> Hello
> We have one SQL data base server, on Windows Server 2000 5.00.2195 Serveice
> Pack 4 Build 2195 and
> Result of SQL server for
> select @@version
>
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> 5.0 (Build 2195: Service Pack 4)
>
> and i want to transfer my all data bases from this server to new VMWare
> environment. I have been installed new Windows Server 2003 Std Ed with SP 1
> and SQL server 2000 with SP 4.
>
> Result of new SQL server for
> select @@version
>
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
> 5.2 (Build 3790: Service Pack 1)
>
> I need your tips and help that what is best way to transfer all databases
> from old to new SQL server? All databases we are using for Axapta 2.5, or
> Axapta 3.0.
>
Backup the databases on the original server, then restore those backups
on the new server. Be sure to also read this KB article:
http://support.microsoft.com/kb/246133/
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
|
| Thanks for answer. Will i make backup for all 153 databases or is there any
script to use to make back for all databases and restore it on the new
servercancer
--
Maikal Toni
"Tracy McKibben" wrote:
> Maikal wrote:
>
> Backup the databases on the original server, then restore those backups
> on the new server. Be sure to also read this KB article:
> http://support.microsoft.com/kb/246133/
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
|
|
|
|
|