用这个语句的阿 RESTORE DATABASE 利于USE AdventureWorks GO BEGIN TRANSACTION ListPriceUpdate WITH MARK 'UPDATE Product list prices' GOUPDATE Production.Product SET ListPrice = ListPrice * 1.10 WHERE ProductNumber LIKE 'BK-%' GOCOMMIT TRANSACTION ListPriceUpdate GO-- Time passes. Regular database -- and log backups are taken. -- An error occurs. USE master GORESTORE DATABASE AdventureWorks FROM AdvWorks1 WITH FILE = 3, NORECOVERY GORESTORE LOG AdventureWorks FROM AdvWorks1 WITH FILE = 4, STOPATMARK = 'ListPriceUpdate'
还原我就不用说了吧,差不多。
下面的示例将 pubs 中的两个文件附加到当前服务器。EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'
RESTORE
还原使用 BACKUP 命令所做的备份。有关数据库备份和还原操作的更多信息,请参见备份和还原数据库。语法
还原整个数据库: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 ] ]
]还原数据库的部分内容:RESTORE DATABASE { database_name | @database_name_var }
< file_or_filegroup > [ ,...n ]
[ FROM < backup_device > [ ,...n ] ]
[ WITH
{ PARTIAL }
[ [ , ] 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 ]
[ [ , ] NORECOVERY ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] REPLACE ]
[ [ , ] RESTRICTED_USER ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]具体说明见帮助.
有达人路过的话,向达人们学习下
GO
BEGIN TRANSACTION ListPriceUpdate
WITH MARK 'UPDATE Product list prices'
GOUPDATE Production.Product
SET ListPrice = ListPrice * 1.10
WHERE ProductNumber LIKE 'BK-%'
GOCOMMIT TRANSACTION ListPriceUpdate
GO-- Time passes. Regular database
-- and log backups are taken.
-- An error occurs.
USE master
GORESTORE DATABASE AdventureWorks
FROM AdvWorks1
WITH FILE = 3, NORECOVERY
GORESTORE LOG AdventureWorks
FROM AdvWorks1
WITH FILE = 4,
STOPATMARK = 'ListPriceUpdate'