Migration SQL 2000/2005 vers 2008
Bonjour,
Je migre deux bases
1) la base M, version 2005 (64bits)
2) la base C, version 2000 (32bits)
Ces deux bases sont migrées vers un serveur MS-SQL2008 R2 64 bits
Les dbcc checkcatalog, checkdb, checkalloc n'ont révélés aucune erreur sur les bases sources.
Via une restauration:
Code:
1
2
3
4
5
| RESTORE DATABASE [M] FROM DISK = N'd:\Microsoft SQL Server\Backup\m_2005.bak' WITH FILE = 1,
MOVE N'm' TO N'd:\Microsoft SQL Server\Data\M2.mdf',
MOVE N'm_log' TO N'd:\Microsoft SQL Server\log\M2_log.ldf',
NOUNLOAD, REPLACE, STATS = 10
GO |
Citation:
Msg 3183, Level 16, State 2, Line 1
RESTORE detected an error on page (0:117575457) in database "M" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Et pour la seconde
Citation:
Msg 3183, Level 16, State 2, Line 1
RESTORE detected an error on page (0:0) in database "C" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Ce qui tend à prouver que la base est corrompue.... hors il n'en est rien si l'on se fie au dbcc effectués
Via un detach/attach:
Code:
1
2
3
4
5
6
7
8
|
USE [master]
GO
CREATE DATABASE [m] ON
( FILENAME = N'D:\Microsoft SQL Server\Data\m.mdf' ),
( FILENAME = N'D:\Microsoft SQL Server\log\m_log.ldf' )
FOR ATTACH
GO |
Citation:
Msg 5172, Level 16, State 15, Line 1
The header for file 'D:\Microsoft SQL Server\Data\m.mdf' is not a valid database file header. The FILE SIZE property is incorrect.
Même comportement sur les deux bases, venant de 2 serveurs différents, de 2 versions différentes...
Une idée ? Une piste ?
