try:
restore database test from disk='c:\test.bak' with file=2,norecovery
restore database test from disk='c:\test.bak' with file=5,recovery
restore database test from disk='c:\test.bak' with file=2,norecovery
restore database test from disk='c:\test.bak' with file=5,recovery
解决方案 »
- sql server 2005数据库置疑修复
- 求助 关于sql 替换
- 这么简单的都不会.晕啦.
- 倒数第二位加上个0
- 程序调用存储过程中遇到的一个离奇问题
- 关于SQL-Server登陆用户都改了无法注册连接
- 一个初学存储过程的学生的问题:
- 仅当使用了列的列表,并且 IDENTITY_INSERT 为 ON 时,才能在表 'TableName' 中为标识列指定显式值。
- 求救啊!!请问我用Delete 命令在查询分析器里删除了的数据库记录能恢复吗?能的话怎么恢复,没有备份的!!!
- 各位高手,给大菜鸟一个小小的提示好吗?
- 急急急!ole/db provider returned message 超时已过期
- 两台电脑连接后,其中一台如何登录另一台的MS SQL SERVER数据库。请指教!!
try:
restore database test from disk='c:\test.bak' with file=2,norecovery
restore database test from disk='c:\test.bak' with file=3,recovery
restore database test from disk='c:\test.bak' with file=3 --对应你要还原的差异备份
--两句可以一起执行
exec master..xp_cmdshell 'del c:\text.bak'
if exists(select * from master..sysdatabases where name='test')
drop database test
go--创建数据库
create database test
go--打开创建的数据
use test
go--创建测试表
create table t(a int)--切换回master数据库
use master
go--插入数据1
insert into test..t select 1
go--然后进行一次完整备份
backup database test to disk='c:\test.bak'
go--插入数据2
insert into test..t select 2
go--再进行一次完整备份
backup database test to disk='c:\test.bak'
go--插入3,4
insert into test..t select 3
insert into test..t select 4
go--差异备份:
backup database test to disk='c:\test.bak' with differential--删除数据库
drop database test--还原数据库和差异数据库备份
--还原完整备份
restore database test from disk='c:\test.bak' with file=2,norecovery
--还原差异备份的内容
restore database test from disk='c:\test.bak' with file=3,recovery--显示恢复后的数据
select * from test..t
前段时间我就做过类似程序的!
必须说明的是:在恢复差异备份时,必须恢复最后一次的完整备份!!(切记)
而且下面的两个语句必须同时执行,即放在一个事务中。restore database test from disk='c:\test.bak' with file=离你要恢复的差异备份最近一次的完整备份号,norecovery
restore database test from disk='c:\test.bak' with file=你要还原的差异备份号,recovery具体的备份号可以从下面得到:(你可以认真研究一下backupfile,backupset,backmediaset,backupmediafamily几个表,可以发现规律)
select backup_start_date as 备份时间,position as 备份号,
case type when 'D' then '完整备份' when 'I' then '差异备份' end as 备份类型
from msdb..backupset where database_name='test'
and media_set_id in
(select distinct media_set_id from msdb..backupmediafamily where physical_device_name='c:\test.bak')
order by position如果还不行的话,可以给我留言~
exec master..xp_cmdshell 'del c:\test.bak'
go
use test
go
create table test..t(a int)
insert test..t select 1backup database test to disk='c:\test.bak'
insert test..t select 2backup database test to disk='c:\test.bak'
insert test..t select 3
insert test..t select 4backup database test to disk='c:\test.bak' with differentialdelete test..tgo--下面开始恢复:restore database test from disk='c:\test.bak' with file=2,norecovery --对应你最后一次的完整备份restore database test from disk='c:\test.bak' with file=3 --对应你要还原的差异备份goselect * from test
分不多,给分如下:
yoki 100
zjcxc 25
pengdali 25
yoki这里没给分,我会另外开贴给你分