1.先备份刚删除的数据库
use master
BACKUP LOG test2 TO disk= 'D:\Program Files\test2' WITH NORECOVERY
-2) 恢复一个误删除之前的完全备份:
use master
RESTORE DATABASE test2 FROM DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\test2.bak' WITH NORECOVERY, REPLACE
-3) 将数据库恢复至误删除之前的时间点:
use master
RESTORE LOG test2 FROM DISK = 'D:\Program Files\test2' WITH STOPAT = '2014-05-09 22:55:46.157' , RECOVERY
-4
use test2
select * from Table_1
//查看连接哪个数据库的连接数
use master
SELECT * FROM sys.sysprocesses WHERE dbid=DB_ID('test2')
取消数据库还原
use master
restore database test2 with recovery
use master
restore database test2 with norecovery
断开数据库getReads并立即回滚所有的事务
ALTER DATABASE test2 SET OFFLINE WITH ROLLBACK IMMEDIATE
alter database test2 set online