如何恢复"追加到媒体"的备份
解决方案 »
- 简单的更新脚本问题
- 求一条功能相同的sql语句....大侠们...着急啊!
- 一个关于查询的问题 ,同一个表的内连接查询,高手来帮帮忙啊
- 问一个概念上面的问题,关于临时表、全局临时表、物理表、表变量
- 求一條語句刪除重復行中的其中一行?
- 在Windows 2003下,sql server 2005总出现调试窗口,为什么?如何调试?谢谢!
- 不能使用 Select Into,可是我可以Create Table,该怎么办呢?
- 请教二个表的统计问提!
- 请问各位高手,insert into 子句中为什么不支持排序?
- 对于给定登陆和退出时间,要怎么统计每个时间段的使用情况呢?
- 问个sql 的insert的问题
- 高分求SQL语句!!!!!!!!!!!!
还原整个数据库:RESTORE DATABASE { database_name | @database_name_var }
[ FROM < backup_device > [ ,...n ] ]
[ WITH
[ RESTRICTED_USER ]
[ [ , ] FILE = { file_number | @file_number } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ]
[ ,...n ]
[ [ , ] KEEP_REPLICATION ]
[ [ , ] { NORECOVERY | RECOVERY | STANDBY = undo_file_name } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] REPLACE ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]
--以下代码简单地演示了如何进行文件组的备份及还原(在还原时,模拟了丢失第二次文件组备份文件的情况)。--创建测试数据库CREATE DATABASE dbON PRIMARY( NAME='db_data', FILENAME= 'c:\db_data.mdf'),FILEGROUP db_fg1( NAME = 'db_fg1_data', FILENAME = 'c:\db_fg1_data.ndf'),FILEGROUP db_fg2( NAME = 'db_fg2_data', FILENAME = 'c:\db_fg2_data.ndf')LOG ON( NAME='db_log', FILENAME ='c:\db.ldf')GO --在文件组db_fg1上创建表,并单独创建该文件组的备份CREATE TABLE db.dbo.tb(id int) ON db_fg1BACKUP DATABASE db FILEGROUP='db_fg1' TO DISK='c:\db_fg1.bak' WITH FORMATGO 在其他文件组上创建表 CREATE TABLE db.dbo.ta(id int) ON [PRIMARY]CREATE TABLE db.dbo.tc(id int) ON db_fg2INSERT db.dbo.tb SELECT id FROM sysobjects--备份每个文件组,并且备份事务日志BACKUP DATABASE db FILEGROUP='PRIMARY' TO DISK='c:\db_primary.bak' WITH FORMATBACKUP DATABASE db FILEGROUP='db_fg1' TO DISK='c:\db_fg1_new.bak' WITH FORMATBACKUP DATABASE db FILEGROUP='db_fg2' TO DISK='c:\db_fg2.bak' WITH FORMATBACKUP LOG db TO DISK='c:\db_log.bak' WITH FORMATGO --删除数据库DROP DATABASE dbGO --从文件组备份中恢复数据RESTORE DATABASE db FILEGROUP='PRIMARY' FROM DISK='c:\db_primary.bak' WITH NORECOVERY,REPLACERESTORE DATABASE db FILEGROUP='db_fg1' FROM DISK='c:\db_fg1.bak' WITH NORECOVERYRESTORE DATABASE db FILEGROUP='db_fg2' FROM DISK='c:\db_fg2.bak' WITH NORECOVERYRESTORE LOG db FROM DISK='c:\db_log.bak' WITH RECOVERYSELECT COUNT(*) FROM db.dbo.tbGO