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
解决方案 »
- 提示 Incompatible types: 'Array' and 'Integer' 错误,谁能看看哪有问题
- 在 线程外 如何判断线程已经结束;
- 我delphi調用電腦計算器,怎樣取得計算器結果呢。
- Incompatible types: 'Integer' and 'Extended'怎么解决啊~?
- 简单问题,揭贴马上给分?
- TdxDBinspector的用法!急!急!急!
- 需要Delphi版本的winapi手册
- 改变窗体的尺寸!
- 我把贴子开的到处都是. 怎样定制dbgrid,另开贴
- 线程 Abstract Error
- 高分求救,求的字符的UNICODE码的函数!
- DocDrag1.0正式版版正式发布,大家以后收集加工网上资料方便了,送分咯!
back database 库名 to disk = '路径\备份文件名' with init(覆盖)