sql server 恢复中的3个模块
1。full 最大恢复(完全恢复)
2.bulk_logged(不能恢复数据库特定的标记)
3.simple( 恢复出结束时刻的数据库)
4。恢复模型运行以下命令:
select dbproper tyex("database","recovery")
(返回full,bulk_logged,simple任意一个值)
5.later DATABASE database name SET recovery{full|bulk_logged|simple}
6. 备份数据库命令:
backup DATABASE{database_name} to <backup_device|
backup_device指一些逻辑上备份设备
7.如果你想做一个快速、一次性的备份,那么向下面那样使用磁盘文件:
BACKUP DATABASE Northwind TO DISK = "c:/backup/Northwind.bak"
procedure add(item,stack ,n,top)
if top>n then call stackfull endif
top=top+1
top=item
end add
procedure delete(item stack,n,top)
if top<0 then call stackempty endif
item=stack(top)
top=top-1
end delete
gerant[all/statement[...n]] to security_account[...n]
deny[all/statement[...n]] to security_account[...n]
rewoke{all/statement[...n]}from security_account[...n]
waitfor{dalay time|time time}
1。full 最大恢复(完全恢复)
2.bulk_logged(不能恢复数据库特定的标记)
3.simple( 恢复出结束时刻的数据库)
4。恢复模型运行以下命令:
select dbproper tyex("database","recovery")
(返回full,bulk_logged,simple任意一个值)
5.later DATABASE database name SET recovery{full|bulk_logged|simple}
6. 备份数据库命令:
backup DATABASE{database_name} to <backup_device|
backup_device指一些逻辑上备份设备
7.如果你想做一个快速、一次性的备份,那么向下面那样使用磁盘文件:
BACKUP DATABASE Northwind TO DISK = "c:/backup/Northwind.bak"
procedure add(item,stack ,n,top)
if top>n then call stackfull endif
top=top+1
top=item
end add
procedure delete(item stack,n,top)
if top<0 then call stackempty endif
item=stack(top)
top=top-1
end delete
gerant[all/statement[...n]] to security_account[...n]
deny[all/statement[...n]] to security_account[...n]
rewoke{all/statement[...n]}from security_account[...n]
waitfor{dalay time|time time}