sql server数据恢复？？?

用log文件恢复，但前提是你的每次操作有备份到log文件中。

给点教学代码看看的:呵呵,你调试下的
use master
go

--在硬盘上创建备份设备
exec sp_addumpdevice 'disk',mybackupfile,
'c:\Mybackupfile.bak'

--删除备份设备
exec sp_dropdevice mybackupfile

--备份数据库数据到临时设备
backup database northwind
to disk = 'c:\northwind.bak'

--完全备份数据库到备份设备
backup database northwind
to mybackupfile

--执行差异备份
backup database northwind
to mybackupfile
with differential

-- 备份日志文件到备份设备
exec sp_addumpdevice 'disk',mybackupLog,
'c:\MybackupLog.bak'

backup log northwind
to mybackupLog

-- 备份日志文件到临时备份设备
backup log northwind
to disk = 'c:\mybackupLog.bak'

--从备份设备还原数据库
restore database northwind
from mybackupfile

--从备份文件还原数据库
backup database northwind
to disk = 'c:\northwindback.bak'
<