ch16,SQL SERVER 2012中可管理性的改进--使用UI来完成到特定时间点的恢复
，前言
MS SQL SERVER 2012除了在增加了不少新功能外，在用户友好性以及可管理性方面也有不小的改进。
启动SSMS，随便点选一个数据库，右击，按如下路径，启动restore database窗口：
Task-->Restore-->Database:
单击"Database..."菜单，弹出如下窗口：
点击[TimeLine...]:
生成的SQL脚本：
USE [master]
BACKUP LOG [aa] TO DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\aa_LogBackup_2013-05-22_15-53-59.bak' WITH NOFORMAT, NOINIT, NAME = N'aa_LogBackup_2013-05-22_15-53-59', NOSKIP, NOREWIND, NOUNLOAD, NORECOVERY , STATS = 5
RESTORE DATABASE [aa] FROM DISK = N'E:\books\SQL Server books\Professional SQL Server 2012 Internals and Troubleshooting\Professional SQL Server 2012 Internals and Troubleshooting\aa.bak' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [aa] FROM DISK = N'E:\books\SQL Server books\Professional SQL Server 2012 Internals and Troubleshooting\Professional SQL Server 2012 Internals and Troubleshooting\aa.log' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [aa] FROM DISK = N'E:\books\SQL Server books\Professional SQL Server 2012 Internals and Troubleshooting\Professional SQL Server 2012 Internals and Troubleshooting\aa1.log' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5
RESTORE LOG [aa] FROM DISK = N'E:\books\SQL Server books\Professional SQL Server 2012 Internals and Troubleshooting\Professional SQL Server 2012 Internals and Troubleshooting\aa2.log' WITH FILE = 1, NOUNLOAD, STATS = 5
GO
1.jpg来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/101629/viewspace-761738/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Tempdb latch竞争的优化
- SQL Server Architecture--PART III，基本的UPDATE处理流程
- SQL Server Architecture--PART II，基本的SELECT查询流程
- sql server 2012--集群采用多数节点的方式加Servercore
- ch15,Delivering a SQL Server Health Check--PART 5
- ch15,Delivering a SQL Server Health Check--PART 4
- ch15,Delivering a SQL Server Health Check--PART 3
- ch15,Delivering a SQL Server Health Check--PART 2
- ch15,Delivering a SQL Server Health Check--PART 1
- 使用窗口函数解决实际问题---虚拟数字辅助表
