Hi,

i have a problem to migrate sql server 2000 db to sql server 2008 r2.

I run a checkdb on db in sql 2000 and it's ok

I have restored the bak sql 2000 on other sql 2000 and it's work correctly.

I try to restore a bak on the sql 2008 R2 but failed (below you'll find the log)

I also try to attach the mdf on to sql 2008 R2 but even this doesn't work (below you'll find the log).

log restore:

===================================
Restore failed for Server '3CFC3223643741C\SQL08'.  (Microsoft.SqlServer.SmoExtended)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
Program Location:
   at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
   at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseOptions.RunRestore()
===================================
System.Data.SqlClient.SqlError: RESTORE could not start database 'DBNAME'. (Microsoft.SqlServer.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&LinkId=20476
------------------------------
Program Location:
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
   at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
   at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)

log attach:

===================================
Attach database failed for Server '3CFC3223643741C\SQL08'.  (Microsoft.SqlServer.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
Program Location:
   at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)
   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.Attach()
   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SendDataToServer()
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Program Location:
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
   at Microsoft.SqlServer.Management.Smo.Server.AttachDatabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)
   at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)
===================================
Database 'DBNAME' already exists. Choose a different database name. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000&EvtSrc=MSSQLServer&EvtID=1801&LinkId=20476
------------------------------
Server Name: 3CFC3223643741C\SQL08
Error Number: 1801
Severity: 16
State: 3
Line Number: 1
------------------------------
Program Location:
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

how to resolve this problem?

Regards

Database 'DBNAME' already exists. Choose a different database name. (.Net SqlClient Data Provider) ------------------------------

Hello Giorgio,

What about that message in the attach part, does a database with the same name already exists?

Hi,

the database (and the database name) doesn't exists.

This message go out to try the attach the db

Hi,

the database (and the database name) doesn't exists.

This message go out to try the attach the db

As the error suggests instead of giving the name which ur giving..please try some different name coz..name which ur giving ,database of that name already exists.

Try giving a diff name and see whether ur successful or not..

Hi,

the database (and the database name) doesn't exists.

This message go out to try the attach the db

As the error suggests instead of giving the name which ur giving..please try some different name coz..name which ur giving ,database of that name already exists.

Try giving a diff name and see whether ur successful or

Ok ,

Create a Database on SQL server 2008 Instance and give it some name Like TESTRESTORE  then try to restore it with the backup you just moved there .

Tell me whether ur able to do it?..this will let u restore ...post error if any?

Ok ,

Create a Database on SQL server 2008 Instance and give it some name Like TESTRESTORE  then try to restore it with the backup you just moved there .

Tell me whether ur able to do it?..this will let u restore ...post error i

Please attache the log this is not complete one ..there is no cause for error mentioned in above post..Also are you restoring database from SQL server or from any application?

Run this on SQL server 2008 in query windows select @@version and paste result

Do you have full rights on system to restore database please check that.Also please give me detail of query you are runnig to restore the DB.

Reply to all the above queries

The result of select @@version in the destination istance is

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (Intel X86)   Jun 28 2012 08:42:37   Copyright (c) Microsoft Corporation  Enterprise on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

The source is

Microsoft SQL Server  2000 - 8.00.2282 (Intel X86)   May  3 2005 23:18:38   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

I'm logged in to machine like administrator

For restore the db i use the wizard procedure of sql server 2008 (right click on db --> tasks --> restore --> database)

below the complete log

Date,Source,Severity,Message
07/17/2013 08:23:45,spid54,Unknown,During upgrade<c/> database raised exception 2905<c/> severity 25<c/> state 1<c/> address 01758242. Use the exception number to determine the cause.
07/17/2013 08:23:45,spid54,Unknown,Error: 928<c/> Severity: 20<c/> State: 1.
07/17/2013 08:23:45,spid54,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
07/17/2013 08:23:44,spid54,Unknown,Stack Signature for the dump is 0x0292FACC
07/17/2013 08:23:44,spid54,Unknown,78132A47 Module(MSVCR80+00002A47)
07/17/2013 08:23:44,spid54,Unknown,781329BB Module(MSVCR80+000029BB)
07/17/2013 08:23:44,spid54,Unknown,01124B26 Module(sqlservr+00124B26)
07/17/2013 08:23:44,spid54,Unknown,01122EB8 Module(sqlservr+00122EB8)
07/17/2013 08:23:44,spid54,Unknown,01123403 Module(sqlservr+00123403)
07/17/2013 08:23:44,spid54,Unknown,01123518 Module(sqlservr+00123518)
07/17/2013 08:23:44,spid54,Unknown,015D3162 Module(sqlservr+005D3162)
07/17/2013 08:23:44,spid54,Unknown,015D331A Module(sqlservr+005D331A)
07/17/2013 08:23:44,spid54,Unknown,015D352F Module(sqlservr+005D352F)
07/17/2013 08:23:44,spid54,Unknown,01589393 Module(sqlservr+00589393)
07/17/2013 08:23:44,spid54,Unknown,0158950A Module(sqlservr+0058950A)
07/17/2013 08:23:44,spid54,Unknown,0158775B Module(sqlservr+0058775B)
07/17/2013 08:23:44,spid54,Unknown,0158AD21 Module(sqlservr+0058AD21)
07/17/2013 08:23:44,spid54,Unknown,01586BFE Module(sqlservr+00586BFE)
07/17/2013 08:23:44,spid54,Unknown,012E4BAC Module(sqlservr+002E4BAC)
07/17/2013 08:23:44,spid54,Unknown,01FEB7AB Module(sqlservr+00FEB7AB)
07/17/2013 08:23:44,spid54,Unknown,028A7833 Module(sqlservr+018A7833)
07/17/2013 08:23:44,spid54,Unknown,0291B433 Module(sqlservr+0191B433)
07/17/2013 08:23:44,spid54,Unknown,02926C41 Module(sqlservr+01926C41)
07/17/2013 08:23:44,spid54,Unknown,02927225 Module(sqlservr+01927225)
07/17/2013 08:23:44,spid54,Unknown,028E9C71 Module(sqlservr+018E9C71)
07/17/2013 08:23:44,spid54,Unknown,025F43A7 Module(sqlservr+015F43A7)
07/17/2013 08:23:44,spid54,Unknown,02609D7F Module(sqlservr+01609D7F)
07/17/2013 08:23:44,spid54,Unknown,0260B528 Module(sqlservr+0160B528)
07/17/2013 08:23:44,spid54,Unknown,027133A9 Module(sqlservr+017133A9)
07/17/2013 08:23:44,spid54,Unknown,02714DC5 Module(sqlservr+01714DC5)
07/17/2013 08:23:44,spid54,Unknown,01C6A3E8 Module(sqlservr+00C6A3E8)
07/17/2013 08:23:44,spid54,Unknown,01C6A76A Module(sqlservr+00C6A76A)
07/17/2013 08:23:44,spid54,Unknown,011F4192 Module(sqlservr+001F4192)
07/17/2013 08:23:44,spid54,Unknown,011F40DA Module(sqlservr+001F40DA)
07/17/2013 08:23:44,spid54,Unknown,011F445C Module(sqlservr+001F445C)
07/17/2013 08:23:44,spid54,Unknown,011ED49C Module(sqlservr+001ED49C)
07/17/2013 08:23:44,spid54,Unknown,011ED796 Module(sqlservr+001ED796)
07/17/2013 08:23:44,spid54,Unknown,011F0B9E Module(sqlservr+001F0B9E)
07/17/2013 08:23:44,spid54,Unknown,* Short Stack Dump
07/17/2013 08:23:44,spid54,Unknown,* -------------------------------------------------------------------------------
07/17/2013 08:23:44,spid54,Unknown,* *******************************************************************************
07/17/2013 08:23:44,spid54,Unknown,*      SegSs: 00000023:
07/17/2013 08:23:44,spid54,Unknown,*        Esp: 6593C750:  01026276  21779CA6  6593CED0  0A75CD58  00000000  0AF31800
07/17/2013 08:23:44,spid54,Unknown,*     EFlags: 00010246:  0072006F  00200074  006F0054  006C006F  005C0073  0043003B
07/17/2013 08:23:44,spid54,Unknown,*      SegCs: 0000001B:
07/17/2013 08:23:44,spid54,Unknown,*        Ebp: 6593CAA4:  6593CB68  011ED796  0C14A0B8  0A75CD58  0C14A2A8  00000000
07/17/2013 08:23:44,spid54,Unknown,*        Eip: 011F0B9E:  108B068B  D2FFCE8B  8B084789  04508B06  D2FFCE8B  8B0C4789
07/17/2013 08:23:44,spid54,Unknown,*        Edx: 0149EED8:  013BBAE7  013F90C2  013A04BB  014DDB4D  01BB5BE3  01409D3E
07/17/2013 08:23:44,spid54,Unknown,*        Ecx: 2177913E:
07/17/2013 08:23:44,spid54,Unknown,*        Ebx: 0C14A0B8:  014D4D88  00000000  00000001  47F80100  3E9D2825  00000001
07/17/2013 08:23:44,spid54,Unknown,*        Eax: 00000000:
07/17/2013 08:23:44,spid54,Unknown,*        Esi: 00000000:
07/17/2013 08:23:44,spid54,Unknown,*        Edi: 0C14B620:  35333334  00210030  32313032  39323131  0100006F  0000C350
07/17/2013 08:23:44,spid54,Unknown,*
07/17/2013 08:23:44,spid54,Unknown,* dbghelp                        65C50000  65D64FFF  00115000
07/17/2013 08:23:44,spid54,Unknown,* xpsqlbot                       006D0000  006D6FFF  00007000
07/17/2013 08:23:44,spid54,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
07/17/2013 08:23:44,spid54,Unknown,* winrnr                         76F70000  76F76FFF  00007000
07/17/2013 08:23:44,spid54,Unknown,* xplog70                        631F0000  631F1FFF  00002000
07/17/2013 08:23:44,spid54,Unknown,* xplog70                        631D0000  631DBFFF  0000c000
07/17/2013 08:23:44,spid54,Unknown,* xpstar                         62DB0000  62DD4FFF  00025000
07/17/2013 08:23:44,spid54,Unknown,* resutils                       62D90000  62DA2FFF  00013000
07/17/2013 08:23:44,spid54,Unknown,* clusapi                        62D70000  62D81FFF  00012000
07/17/2013 08:23:44,spid54,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
07/17/2013 08:23:44,spid54,Unknown,* SQLSCM                         62D50000  62D59FFF  0000a000
07/17/2013 08:23:44,spid54,Unknown,* xpstar                         62CF0000  62D3BFFF  0004c000
07/17/2013 08:23:44,spid54,Unknown,* SQLNCLIR10                     62C30000  62C66FFF  00037000
07/17/2013 08:23:44,spid54,Unknown,* sqlncli10                      629A0000  62C19FFF  0027a000
07/17/2013 08:23:44,spid54,Unknown,* COMRes                         77010000  770D5FFF  000c6000
07/17/2013 08:23:44,spid54,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
07/17/2013 08:23:44,spid54,Unknown,* xpsp2res                       626B0000  62974FFF  002c5000
07/17/2013 08:23:44,spid54,Unknown,* DNSAPI                         76ED0000  76EF9FFF  0002a000
07/17/2013 08:23:44,spid54,Unknown,* ntdsapi                        766F0000  76703FFF  00014000
07/17/2013 08:23:44,spid54,Unknown,* wshtcpip                       71AE0000  71AE7FFF  00008000
07/17/2013 08:23:44,spid54,Unknown,* wshqos                         62260000  62269FFF  0000a000
07/17/2013 08:23:44,spid54,Unknown,* hnetcfg                        62200000  62259FFF  0005a000
07/17/2013 08:23:44,spid54,Unknown,* mswsock                        71B20000  71B60FFF  00041000
07/17/2013 08:23:44,spid54,Unknown,* imagehlp                       76C10000  76C37FFF  00028000
07/17/2013 08:23:44,spid54,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
07/17/2013 08:23:44,spid54,Unknown,* dbghelp                        61DF0000  61F04FFF  00115000
07/17/2013 08:23:44,spid54,Unknown,* MSFTE                          61B90000  61DE8FFF  00259000
07/17/2013 08:23:44,spid54,Unknown,* ftimport                       61B70000  61B8CFFF  0001d000
07/17/2013 08:23:44,spid54,Unknown,* SAMLIB                         61B40000  61B4EFFF  0000f000
07/17/2013 08:23:44,spid54,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
07/17/2013 08:23:44,spid54,Unknown,* NTMARTA                        77E00000  77E20FFF  00021000
07/17/2013 08:23:44,spid54,Unknown,* dssenh                         68100000  68126FFF  00027000
07/17/2013 08:23:44,spid54,Unknown,* security                       71F60000  71F63FFF  00004000
07/17/2013 08:23:44,spid54,Unknown,* schannel                       76750000  76776FFF  00027000
07/17/2013 08:23:44,spid54,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
07/17/2013 08:23:44,spid54,Unknown,* kerberos                       71CA0000  71CF7FFF  00058000
07/17/2013 08:23:44,spid54,Unknown,* msv1_0                         76C90000  76CB6FFF  00027000
07/17/2013 08:23:44,spid54,Unknown,* MSCOREE                        34040000  34085FFF  00046000
07/17/2013 08:23:44,spid54,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
07/17/2013 08:23:44,spid54,Unknown,* rsaenh                         68000000  68034FFF  00035000
07/17/2013 08:23:44,spid54,Unknown,* sqlevn70                       4F610000  4F813FFF  00204000
07/17/2013 08:23:44,spid54,Unknown,* instapi10                      009D0000  009D9FFF  0000a000
07/17/2013 08:23:44,spid54,Unknown,* odbcint                        00840000  00856FFF  00017000
07/17/2013 08:23:44,spid54,Unknown,* comctl32                       77420000  77522FFF  00103000
07/17/2013 08:23:44,spid54,Unknown,* IMM32                          76290000  762ACFFF  0001d000
07/17/2013 08:23:44,spid54,Unknown,* BatchParser                    520C0000  520E0FFF  00021000
07/17/2013 08:23:44,spid54,Unknown,* NETAPI32                       71C40000  71C96FFF  00057000
07/17/2013 08:23:44,spid54,Unknown,* opends60                       333E0000  333E6FFF  00007000
07/17/2013 08:23:44,spid54,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
07/17/2013 08:23:44,spid54,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
07/17/2013 08:23:44,spid54,Unknown,* PSAPI                          76B70000  76B7AFFF  0000b000
07/17/2013 08:23:44,spid54,Unknown,* IPHLPAPI                       76CF0000  76D09FFF  0001a000
07/17/2013 08:23:44,spid54,Unknown,* WINMM                          76AA0000  76ACCFFF  0002d000
07/17/2013 08:23:44,spid54,Unknown,* USERENV                        76920000  769E1FFF  000c2000
07/17/2013 08:23:44,spid54,Unknown,* MSASN1                         76190000  761A1FFF  00012000
07/17/2013 08:23:44,spid54,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
07/17/2013 08:23:44,spid54,Unknown,* VERSION                        77B90000  77B97FFF  00008000
07/17/2013 08:23:44,spid54,Unknown,* odbcbcp                        60950000  60955FFF  00006000
07/17/2013 08:23:44,spid54,Unknown,* ODBC32                         48890000  488CCFFF  0003d000
07/17/2013 08:23:44,spid54,Unknown,* OLEAUT32                       77D00000  77D8AFFF  0008b000
07/17/2013 08:23:44,spid54,Unknown,* ole32                          77670000  777A8FFF  00139000
07/17/2013 08:23:44,spid54,Unknown,* SHELL32                        7C8D0000  7D0CDFFF  007fe000
07/17/2013 08:23:44,spid54,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
07/17/2013 08:23:44,spid54,Unknown,* comdlg32                       762B0000  762F8FFF  00049000
07/17/2013 08:23:44,spid54,Unknown,* USER32                         77380000  77410FFF  00091000
07/17/2013 08:23:44,spid54,Unknown,* GDI32                          77C00000  77C47FFF  00048000
07/17/2013 08:23:44,spid54,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
07/17/2013 08:23:44,spid54,Unknown,* pdh                            72590000  725DBFFF  0004c000
07/17/2013 08:23:44,spid54,Unknown,* sqlos                          344D0000  344D5FFF  00006000
07/17/2013 08:23:44,spid54,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
07/17/2013 08:23:44,spid54,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
07/17/2013 08:23:44,spid54,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
07/17/2013 08:23:44,spid54,Unknown,* Secur32                        76F50000  76F62FFF  00013000
07/17/2013 08:23:44,spid54,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
07/17/2013 08:23:44,spid54,Unknown,* ADVAPI32                       77F50000  77FEAFFF  0009b000
07/17/2013 08:23:44,spid54,Unknown,* kernel32                       77E40000  77F41FFF  00102000
07/17/2013 08:23:44,spid54,Unknown,* ntdll                          7C800000  7C8BFFFF  000c0000
07/17/2013 08:23:44,spid54,Unknown,* sqlservr                       01000000  039B0FFF  029b1000
07/17/2013 08:23:44,spid54,Unknown,*  MODULE                          BASE      END       SIZE
07/17/2013 08:23:44,spid54,Unknown,*
07/17/2013 08:23:44,spid54,Unknown,*
07/17/2013 08:23:44,spid54,Unknown,*  50.SQL08\MSSQL\DATA\TESTRESTORE.LDF'<c/>  NOUNLOAD<c/>  REPLACE<c/>  STATS = 10
07/17/2013 08:23:44,spid54,Unknown,*  SQL\DATA\TESTRESTORE.mdf'<c/>  MOVE N'DBNAMELOG' TO N'D:\sql\2008\MSSQL10_
07/17/2013 08:23:44,spid54,Unknown,*  k' WITH  FILE = 1<c/>  MOVE N'DBNAME' TO N'D:\sql\2008\MSSQL10_50.SQL08\MS
07/17/2013 08:23:44,spid54,Unknown,*             RESTORE DATABASE [TESTRESTORE] FROM  DISK = N'D:\backupnew.ba
07/17/2013 08:23:44,spid54,Unknown,* Input Buffer 510 bytes -
07/17/2013 08:23:44,spid54,Unknown,*   Access Violation occurred reading address 00000000
07/17/2013 08:23:44,spid54,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
07/17/2013 08:23:44,spid54,Unknown,*   Exception Address = 011F0B9E Module(sqlservr+001F0B9E)
07/17/2013 08:23:44,spid54,Unknown,*
07/17/2013 08:23:44,spid54,Unknown,*
07/17/2013 08:23:44,spid54,Unknown,*   07/17/13 08:23:44 spid 54
07/17/2013 08:23:44,spid54,Unknown,* BEGIN STACK DUMP:
07/17/2013 08:23:44,spid54,Unknown,*
07/17/2013 08:23:44,spid54,Unknown,* *******************************************************************************
07/17/2013 08:23:44,spid54,Unknown,SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
07/17/2013 08:23:44,spid54,Unknown,***Stack Dump being sent to D:\sql\2008\MSSQL10_50.SQL08\MSSQL\LOG\SQLDump0017.txt
07/17/2013 08:23:44,spid54,Unknown,Using 'dbghelp.dll' version '4.0.5'
07/17/2013 08:23:30,spid54,Unknown,Recovery is writing a checkpoint in database 'TESTRESTORE' (5). This is an informational message only. No user action is required.
07/17/2013 08:23:30,spid54,Unknown,Starting up database 'TESTRESTORE'.
07/17/2013 08:23:29,spid54,Unknown,The database 'TESTRESTORE' is marked RESTORING and is in a state that does not allow recovery to be run.
07/17/2013 08:23:29,spid54,Unknown,Starting up database 'TESTRESTORE'.
07/17/2013 08:12:35,spid54,Unknown,During upgrade<c/> database raised exception 2905<c/> severity 25<c/> state 1<c/> address 01EB5C9C. Use the exception number to determine the cause.
07/17/2013 08:12:35,spid54,Unknown,Error: 928<c/> Severity: 20<c/> State: 1.
07/17/2013 08:12:35,spid54,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
07/17/2013 08:12:34,spid54,Unknown,Stack Signature for the dump is 0x0292FACC
07/17/2013 08:12:34,spid54,Unknown,78132A47 Module(MSVCR80+00002A47)
07/17/2013 08:12:34,spid54,Unknown,781329BB Module(MSVCR80+000029BB)
07/17/2013 08:12:34,spid54,Unknown,01124B26 Module(sqlservr+00124B26)
07/17/2013 08:12:34,spid54,Unknown,01122EB8 Module(sqlservr+00122EB8)
07/17/2013 08:12:34,spid54,Unknown,01123403 Module(sqlservr+00123403)
07/17/2013 08:12:34,spid54,Unknown,01123518 Module(sqlservr+00123518)
07/17/2013 08:12:34,spid54,Unknown,015D3162 Module(sqlservr+005D3162)
07/17/2013 08:12:34,spid54,Unknown,015D331A Module(sqlservr+005D331A)
07/17/2013 08:12:34,spid54,Unknown,015D352F Module(sqlservr+005D352F)
07/17/2013 08:12:34,spid54,Unknown,01589393 Module(sqlservr+00589393)
07/17/2013 08:12:34,spid54,Unknown,0158950A Module(sqlservr+0058950A)
07/17/2013 08:12:34,spid54,Unknown,0158775B Module(sqlservr+0058775B)
07/17/2013 08:12:34,spid54,Unknown,0158AD21 Module(sqlservr+0058AD21)
07/17/2013 08:12:34,spid54,Unknown,01586BFE Module(sqlservr+00586BFE)
07/17/2013 08:12:34,spid54,Unknown,012E4BAC Module(sqlservr+002E4BAC)
07/17/2013 08:12:34,spid54,Unknown,01FEB7AB Module(sqlservr+00FEB7AB)
07/17/2013 08:12:34,spid54,Unknown,028A7833 Module(sqlservr+018A7833)
07/17/2013 08:12:34,spid54,Unknown,0291B433 Module(sqlservr+0191B433)
07/17/2013 08:12:34,spid54,Unknown,02926C41 Module(sqlservr+01926C41)
07/17/2013 08:12:34,spid54,Unknown,02927225 Module(sqlservr+01927225)
07/17/2013 08:12:34,spid54,Unknown,028E9C71 Module(sqlservr+018E9C71)
07/17/2013 08:12:34,spid54,Unknown,025F43A7 Module(sqlservr+015F43A7)
07/17/2013 08:12:34,spid54,Unknown,02609D7F Module(sqlservr+01609D7F)
07/17/2013 08:12:34,spid54,Unknown,0260B528 Module(sqlservr+0160B528)
07/17/2013 08:12:34,spid54,Unknown,027133A9 Module(sqlservr+017133A9)
07/17/2013 08:12:34,spid54,Unknown,02714DC5 Module(sqlservr+01714DC5)
07/17/2013 08:12:34,spid54,Unknown,01C6A3E8 Module(sqlservr+00C6A3E8)
07/17/2013 08:12:34,spid54,Unknown,01C6A76A Module(sqlservr+00C6A76A)
07/17/2013 08:12:34,spid54,Unknown,011F4192 Module(sqlservr+001F4192)
07/17/2013 08:12:34,spid54,Unknown,011F40DA Module(sqlservr+001F40DA)
07/17/2013 08:12:34,spid54,Unknown,011F445C Module(sqlservr+001F445C)
07/17/2013 08:12:34,spid54,Unknown,011ED49C Module(sqlservr+001ED49C)
07/17/2013 08:12:34,spid54,Unknown,011ED796 Module(sqlservr+001ED796)
07/17/2013 08:12:34,spid54,Unknown,011F0B9E Module(sqlservr+001F0B9E)
07/17/2013 08:12:34,spid54,Unknown,* Short Stack Dump
07/17/2013 08:12:34,spid54,Unknown,* -------------------------------------------------------------------------------
07/17/2013 08:12:34,spid54,Unknown,* *******************************************************************************
07/17/2013 08:12:34,spid54,Unknown,*      SegSs: 00000023:
07/17/2013 08:12:34,spid54,Unknown,*        Esp: 6391C750:  01026276  27759CA6  6391CED0  0B6C4D58  00000000  0B1C1800
07/17/2013 08:12:34,spid54,Unknown,*     EFlags: 00010246:  0072006F  00200074  006F0054  006C006F  005C0073  0043003B
07/17/2013 08:12:34,spid54,Unknown,*      SegCs: 0000001B:
07/17/2013 08:12:34,spid54,Unknown,*        Ebp: 6391CAA4:  6391CB68  011ED796  16E280B8  0B6C4D58  16E282A8  00000000
07/17/2013 08:12:34,spid54,Unknown,*        Eip: 011F0B9E:  108B068B  D2FFCE8B  8B084789  04508B06  D2FFCE8B  8B0C4789
07/17/2013 08:12:34,spid54,Unknown,*        Edx: 0149EED8:  013BBAE7  013F90C2  013A04BB  014DDB4D  01BB5BE3  01409D3E
07/17/2013 08:12:34,spid54,Unknown,*        Ecx: 2775913E:
07/17/2013 08:12:34,spid54,Unknown,*        Ebx: 16E280B8:  014D4D88  00000000  00000001  00000000  3E9D2825  00000001
07/17/2013 08:12:34,spid54,Unknown,*        Eax: 00000000:
07/17/2013 08:12:34,spid54,Unknown,*        Esi: 00000000:
07/17/2013 08:12:34,spid54,Unknown,*        Edi: 16E29620:  00000000  00000000  00000000  00000000  00000000  00000000
07/17/2013 08:12:34,spid54,Unknown,*
07/17/2013 08:12:34,spid54,Unknown,* dbghelp                        65B50000  65C64FFF  00115000
07/17/2013 08:12:34,spid54,Unknown,* xpsqlbot                       006D0000  006D6FFF  00007000
07/17/2013 08:12:34,spid54,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
07/17/2013 08:12:34,spid54,Unknown,* winrnr                         76F70000  76F76FFF  00007000
07/17/2013 08:12:34,spid54,Unknown,* xplog70                        631F0000  631F1FFF  00002000
07/17/2013 08:12:34,spid54,Unknown,* xplog70                        631D0000  631DBFFF  0000c000
07/17/2013 08:12:34,spid54,Unknown,* xpstar                         62DB0000  62DD4FFF  00025000
07/17/2013 08:12:34,spid54,Unknown,* resutils                       62D90000  62DA2FFF  00013000
07/17/2013 08:12:34,spid54,Unknown,* clusapi                        62D70000  62D81FFF  00012000
07/17/2013 08:12:34,spid54,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
07/17/2013 08:12:34,spid54,Unknown,* SQLSCM                         62D50000  62D59FFF  0000a000
07/17/2013 08:12:34,spid54,Unknown,* xpstar                         62CF0000  62D3BFFF  0004c000
07/17/2013 08:12:34,spid54,Unknown,* SQLNCLIR10                     62C30000  62C66FFF  00037000
07/17/2013 08:12:34,spid54,Unknown,* sqlncli10                      629A0000  62C19FFF  0027a000
07/17/2013 08:12:34,spid54,Unknown,* COMRes                         77010000  770D5FFF  000c6000
07/17/2013 08:12:34,spid54,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
07/17/2013 08:12:34,spid54,Unknown,* xpsp2res                       626B0000  62974FFF  002c5000
07/17/2013 08:12:34,spid54,Unknown,* DNSAPI                         76ED0000  76EF9FFF  0002a000
07/17/2013 08:12:34,spid54,Unknown,* ntdsapi                        766F0000  76703FFF  00014000
07/17/2013 08:12:34,spid54,Unknown,* wshtcpip                       71AE0000  71AE7FFF  00008000
07/17/2013 08:12:34,spid54,Unknown,* wshqos                         62260000  62269FFF  0000a000
07/17/2013 08:12:34,spid54,Unknown,* hnetcfg                        62200000  62259FFF  0005a000
07/17/2013 08:12:34,spid54,Unknown,* mswsock                        71B20000  71B60FFF  00041000
07/17/2013 08:12:34,spid54,Unknown,* imagehlp                       76C10000  76C37FFF  00028000
07/17/2013 08:12:34,spid54,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
07/17/2013 08:12:34,spid54,Unknown,* dbghelp                        61DF0000  61F04FFF  00115000
07/17/2013 08:12:34,spid54,Unknown,* MSFTE                          61B90000  61DE8FFF  00259000
07/17/2013 08:12:34,spid54,Unknown,* ftimport                       61B70000  61B8CFFF  0001d000
07/17/2013 08:12:34,spid54,Unknown,* SAMLIB                         61B40000  61B4EFFF  0000f000
07/17/2013 08:12:34,spid54,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
07/17/2013 08:12:34,spid54,Unknown,* NTMARTA                        77E00000  77E20FFF  00021000
07/17/2013 08:12:34,spid54,Unknown,* dssenh                         68100000  68126FFF  00027000
07/17/2013 08:12:34,spid54,Unknown,* security                       71F60000  71F63FFF  00004000
07/17/2013 08:12:34,spid54,Unknown,* schannel                       76750000  76776FFF  00027000
07/17/2013 08:12:34,spid54,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
07/17/2013 08:12:34,spid54,Unknown,* kerberos                       71CA0000  71CF7FFF  00058000
07/17/2013 08:12:34,spid54,Unknown,* msv1_0                         76C90000  76CB6FFF  00027000
07/17/2013 08:12:34,spid54,Unknown,* MSCOREE                        34040000  34085FFF  00046000
07/17/2013 08:12:34,spid54,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
07/17/2013 08:12:34,spid54,Unknown,* rsaenh                         68000000  68034FFF  00035000
07/17/2013 08:12:34,spid54,Unknown,* sqlevn70                       4F610000  4F813FFF  00204000
07/17/2013 08:12:34,spid54,Unknown,* instapi10                      009D0000  009D9FFF  0000a000
07/17/2013 08:12:34,spid54,Unknown,* odbcint                        00840000  00856FFF  00017000
07/17/2013 08:12:34,spid54,Unknown,* comctl32                       77420000  77522FFF  00103000
07/17/2013 08:12:34,spid54,Unknown,* IMM32                          76290000  762ACFFF  0001d000
07/17/2013 08:12:34,spid54,Unknown,* BatchParser                    520C0000  520E0FFF  00021000
07/17/2013 08:12:34,spid54,Unknown,* NETAPI32                       71C40000  71C96FFF  00057000
07/17/2013 08:12:34,spid54,Unknown,* opends60                       333E0000  333E6FFF  00007000
07/17/2013 08:12:34,spid54,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
07/17/2013 08:12:34,spid54,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
07/17/2013 08:12:34,spid54,Unknown,* PSAPI                          76B70000  76B7AFFF  0000b000
07/17/2013 08:12:34,spid54,Unknown,* IPHLPAPI                       76CF0000  76D09FFF  0001a000
07/17/2013 08:12:34,spid54,Unknown,* WINMM                          76AA0000  76ACCFFF  0002d000
07/17/2013 08:12:34,spid54,Unknown,* USERENV                        76920000  769E1FFF  000c2000
07/17/2013 08:12:34,spid54,Unknown,* MSASN1                         76190000  761A1FFF  00012000
07/17/2013 08:12:34,spid54,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
07/17/2013 08:12:34,spid54,Unknown,* VERSION                        77B90000  77B97FFF  00008000
07/17/2013 08:12:34,spid54,Unknown,* odbcbcp                        60950000  60955FFF  00006000
07/17/2013 08:12:34,spid54,Unknown,* ODBC32                         48890000  488CCFFF  0003d000
07/17/2013 08:12:34,spid54,Unknown,* OLEAUT32                       77D00000  77D8AFFF  0008b000
07/17/2013 08:12:34,spid54,Unknown,* ole32                          77670000  777A8FFF  00139000
07/17/2013 08:12:34,spid54,Unknown,* SHELL32                        7C8D0000  7D0CDFFF  007fe000
07/17/2013 08:12:34,spid54,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
07/17/2013 08:12:34,spid54,Unknown,* comdlg32                       762B0000  762F8FFF  00049000
07/17/2013 08:12:34,spid54,Unknown,* USER32                         77380000  77410FFF  00091000
07/17/2013 08:12:34,spid54,Unknown,* GDI32                          77C00000  77C47FFF  00048000
07/17/2013 08:12:34,spid54,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
07/17/2013 08:12:34,spid54,Unknown,* pdh                            72590000  725DBFFF  0004c000
07/17/2013 08:12:34,spid54,Unknown,* sqlos                          344D0000  344D5FFF  00006000
07/17/2013 08:12:34,spid54,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
07/17/2013 08:12:34,spid54,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
07/17/2013 08:12:34,spid54,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
07/17/2013 08:12:34,spid54,Unknown,* Secur32                        76F50000  76F62FFF  00013000
07/17/2013 08:12:34,spid54,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
07/17/2013 08:12:34,spid54,Unknown,* ADVAPI32                       77F50000  77FEAFFF  0009b000
07/17/2013 08:12:34,spid54,Unknown,* kernel32                       77E40000  77F41FFF  00102000
07/17/2013 08:12:34,spid54,Unknown,* ntdll                          7C800000  7C8BFFFF  000c0000
07/17/2013 08:12:34,spid54,Unknown,* sqlservr                       01000000  039B0FFF  029b1000
07/17/2013 08:12:34,spid54,Unknown,*  MODULE                          BASE      END       SIZE
07/17/2013 08:12:34,spid54,Unknown,*
07/17/2013 08:12:34,spid54,Unknown,*
07/17/2013 08:12:34,spid54,Unknown,*  50.SQL08\MSSQL\DATA\TESTRESTORE.LDF'<c/>  NOUNLOAD<c/>  REPLACE<c/>  STATS = 10
07/17/2013 08:12:34,spid54,Unknown,*  SQL\DATA\TESTRESTORE.mdf'<c/>  MOVE N'DBNAMELOG' TO N'D:\sql\2008\MSSQL10_
07/17/2013 08:12:34,spid54,Unknown,*  k' WITH  FILE = 1<c/>  MOVE N'DBNAME' TO N'D:\sql\2008\MSSQL10_50.SQL08\MS
07/17/2013 08:12:34,spid54,Unknown,*             RESTORE DATABASE [TESTRESTORE] FROM  DISK = N'D:\backupnew.ba
07/17/2013 08:12:34,spid54,Unknown,* Input Buffer 510 bytes -
07/17/2013 08:12:34,spid54,Unknown,*   Access Violation occurred reading address 00000000
07/17/2013 08:12:34,spid54,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
07/17/2013 08:12:34,spid54,Unknown,*   Exception Address = 011F0B9E Module(sqlservr+001F0B9E)
07/17/2013 08:12:34,spid54,Unknown,*
07/17/2013 08:12:34,spid54,Unknown,*
07/17/2013 08:12:34,spid54,Unknown,*   07/17/13 08:12:34 spid 54
07/17/2013 08:12:34,spid54,Unknown,* BEGIN STACK DUMP:
07/17/2013 08:12:34,spid54,Unknown,*
07/17/2013 08:12:34,spid54,Unknown,* *******************************************************************************
07/17/2013 08:12:34,spid54,Unknown,SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
07/17/2013 08:12:34,spid54,Unknown,***Stack Dump being sent to D:\sql\2008\MSSQL10_50.SQL08\MSSQL\LOG\SQLDump0016.txt
07/17/2013 08:12:34,spid54,Unknown,Using 'dbghelp.dll' version '4.0.5'
07/17/2013 08:12:18,spid54,Unknown,Recovery is writing a checkpoint in database 'TESTRESTORE' (5). This is an informational message only. No user action is required.
07/17/2013 08:12:18,spid54,Unknown,Starting up database 'TESTRESTORE'.
07/17/2013 08:12:18,spid54,Unknown,The database 'TESTRESTORE' is marked RESTORING and is in a state that does not allow recovery to be run.
07/17/2013 08:12:18,spid54,Unknown,Starting up database 'TESTRESTORE'.

thank you

>>During upgrade<c/> database raised exception 2905<c/> severity 25<c/> state 1<c/> address 01758242. Use the exception number to determine the cause.

During  restore...did u selected buton  'Overite existing database' in restore option in Option section .

Also in log i found out..>>Access Violation occurred reading address 00000000

Can u check this link..I think you have upgraded your server from 2000 to 2008 please follow the link and remove this message and then proceed with restore.

Hi Giorgio,

can you restore your 2000 backup on to a SQL Server 2005 server and then take backup and restore it on to SQL Server 2008 ??

>>During upgrade<c/> database raised exception 2905<c/> severity 25<c/> state 1<c/> address 01758242. Use the exception number to determine the cause.

During  restore...did u selected buton  'Overite existing database' in restore option in Option section .

Also in log i found out..>>Access Violation occurred reading address 00000000

Can u check this link..I think you have upgraded your server from 2000 to 2008 please follow the link and remove this message and then proceed with restore.

Hi Giorgio,

can you restore your 2000 backup on to a SQL Server 2005 server and then take backup and restore it on to SQL Server 2008 ??

Hi srry this is the link

http://support.microsoft.com/kb/955831

I set the option "overwrite exsisting database"

I propagate the authorization on all file

I tried to restore but the problem persist (the new log below)

Date,Source,Severity,Message
07/17/2013 15:05:08,spid57,Unknown,During upgrade<c/> database raised exception 2905<c/> severity 25<c/> state 1<c/> address 01758242. Use the exception number to determine the cause.
07/17/2013 15:05:08,spid57,Unknown,Error: 928<c/> Severity: 20<c/> State: 1.
07/17/2013 15:05:08,spid57,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
07/17/2013 15:05:07,spid57,Unknown,Stack Signature for the dump is 0x0292FACC
07/17/2013 15:05:07,spid57,Unknown,78132A47 Module(MSVCR80+00002A47)
07/17/2013 15:05:07,spid57,Unknown,781329BB Module(MSVCR80+000029BB)
07/17/2013 15:05:07,spid57,Unknown,01124B26 Module(sqlservr+00124B26)
07/17/2013 15:05:07,spid57,Unknown,01122EB8 Module(sqlservr+00122EB8)
07/17/2013 15:05:07,spid57,Unknown,01123403 Module(sqlservr+00123403)
07/17/2013 15:05:07,spid57,Unknown,01123518 Module(sqlservr+00123518)
07/17/2013 15:05:07,spid57,Unknown,015D3162 Module(sqlservr+005D3162)
07/17/2013 15:05:07,spid57,Unknown,015D331A Module(sqlservr+005D331A)
07/17/2013 15:05:07,spid57,Unknown,015D352F Module(sqlservr+005D352F)
07/17/2013 15:05:07,spid57,Unknown,01589393 Module(sqlservr+00589393)
07/17/2013 15:05:07,spid57,Unknown,0158950A Module(sqlservr+0058950A)
07/17/2013 15:05:07,spid57,Unknown,0158775B Module(sqlservr+0058775B)
07/17/2013 15:05:07,spid57,Unknown,0158AD21 Module(sqlservr+0058AD21)
07/17/2013 15:05:07,spid57,Unknown,01586BFE Module(sqlservr+00586BFE)
07/17/2013 15:05:07,spid57,Unknown,012E4BAC Module(sqlservr+002E4BAC)
07/17/2013 15:05:07,spid57,Unknown,01FEB7AB Module(sqlservr+00FEB7AB)
07/17/2013 15:05:07,spid57,Unknown,028A7833 Module(sqlservr+018A7833)
07/17/2013 15:05:07,spid57,Unknown,0291B433 Module(sqlservr+0191B433)
07/17/2013 15:05:07,spid57,Unknown,02926C41 Module(sqlservr+01926C41)
07/17/2013 15:05:07,spid57,Unknown,02927225 Module(sqlservr+01927225)
07/17/2013 15:05:07,spid57,Unknown,028E9C71 Module(sqlservr+018E9C71)
07/17/2013 15:05:07,spid57,Unknown,025F43A7 Module(sqlservr+015F43A7)
07/17/2013 15:05:07,spid57,Unknown,02609D7F Module(sqlservr+01609D7F)
07/17/2013 15:05:07,spid57,Unknown,0260B528 Module(sqlservr+0160B528)
07/17/2013 15:05:07,spid57,Unknown,027133A9 Module(sqlservr+017133A9)
07/17/2013 15:05:07,spid57,Unknown,02714DC5 Module(sqlservr+01714DC5)
07/17/2013 15:05:07,spid57,Unknown,01C6A3E8 Module(sqlservr+00C6A3E8)
07/17/2013 15:05:07,spid57,Unknown,01C6A76A Module(sqlservr+00C6A76A)
07/17/2013 15:05:07,spid57,Unknown,011F4192 Module(sqlservr+001F4192)
07/17/2013 15:05:07,spid57,Unknown,011F40DA Module(sqlservr+001F40DA)
07/17/2013 15:05:07,spid57,Unknown,011F445C Module(sqlservr+001F445C)
07/17/2013 15:05:07,spid57,Unknown,011ED49C Module(sqlservr+001ED49C)
07/17/2013 15:05:07,spid57,Unknown,011ED796 Module(sqlservr+001ED796)
07/17/2013 15:05:07,spid57,Unknown,011F0B9E Module(sqlservr+001F0B9E)
07/17/2013 15:05:07,spid57,Unknown,* Short Stack Dump
07/17/2013 15:05:07,spid57,Unknown,* -------------------------------------------------------------------------------
07/17/2013 15:05:07,spid57,Unknown,* *******************************************************************************
07/17/2013 15:05:07,spid57,Unknown,*      SegSs: 00000023:
07/17/2013 15:05:07,spid57,Unknown,*        Esp: 6593C750:  01026276  21779CA6  6593CED0  09FECD58  00000000  123AF800
07/17/2013 15:05:07,spid57,Unknown,*     EFlags: 00010246:  0072006F  00200074  006F0054  006C006F  005C0073  0043003B
07/17/2013 15:05:07,spid57,Unknown,*      SegCs: 0000001B:
07/17/2013 15:05:07,spid57,Unknown,*        Ebp: 6593CAA4:  6593CB68  011ED796  0C5840B8  09FECD58  0C5842A8  00000000
07/17/2013 15:05:07,spid57,Unknown,*        Eip: 011F0B9E:  108B068B  D2FFCE8B  8B084789  04508B06  D2FFCE8B  8B0C4789
07/17/2013 15:05:07,spid57,Unknown,*        Edx: 0149EED8:  013BBAE7  013F90C2  013A04BB  014DDB4D  01BB5BE3  01409D3E
07/17/2013 15:05:07,spid57,Unknown,*        Ecx: 2177913E:
07/17/2013 15:05:07,spid57,Unknown,*        Ebx: 0C5840B8:  014D4D88  00000000  00000001  00520032  3E9D2825  00000001
07/17/2013 15:05:07,spid57,Unknown,*        Eax: 00000000:
07/17/2013 15:05:07,spid57,Unknown,*        Esi: 00000000:
07/17/2013 15:05:07,spid57,Unknown,*        Edi: 0C585620:  6F433400  206F746E  43206964  73612041  69636F73  30617461
07/17/2013 15:05:07,spid57,Unknown,*
07/17/2013 15:05:07,spid57,Unknown,* dbghelp                        63570000  63684FFF  00115000
07/17/2013 15:05:07,spid57,Unknown,* xpsqlbot                       006D0000  006D6FFF  00007000
07/17/2013 15:05:07,spid57,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
07/17/2013 15:05:07,spid57,Unknown,* winrnr                         76F70000  76F76FFF  00007000
07/17/2013 15:05:07,spid57,Unknown,* xplog70                        631F0000  631F1FFF  00002000
07/17/2013 15:05:07,spid57,Unknown,* xplog70                        631D0000  631DBFFF  0000c000
07/17/2013 15:05:07,spid57,Unknown,* xpstar                         62DB0000  62DD4FFF  00025000
07/17/2013 15:05:07,spid57,Unknown,* resutils                       62D90000  62DA2FFF  00013000
07/17/2013 15:05:07,spid57,Unknown,* clusapi                        62D70000  62D81FFF  00012000
07/17/2013 15:05:07,spid57,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
07/17/2013 15:05:07,spid57,Unknown,* SQLSCM                         62D50000  62D59FFF  0000a000
07/17/2013 15:05:07,spid57,Unknown,* xpstar                         62CF0000  62D3BFFF  0004c000
07/17/2013 15:05:07,spid57,Unknown,* SQLNCLIR10                     62C30000  62C66FFF  00037000
07/17/2013 15:05:07,spid57,Unknown,* sqlncli10                      629A0000  62C19FFF  0027a000
07/17/2013 15:05:07,spid57,Unknown,* COMRes                         77010000  770D5FFF  000c6000
07/17/2013 15:05:07,spid57,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
07/17/2013 15:05:07,spid57,Unknown,* xpsp2res                       626B0000  62974FFF  002c5000
07/17/2013 15:05:07,spid57,Unknown,* DNSAPI                         76ED0000  76EF9FFF  0002a000
07/17/2013 15:05:07,spid57,Unknown,* ntdsapi                        766F0000  76703FFF  00014000
07/17/2013 15:05:07,spid57,Unknown,* wshtcpip                       71AE0000  71AE7FFF  00008000
07/17/2013 15:05:07,spid57,Unknown,* wshqos                         62260000  62269FFF  0000a000
07/17/2013 15:05:07,spid57,Unknown,* hnetcfg                        62200000  62259FFF  0005a000
07/17/2013 15:05:07,spid57,Unknown,* mswsock                        71B20000  71B60FFF  00041000
07/17/2013 15:05:07,spid57,Unknown,* imagehlp                       76C10000  76C37FFF  00028000
07/17/2013 15:05:07,spid57,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
07/17/2013 15:05:07,spid57,Unknown,* dbghelp                        61DF0000  61F04FFF  00115000
07/17/2013 15:05:07,spid57,Unknown,* MSFTE                          61B90000  61DE8FFF  00259000
07/17/2013 15:05:07,spid57,Unknown,* ftimport                       61B70000  61B8CFFF  0001d000
07/17/2013 15:05:07,spid57,Unknown,* SAMLIB                         61B40000  61B4EFFF  0000f000
07/17/2013 15:05:07,spid57,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
07/17/2013 15:05:07,spid57,Unknown,* NTMARTA                        77E00000  77E20FFF  00021000
07/17/2013 15:05:07,spid57,Unknown,* dssenh                         68100000  68126FFF  00027000
07/17/2013 15:05:07,spid57,Unknown,* security                       71F60000  71F63FFF  00004000
07/17/2013 15:05:07,spid57,Unknown,* schannel                       76750000  76776FFF  00027000
07/17/2013 15:05:07,spid57,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
07/17/2013 15:05:07,spid57,Unknown,* kerberos                       71CA0000  71CF7FFF  00058000
07/17/2013 15:05:07,spid57,Unknown,* msv1_0                         76C90000  76CB6FFF  00027000
07/17/2013 15:05:07,spid57,Unknown,* MSCOREE                        34040000  34085FFF  00046000
07/17/2013 15:05:07,spid57,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
07/17/2013 15:05:07,spid57,Unknown,* rsaenh                         68000000  68034FFF  00035000
07/17/2013 15:05:07,spid57,Unknown,* sqlevn70                       4F610000  4F813FFF  00204000
07/17/2013 15:05:07,spid57,Unknown,* instapi10                      009D0000  009D9FFF  0000a000
07/17/2013 15:05:07,spid57,Unknown,* odbcint                        00840000  00856FFF  00017000
07/17/2013 15:05:07,spid57,Unknown,* comctl32                       77420000  77522FFF  00103000
07/17/2013 15:05:07,spid57,Unknown,* IMM32                          76290000  762ACFFF  0001d000
07/17/2013 15:05:07,spid57,Unknown,* BatchParser                    520C0000  520E0FFF  00021000
07/17/2013 15:05:07,spid57,Unknown,* NETAPI32                       71C40000  71C96FFF  00057000
07/17/2013 15:05:07,spid57,Unknown,* opends60                       333E0000  333E6FFF  00007000
07/17/2013 15:05:07,spid57,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
07/17/2013 15:05:07,spid57,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
07/17/2013 15:05:07,spid57,Unknown,* PSAPI                          76B70000  76B7AFFF  0000b000
07/17/2013 15:05:07,spid57,Unknown,* IPHLPAPI                       76CF0000  76D09FFF  0001a000
07/17/2013 15:05:07,spid57,Unknown,* WINMM                          76AA0000  76ACCFFF  0002d000
07/17/2013 15:05:07,spid57,Unknown,* USERENV                        76920000  769E1FFF  000c2000
07/17/2013 15:05:07,spid57,Unknown,* MSASN1                         76190000  761A1FFF  00012000
07/17/2013 15:05:07,spid57,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
07/17/2013 15:05:07,spid57,Unknown,* VERSION                        77B90000  77B97FFF  00008000
07/17/2013 15:05:07,spid57,Unknown,* odbcbcp                        60950000  60955FFF  00006000
07/17/2013 15:05:07,spid57,Unknown,* ODBC32                         48890000  488CCFFF  0003d000
07/17/2013 15:05:07,spid57,Unknown,* OLEAUT32                       77D00000  77D8AFFF  0008b000
07/17/2013 15:05:07,spid57,Unknown,* ole32                          77670000  777A8FFF  00139000
07/17/2013 15:05:07,spid57,Unknown,* SHELL32                        7C8D0000  7D0CDFFF  007fe000
07/17/2013 15:05:07,spid57,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
07/17/2013 15:05:07,spid57,Unknown,* comdlg32                       762B0000  762F8FFF  00049000
07/17/2013 15:05:07,spid57,Unknown,* USER32                         77380000  77410FFF  00091000
07/17/2013 15:05:07,spid57,Unknown,* GDI32                          77C00000  77C47FFF  00048000
07/17/2013 15:05:07,spid57,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
07/17/2013 15:05:07,spid57,Unknown,* pdh                            72590000  725DBFFF  0004c000
07/17/2013 15:05:07,spid57,Unknown,* sqlos                          344D0000  344D5FFF  00006000
07/17/2013 15:05:07,spid57,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
07/17/2013 15:05:07,spid57,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
07/17/2013 15:05:07,spid57,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
07/17/2013 15:05:07,spid57,Unknown,* Secur32                        76F50000  76F62FFF  00013000
07/17/2013 15:05:07,spid57,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
07/17/2013 15:05:07,spid57,Unknown,* ADVAPI32                       77F50000  77FEAFFF  0009b000
07/17/2013 15:05:07,spid57,Unknown,* kernel32                       77E40000  77F41FFF  00102000
07/17/2013 15:05:07,spid57,Unknown,* ntdll                          7C800000  7C8BFFFF  000c0000
07/17/2013 15:05:07,spid57,Unknown,* sqlservr                       01000000  039B0FFF  029b1000
07/17/2013 15:05:07,spid57,Unknown,*  MODULE                          BASE      END       SIZE
07/17/2013 15:05:07,spid57,Unknown,*
07/17/2013 15:05:07,spid57,Unknown,*
07/17/2013 15:05:07,spid57,Unknown,*  _50.SQL08\MSSQL\DATA\TESTRESTORE.LDF'<c/>  NOUNLOAD<c/>  REPLACE<c/>  STATS = 10
07/17/2013 15:05:07,spid57,Unknown,*  SSQL\DATA\TESTRESTORE.MDF'<c/>  MOVE N'DBNAMELOG' TO N'D:\sql\2008\MSSQL10
07/17/2013 15:05:07,spid57,Unknown,*  ak' WITH  FILE = 1<c/>  MOVE N'DBNAME' TO N'D:\sql\2008\MSSQL10_50.SQL08\M
07/17/2013 15:05:07,spid57,Unknown,*             RESTORE DATABASE [TESTRESTORE2] FROM  DISK = N'D:\backupnew.b
07/17/2013 15:05:07,spid57,Unknown,* Input Buffer 510 bytes -
07/17/2013 15:05:07,spid57,Unknown,*   Access Violation occurred reading address 00000000
07/17/2013 15:05:07,spid57,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
07/17/2013 15:05:07,spid57,Unknown,*   Exception Address = 011F0B9E Module(sqlservr+001F0B9E)
07/17/2013 15:05:07,spid57,Unknown,*
07/17/2013 15:05:07,spid57,Unknown,*
07/17/2013 15:05:07,spid57,Unknown,*   07/17/13 15:05:07 spid 57
07/17/2013 15:05:07,spid57,Unknown,* BEGIN STACK DUMP:
07/17/2013 15:05:07,spid57,Unknown,*
07/17/2013 15:05:07,spid57,Unknown,* *******************************************************************************
07/17/2013 15:05:07,spid57,Unknown,SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
07/17/2013 15:05:07,spid57,Unknown,***Stack Dump being sent to D:\sql\2008\MSSQL10_50.SQL08\MSSQL\LOG\SQLDump0021.txt
07/17/2013 15:05:07,spid57,Unknown,Using 'dbghelp.dll' version '4.0.5'
07/17/2013 15:04:54,spid57,Unknown,Recovery is writing a checkpoint in database 'TESTRESTORE2' (5). This is an informational message only. No user action is required.
07/17/2013 15:04:54,spid57,Unknown,Starting up database 'TESTRESTORE2'.
07/17/2013 15:04:54,spid57,Unknown,The database 'TESTRESTORE2' is marked RESTORING and is in a state that does not allow recovery to be run.
07/17/2013 15:04:54,spid57,Unknown,Starting up database 'TESTRESTORE2'.
07/17/2013 14:56:22,spid57,Unknown,During upgrade<c/> database raised exception 2905<c/> severity 25<c/> state 1<c/> address 02A6C080. Use the exception number to determine the cause.
07/17/2013 14:56:22,spid57,Unknown,Error: 928<c/> Severity: 20<c/> State: 1.
07/17/2013 14:56:22,spid57,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
07/17/2013 14:56:22,spid57,Unknown,Stack Signature for the dump is 0x0292FACC
07/17/2013 14:56:22,spid57,Unknown,78132A47 Module(MSVCR80+00002A47)
07/17/2013 14:56:22,spid57,Unknown,781329BB Module(MSVCR80+000029BB)
07/17/2013 14:56:22,spid57,Unknown,01124B26 Module(sqlservr+00124B26)
07/17/2013 14:56:22,spid57,Unknown,01122EB8 Module(sqlservr+00122EB8)
07/17/2013 14:56:22,spid57,Unknown,01123403 Module(sqlservr+00123403)
07/17/2013 14:56:22,spid57,Unknown,01123518 Module(sqlservr+00123518)
07/17/2013 14:56:22,spid57,Unknown,015D3162 Module(sqlservr+005D3162)
07/17/2013 14:56:22,spid57,Unknown,015D331A Module(sqlservr+005D331A)
07/17/2013 14:56:22,spid57,Unknown,015D352F Module(sqlservr+005D352F)
07/17/2013 14:56:22,spid57,Unknown,01589393 Module(sqlservr+00589393)
07/17/2013 14:56:22,spid57,Unknown,0158950A Module(sqlservr+0058950A)
07/17/2013 14:56:22,spid57,Unknown,0158775B Module(sqlservr+0058775B)
07/17/2013 14:56:22,spid57,Unknown,0158AD21 Module(sqlservr+0058AD21)
07/17/2013 14:56:22,spid57,Unknown,01586BFE Module(sqlservr+00586BFE)
07/17/2013 14:56:22,spid57,Unknown,012E4BAC Module(sqlservr+002E4BAC)
07/17/2013 14:56:22,spid57,Unknown,01FEB7AB Module(sqlservr+00FEB7AB)
07/17/2013 14:56:22,spid57,Unknown,028A7833 Module(sqlservr+018A7833)
07/17/2013 14:56:22,spid57,Unknown,0291B433 Module(sqlservr+0191B433)
07/17/2013 14:56:22,spid57,Unknown,02926C41 Module(sqlservr+01926C41)
07/17/2013 14:56:22,spid57,Unknown,02927225 Module(sqlservr+01927225)
07/17/2013 14:56:22,spid57,Unknown,028E9C71 Module(sqlservr+018E9C71)
07/17/2013 14:56:22,spid57,Unknown,025F43A7 Module(sqlservr+015F43A7)
07/17/2013 14:56:22,spid57,Unknown,02609D7F Module(sqlservr+01609D7F)
07/17/2013 14:56:22,spid57,Unknown,0260B528 Module(sqlservr+0160B528)
07/17/2013 14:56:22,spid57,Unknown,027133A9 Module(sqlservr+017133A9)
07/17/2013 14:56:22,spid57,Unknown,02714DC5 Module(sqlservr+01714DC5)
07/17/2013 14:56:22,spid57,Unknown,01C6A3E8 Module(sqlservr+00C6A3E8)
07/17/2013 14:56:22,spid57,Unknown,01C6A76A Module(sqlservr+00C6A76A)
07/17/2013 14:56:22,spid57,Unknown,011F4192 Module(sqlservr+001F4192)
07/17/2013 14:56:22,spid57,Unknown,011F40DA Module(sqlservr+001F40DA)
07/17/2013 14:56:22,spid57,Unknown,011F445C Module(sqlservr+001F445C)
07/17/2013 14:56:22,spid57,Unknown,011ED49C Module(sqlservr+001ED49C)
07/17/2013 14:56:22,spid57,Unknown,011ED796 Module(sqlservr+001ED796)
07/17/2013 14:56:22,spid57,Unknown,011F0B9E Module(sqlservr+001F0B9E)
07/17/2013 14:56:22,spid57,Unknown,* Short Stack Dump
07/17/2013 14:56:22,spid57,Unknown,* -------------------------------------------------------------------------------
07/17/2013 14:56:22,spid57,Unknown,* *******************************************************************************
07/17/2013 14:56:22,spid57,Unknown,*      SegSs: 00000023:
07/17/2013 14:56:22,spid57,Unknown,*        Esp: 6391C750:  01026276  27759CA6  6391CED0  070A4D58  00000000  0A85D800
07/17/2013 14:56:22,spid57,Unknown,*     EFlags: 00010246:  0072006F  00200074  006F0054  006C006F  005C0073  0043003B
07/17/2013 14:56:22,spid57,Unknown,*      SegCs: 0000001B:
07/17/2013 14:56:22,spid57,Unknown,*        Ebp: 6391CAA4:  6391CB68  011ED796  0C6740B8  070A4D58  0C6742A8  00000000
07/17/2013 14:56:22,spid57,Unknown,*        Eip: 011F0B9E:  108B068B  D2FFCE8B  8B084789  04508B06  D2FFCE8B  8B0C4789
07/17/2013 14:56:22,spid57,Unknown,*        Edx: 0149EED8:  013BBAE7  013F90C2  013A04BB  014DDB4D  01BB5BE3  01409D3E
07/17/2013 14:56:22,spid57,Unknown,*        Ecx: 2775913E:
07/17/2013 14:56:22,spid57,Unknown,*        Ebx: 0C6740B8:  014D4D88  00000000  00000001  00000000  3E9D2825  00000001
07/17/2013 14:56:22,spid57,Unknown,*        Eax: 00000000:
07/17/2013 14:56:22,spid57,Unknown,*        Esi: 00000000:
07/17/2013 14:56:22,spid57,Unknown,*        Edi: 0C675620:  04000001  00100000  00000014  00004040  72C14000  01CC3F80
07/17/2013 14:56:22,spid57,Unknown,*
07/17/2013 14:56:22,spid57,Unknown,* dbghelp                        63570000  63684FFF  00115000
07/17/2013 14:56:22,spid57,Unknown,* xpsqlbot                       006D0000  006D6FFF  00007000
07/17/2013 14:56:22,spid57,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
07/17/2013 14:56:22,spid57,Unknown,* winrnr                         76F70000  76F76FFF  00007000
07/17/2013 14:56:22,spid57,Unknown,* xplog70                        631F0000  631F1FFF  00002000
07/17/2013 14:56:22,spid57,Unknown,* xplog70                        631D0000  631DBFFF  0000c000
07/17/2013 14:56:22,spid57,Unknown,* xpstar                         62DB0000  62DD4FFF  00025000
07/17/2013 14:56:22,spid57,Unknown,* resutils                       62D90000  62DA2FFF  00013000
07/17/2013 14:56:22,spid57,Unknown,* clusapi                        62D70000  62D81FFF  00012000
07/17/2013 14:56:22,spid57,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
07/17/2013 14:56:22,spid57,Unknown,* SQLSCM                         62D50000  62D59FFF  0000a000
07/17/2013 14:56:22,spid57,Unknown,* xpstar                         62CF0000  62D3BFFF  0004c000
07/17/2013 14:56:22,spid57,Unknown,* SQLNCLIR10                     62C30000  62C66FFF  00037000
07/17/2013 14:56:22,spid57,Unknown,* sqlncli10                      629A0000  62C19FFF  0027a000
07/17/2013 14:56:22,spid57,Unknown,* COMRes                         77010000  770D5FFF  000c6000
07/17/2013 14:56:22,spid57,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
07/17/2013 14:56:22,spid57,Unknown,* xpsp2res                       626B0000  62974FFF  002c5000
07/17/2013 14:56:22,spid57,Unknown,* DNSAPI                         76ED0000  76EF9FFF  0002a000
07/17/2013 14:56:22,spid57,Unknown,* ntdsapi                        766F0000  76703FFF  00014000
07/17/2013 14:56:22,spid57,Unknown,* wshtcpip                       71AE0000  71AE7FFF  00008000
07/17/2013 14:56:22,spid57,Unknown,* wshqos                         62260000  62269FFF  0000a000
07/17/2013 14:56:22,spid57,Unknown,* hnetcfg                        62200000  62259FFF  0005a000
07/17/2013 14:56:22,spid57,Unknown,* mswsock                        71B20000  71B60FFF  00041000
07/17/2013 14:56:22,spid57,Unknown,* imagehlp                       76C10000  76C37FFF  00028000
07/17/2013 14:56:22,spid57,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
07/17/2013 14:56:22,spid57,Unknown,* dbghelp                        61DF0000  61F04FFF  00115000
07/17/2013 14:56:22,spid57,Unknown,* MSFTE                          61B90000  61DE8FFF  00259000
07/17/2013 14:56:22,spid57,Unknown,* ftimport                       61B70000  61B8CFFF  0001d000
07/17/2013 14:56:22,spid57,Unknown,* SAMLIB                         61B40000  61B4EFFF  0000f000
07/17/2013 14:56:22,spid57,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
07/17/2013 14:56:22,spid57,Unknown,* NTMARTA                        77E00000  77E20FFF  00021000
07/17/2013 14:56:22,spid57,Unknown,* dssenh                         68100000  68126FFF  00027000
07/17/2013 14:56:22,spid57,Unknown,* security                       71F60000  71F63FFF  00004000
07/17/2013 14:56:22,spid57,Unknown,* schannel                       76750000  76776FFF  00027000
07/17/2013 14:56:22,spid57,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
07/17/2013 14:56:22,spid57,Unknown,* kerberos                       71CA0000  71CF7FFF  00058000
07/17/2013 14:56:22,spid57,Unknown,* msv1_0                         76C90000  76CB6FFF  00027000
07/17/2013 14:56:22,spid57,Unknown,* MSCOREE                        34040000  34085FFF  00046000
07/17/2013 14:56:22,spid57,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
07/17/2013 14:56:22,spid57,Unknown,* rsaenh                         68000000  68034FFF  00035000
07/17/2013 14:56:22,spid57,Unknown,* sqlevn70                       4F610000  4F813FFF  00204000
07/17/2013 14:56:22,spid57,Unknown,* instapi10                      009D0000  009D9FFF  0000a000
07/17/2013 14:56:22,spid57,Unknown,* odbcint                        00840000  00856FFF  00017000
07/17/2013 14:56:22,spid57,Unknown,* comctl32                       77420000  77522FFF  00103000
07/17/2013 14:56:22,spid57,Unknown,* IMM32                          76290000  762ACFFF  0001d000
07/17/2013 14:56:22,spid57,Unknown,* BatchParser                    520C0000  520E0FFF  00021000
07/17/2013 14:56:22,spid57,Unknown,* NETAPI32                       71C40000  71C96FFF  00057000
07/17/2013 14:56:22,spid57,Unknown,* opends60                       333E0000  333E6FFF  00007000
07/17/2013 14:56:22,spid57,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
07/17/2013 14:56:22,spid57,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
07/17/2013 14:56:22,spid57,Unknown,* PSAPI                          76B70000  76B7AFFF  0000b000
07/17/2013 14:56:22,spid57,Unknown,* IPHLPAPI                       76CF0000  76D09FFF  0001a000
07/17/2013 14:56:22,spid57,Unknown,* WINMM                          76AA0000  76ACCFFF  0002d000
07/17/2013 14:56:22,spid57,Unknown,* USERENV                        76920000  769E1FFF  000c2000
07/17/2013 14:56:22,spid57,Unknown,* MSASN1                         76190000  761A1FFF  00012000
07/17/2013 14:56:22,spid57,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
07/17/2013 14:56:22,spid57,Unknown,* VERSION                        77B90000  77B97FFF  00008000
07/17/2013 14:56:22,spid57,Unknown,* odbcbcp                        60950000  60955FFF  00006000
07/17/2013 14:56:22,spid57,Unknown,* ODBC32                         48890000  488CCFFF  0003d000
07/17/2013 14:56:22,spid57,Unknown,* OLEAUT32                       77D00000  77D8AFFF  0008b000
07/17/2013 14:56:22,spid57,Unknown,* ole32                          77670000  777A8FFF  00139000
07/17/2013 14:56:22,spid57,Unknown,* SHELL32                        7C8D0000  7D0CDFFF  007fe000
07/17/2013 14:56:22,spid57,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
07/17/2013 14:56:22,spid57,Unknown,* comdlg32                       762B0000  762F8FFF  00049000
07/17/2013 14:56:22,spid57,Unknown,* USER32                         77380000  77410FFF  00091000
07/17/2013 14:56:22,spid57,Unknown,* GDI32                          77C00000  77C47FFF  00048000
07/17/2013 14:56:22,spid57,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
07/17/2013 14:56:22,spid57,Unknown,* pdh                            72590000  725DBFFF  0004c000
07/17/2013 14:56:22,spid57,Unknown,* sqlos                          344D0000  344D5FFF  00006000
07/17/2013 14:56:22,spid57,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
07/17/2013 14:56:22,spid57,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
07/17/2013 14:56:22,spid57,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
07/17/2013 14:56:22,spid57,Unknown,* Secur32                        76F50000  76F62FFF  00013000
07/17/2013 14:56:22,spid57,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
07/17/2013 14:56:22,spid57,Unknown,* ADVAPI32                       77F50000  77FEAFFF  0009b000
07/17/2013 14:56:22,spid57,Unknown,* kernel32                       77E40000  77F41FFF  00102000
07/17/2013 14:56:22,spid57,Unknown,* ntdll                          7C800000  7C8BFFFF  000c0000
07/17/2013 14:56:22,spid57,Unknown,* sqlservr                       01000000  039B0FFF  029b1000
07/17/2013 14:56:22,spid57,Unknown,*  MODULE                          BASE      END       SIZE
07/17/2013 14:56:22,spid57,Unknown,*
07/17/2013 14:56:22,spid57,Unknown,*
07/17/2013 14:56:22,spid57,Unknown,*  _50.SQL08\MSSQL\DATA\TESTRESTORE.LDF'<c/>  NOUNLOAD<c/>  REPLACE<c/>  STATS = 10
07/17/2013 14:56:22,spid57,Unknown,*  SSQL\DATA\TESTRESTORE.MDF'<c/>  MOVE N'DBNAMELOG' TO N'D:\sql\2008\MSSQL10
07/17/2013 14:56:22,spid57,Unknown,*  ak' WITH  FILE = 1<c/>  MOVE N'DBNAME' TO N'D:\sql\2008\MSSQL10_50.SQL08\M
07/17/2013 14:56:22,spid57,Unknown,*             RESTORE DATABASE [TESTRESTORE2] FROM  DISK = N'D:\backupnew.b
07/17/2013 14:56:22,spid57,Unknown,* Input Buffer 510 bytes -
07/17/2013 14:56:22,spid57,Unknown,*   Access Violation occurred reading address 00000000
07/17/2013 14:56:22,spid57,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
07/17/2013 14:56:22,spid57,Unknown,*   Exception Address = 011F0B9E Module(sqlservr+001F0B9E)
07/17/2013 14:56:22,spid57,Unknown,*
07/17/2013 14:56:22,spid57,Unknown,*
07/17/2013 14:56:22,spid57,Unknown,*   07/17/13 14:56:22 spid 57
07/17/2013 14:56:22,spid57,Unknown,* BEGIN STACK DUMP:
07/17/2013 14:56:22,spid57,Unknown,*
07/17/2013 14:56:22,spid57,Unknown,* *******************************************************************************
07/17/2013 14:56:22,spid57,Unknown,SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
07/17/2013 14:56:22,spid57,Unknown,***Stack Dump being sent to D:\sql\2008\MSSQL10_50.SQL08\MSSQL\LOG\SQLDump0020.txt
07/17/2013 14:56:22,spid57,Unknown,Using 'dbghelp.dll' version '4.0.5'
07/17/2013 14:56:08,spid57,Unknown,Recovery is writing a checkpoint in database 'TESTRESTORE2' (5). This is an informational message only. No user action is required.
07/17/2013 14:56:08,spid57,Unknown,Starting up database 'TESTRESTORE2'.
07/17/2013 14:56:08,spid57,Unknown,The database 'TESTRESTORE2' is marked RESTORING and is in a state that does not allow recovery to be run.
07/17/2013 14:56:08,spid57,Unknown,Starting up database 'TESTRESTORE2'.

thk

is this problem specific to one particular database or it just happening with any SQL Server 2000 database from your source server??

Sorry, I know we are all driving you through many scenarios and its painful.

recently I upgraded two SQL Server 2000 instances to 2012 and luckily everything went fine.  

Did you try with restoring SQL Server 2000 onto the same server with different name and then try back with 2008?

As you are running with updated version of 2000 nothing you could do with any updates on your source server but can I ask you to verify that if your source database objects has been used in any sort of publication for replication, please try to verify objects that are marked for replication and remove them from replication and then take a fresh backup. 

Thanks 

MK

Hi DBA_MK,

the original db has a replication.

For migrate the db from sql 2000 to sql 2008, i made a test server with the two version of sql.

When i restored the bak of sql 2000 the replication is not carry.

How i see if exists pieces of replication in the db? How can remove it?
(I can't remove the replication on original db because is work yet)

Thanks

hi Giorgio

could you verify that your SQL Server 2000 database backup is not corrupt by restoring it to a SQL Server 2000 instance?

had this database created initially on SQL Server 2000 or had it been upgraded from an previous SQL Server version?

Backup and restore a SQL Server 2000 database to a SQL Server 2008R2 is fully supported by the database must be at Compatiblity level SQL Server 2000 and not an earlier level.

Do the SQL Server 2000 and SQL Server 2008R2 use the same (or compatible) collation settings ?