Restoring Database problem sql server 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Restoring Database problem sql server 2005

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-08-24 : 01:56:40

Hello frriends

i am using sql server 2005

step 1
RESTORE FILELISTONLY
FROM DISK = N'F:\Database Files\LiveData\LiveData_backup_200608202100.bak'

Output:
mdf--- LiveData
ldf--- LiveData_log'

step 2
RESTORE DATABASE DataLive
FROM DISK = N'F:\Database Files\LiveData\LiveData_backup_200608202100.bak'
WITH Replace,
MOVE 'LiveData' TO N'F:\Database Files\LiveData\DataLive.mdf',
MOVE 'LiveData_log' TO N'F:\Database Files\LiveData\DataLive_log.ldf'

but i am gettng error like

Location: bckioreq.cpp:1443
Expression: pFile
SPID: 53
Process ID: 1764
Msg 3013, Level 16, State 1, Line 5
RESTORE DATABASE is terminating abnormally.
Msg 3624, Level 20, State 1, Line 5
A system assertion check has failed. Check the SQL Server error log for details

but when i see object explorer there i am seeing my Database is restoring

????? what it all means

Please help me out

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-24 : 02:36:23

are you running SQL 2K5 SP1?

-ec

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-08-24 : 02:39:02

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

this what i get from

select @@version

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-24 : 02:45:08

quote:
Originally posted by under2811

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

this what i get from

select @@version

is this a prod system? if not, I would try slapping SQL2K5 sp1 on there and see if that fixes your problem. Do you have any other SQL2K5 systems there? You might try restoring this database on another host to see if you get the same error.

The reason I mention SP1 is becuase there is some mention in the "system assertion check has failed" error in this KB article http://support.microsoft.com/kb/913090/ but it doesn't appeare related to restore operations. It is a bit of a shot in the dark really..

-ec

EDIT:
fixed link

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-08-24 : 02:59:01

i am not getting this link do you have any other option to get lattest SP to download

thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-24 : 10:20:10

quote:
Originally posted by under2811

i am not getting this link do you have any other option to get lattest SP to download

thanks

looks like I missed the trailing backslash

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

-ec

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-08-31 : 10:32:55

hello friends

today i also tried for the same but same error i am getting i click cancel button and refresh my server but i am seeing that database is showing status as Restoring...

does it really restoring database in background or what that mean

T.I.A

max conde
Starting Member

1 Post

Posted - 2006-11-29 : 07:03:13

I have a similar problem with a commercial backup software, Tivoli Data Protection 5.2.1.3

When I restore a database with 12 GB then I get the error below.
I have installed SQL Server 2005 Standard Edt. SP1 on Windows 2003 SP1.

I have reinstalled the system but the problem is still there.
I can restore other databases on this server and sometimes also restores of this database work.

;(
max

Date,Source,Severity,Message
11/29/2006 12:21:47,spid53,Unknown,A system assertion check has failed. Check the SQL Server error log for details
11/29/2006 12:21:47,spid53,Unknown,Error: 3624<c/> Severity: 20<c/> State: 1.
11/29/2006 12:21:47,spid53,Unknown,SQL Server Assertion: File: <bckioreq.cpp><c/> line=1443 Failed Assertion = 'pFile'. This error may be timing-related. If the error persists after rerunning the statement<c/> use DBCC CHECKDB to check the database for structural integrity<c/> or restart the server to ensure in-memory data structures are not corrupted.
11/29/2006 12:21:47,spid53,Unknown,Error: 17066<c/> Severity: 16<c/> State: 1.
11/29/2006 12:21:47,spid53,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
11/29/2006 12:21:45,spid53,Unknown,Stack Signature for the dump is 0xF50E5B3C
11/29/2006 12:21:45,spid53,Unknown,78132A36 Module(MSVCR80+00002A36)
11/29/2006 12:21:45,spid53,Unknown,781329AA Module(MSVCR80+000029AA)
.
.
.
11/29/2006 12:21:45,spid53,Unknown,* sqlservr 01000000 02BCEFFF 01bcf000
11/29/2006 12:21:45,spid53,Unknown,* MODULE BASE END SIZE
11/29/2006 12:21:45,spid53,Unknown,*
11/29/2006 12:21:45,spid53,Unknown,*
11/29/2006 12:21:45,spid53,Unknown,* 0000' WITH BLOCKSIZE=512<c/> MAXTRANSFERSIZE=1048576<c/> RECOVERY<c/> REPLACE
11/29/2006 12:21:45,spid53,Unknown,* USE master RESTORE DATABASE [SA7] from VIRTUAL_DEVICE=N'TDPSQL-00001488-
11/29/2006 12:21:45,spid53,Unknown,* Input Buffer 280 bytes -

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources