Old Server is a Windows Server 2003 system, using SQL Server 2000 database,
Due to ageing replaced the new Server hardware, system is Windows Server 2008 R2, installation and SQL Server 2000 database,

Replacement after the backup data is particularly slow, old server backup data of 25 seconds to complete, but the new server backup need 27 minutes, in the data back to the server backup is 25 seconds, reinstall the database also still won't do,
Backup check the CPU and memory are not run full


Have a similar problem?

CodePudding user response:

Database from the old server copied and then attach on? Can have a try on the new server to rebuild a new library, the original data in the database into the new library,

CodePudding user response:

reference 1st floor belsai response:

database from the old server copied and then attach on? Can have a try on the new server to rebuild a new library, the original data in the database into the new library,

When the database from the old server to do the data backup, and then the new library after the reduction of new server database, you said the original database to import the new library is to restore the backup? Or with all the tasks of export import data?

CodePudding user response:

With all the tasks of export import data

CodePudding user response:

reference belsai reply: 3/f

with all the tasks of export import data

Detection rate of the disk, I found the disk highest rate to 29.2 MB/SEC

CodePudding user response:

Raid do right, generally do raid10 database server