BACKUP DATABASE mywind
TO DISK ='g:\mywind.dmp'
WITH INIT
GO
USE mywind
GO
CREATE TABLE t1 (id int) ON new_customers
CREATE TABLE t2 (id int) ON sales
GO
BACKUP LOG mywind TO DISK='g:\mywind.dmp'
WITH NOINIT
GO
RESTORE DATABASE mywind_part
FILEGROUP = 'sales'
FROM DISK='g:\mywind.dmp'
WITH FILE=1,NORECOVERY,PARTIAL,
MOVE 'mywind' TO 'g:\mw2.pri',
MOVE 'mywind_log' TO 'g:\mw2.log',
MOVE 'mywind_data_2' TO 'g:\mw2.dat2'
GO
RESTORE LOG mywind_part
FROM DISK = 'g:\mywind.dmp'
WITH FILE = 2,RECOVERY
GO
TO DISK ='g:\mywind.dmp'
WITH INIT
GO
USE mywind
GO
CREATE TABLE t1 (id int) ON new_customers
CREATE TABLE t2 (id int) ON sales
GO
BACKUP LOG mywind TO DISK='g:\mywind.dmp'
WITH NOINIT
GO
RESTORE DATABASE mywind_part
FILEGROUP = 'sales'
FROM DISK='g:\mywind.dmp'
WITH FILE=1,NORECOVERY,PARTIAL,
MOVE 'mywind' TO 'g:\mw2.pri',
MOVE 'mywind_log' TO 'g:\mw2.log',
MOVE 'mywind_data_2' TO 'g:\mw2.dat2'
GO
RESTORE LOG mywind_part
FROM DISK = 'g:\mywind.dmp'
WITH FILE = 2,RECOVERY
GO
解决方案 »
- 在SQL数据库查询过程中如何ProgressBar进度条显示查询过程
- 问下,如何将ADOQUERY或者ADOTABLE的纪录写入文本文件
- odbc+bde+MS SQL SERVER同一机器打开多个程序报错。。。
- 关于使用 Wise 建立安装包的问题 [急]
- Delphi 图形处理/多媒体问题
- 关于DBGRID如何设置保存与不保存(我暂时没分,有了一定加)
- 有无办法向某字段中追加内容?
- 怎样实现多表查询?
- 请教高手,D6+ADO+SQL SERVER中<无法更新定位行,一些值可能已在最后一次读取后已更改>该如何解决?
- 如何实现计算机进入 睡眠状态
- 高分求救,求的字符的UNICODE码的函数!
- DocDrag1.0正式版版正式发布,大家以后收集加工网上资料方便了,送分咯!
back database 库名 to disk = '路径\备份文件名' with init(覆盖)