为什么我不能进行数据恢复?
我在sql server中的bakup目录下有一个 ss.dat数据库备份文件可是我却不能进行
恢复,错误提示如下
SqlDumpExceptionHandler : process 7 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Ser is terminating this process.
location : upgraddb.cpp :214
expression : tableIndex <ARRAY_LEN(upgradeMap)
SPID : 7
Process ID : -368051
还有用语句怎样恢复呢?
问题点数:100、回复次数:4Top
1 楼warning(爱就爱了)回复于 2002-03-28 11:19:48 得分 50
BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
GOTop
2 楼jamex(1 + 1 = 爱)回复于 2002-03-28 13:02:07 得分 25
to warning(爱就爱了):
你试过了吗?行吗 ?
Top
3 楼phosphor(蜗牛)回复于 2002-03-28 14:40:49 得分 0
问题依然Top
4 楼x_zing(阿浩)回复于 2002-03-28 14:58:09 得分 25
restore database dbname
from disk='c:\backup\ss.dat'
Top




