米田です。
続いて、SQL Server 2000でBackup、SQL Server 2005 Express で Restore を試行しました。
身近にあるということで、Northwind を例にとります。
とりあえず問題なく復元できたようです。
RESTORE DATABASE Northwind
FROM DISK = 'c:\north2000.dbk'
WITH MOVE 'Northwind' TO 'c:\data\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\data\testdb.ldf'
実行結果は
Processed 384 pages for database 'Northwind', file 'Northwind' on file 1.
Processed 1 pages for database 'Northwind', file 'Northwind_log' on file 1.
Converting database 'Northwind' from version 539 to the current version 587.
Database 'Northwind' running the upgrade step from version 539 to version 551.
Database 'Northwind' running the upgrade step from version 551 to version 552.
Database 'Northwind' running the upgrade step from version 552 to version 553.
Database 'Northwind' running the upgrade step from version 553 to version 554.
Database 'Northwind' running the upgrade step from version 554 to version 586.
Database 'Northwind' running the upgrade step from version 586 to version 587.
RESTORE DATABASE successfully processed 385 pages in 2.229 seconds (1.412 MB/sec).
うまくいったようです。
この時、errorlog は次のイメージ
2004-07-05 21:52:28.45 Logon Login succeeded for user 'TESTSV\TESTUSER'. Connection: trusted. [CLIENT: <local machine>]
2004-07-05 21:53:18.20 spid51 Starting up database 'Northwind'.
2004-07-05 21:53:18.27 spid51 The database 'Northwind' is marked RESTORING and is in a state that does not allow recovery to be run.
2004-07-05 21:53:18.84 spid51 Starting up database 'Northwind'.
2004-07-05 21:53:19.17 spid51 Recovery is writing a checkpoint in database 'Northwind' (5). This is an informational message only. No user action is required.
2004-07-05 21:53:40.67 spid51 Using 'xpstar90.dll' version '2000.90.836' to execute extended stored procedure 'xp_instance_regread'.
2004-07-05 21:53:45.12 Backup Database was restored: Database: Northwind, creation date(time): 2000/08/06(01:41:00), first LSN: 23:225:1, last LSN: 23:229:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'c:\north2000.dbk'}). Informational message. No user action required.
せっかくなので、トレースの対応部分も
2004-07-05 21:52:28.45 Logon Login succeeded for user 'TESTSV\TESTUSER'. Connection: trusted. [CLIENT: <local machine>]
1 TESTUSER TESTSV TESTSV 1972 SQL クエリ アナライザ - オブジェクト ブラウザ TESTSV\TESTUSER 53 2004-07-05 21:52:28.453 10 TESTSV 22 18453 master
RESTORE DATABASE Northwind
FROM DISK = 'c:\north2000.dbk'
WITH MOVE 'Northwind' TO 'c:\data\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\data\testdb.ldf'
TESTUSER TESTSV TESTSV 1972 SQL クエリ アナライザ TESTSV\TESTUSER 51 2004-07-05 21:53:14.190 2 1 TESTSV 115 Northwind
2004-07-05 21:53:18.20 spid51 Starting up database 'Northwind'.
2 TESTUSER TESTSV TESTSV 1972 SQL クエリ アナライザ TESTSV\TESTUSER 51 2004-07-05 21:53:18.203 10 TESTSV 22 17137 tempdb
2004-07-05 21:53:18.27 spid51 The database 'Northwind' is marked RESTORING and is in a state that does not allow recovery to be run.
2 TESTUSER TESTSV TESTSV 1972 SQL クエリ アナライザ TESTSV\TESTUSER 51 2004-07-05 21:53:18.273 10 TESTSV 22 3402 tempdb
2004-07-05 21:53:18.84 spid51 Starting up database 'Northwind'.
2 TESTUSER TESTSV TESTSV 1972 SQL クエリ アナライザ sa 51 2004-07-05 21:53:18.847 10 TESTSV 22 17137 tempdb 01 0 58
2004-07-05 21:53:19.17 spid51 Recovery is writing a checkpoint in database 'Northwind' (5). This is an informational message only. No user action is required.
(一部修正済)