说明：由于本人要还原的数据库比较大，所以采用CMD命令脚本方式
一.备份数据库，生成sql脚本备用
1. 右击数据库 --> 任务 --> 生成脚本。
2. 在生成脚本的“选择对象”步骤选择“编写整个数据库及所有数据库对象的脚本选项”。下一步。
搜索
文章分类
最新文章
- [11/16]pfx证书文件生成
- [10/06]事务日志已满,原因为“LOG_BACKUP”。
- [08/19]php环境调试总结
- [08/14]记录一次winserver2012 IIS劫持处理操作过程
- [07/19]服务器内存条别乱插
- [05/28]win10 thinkpad T14s 型号笔记本突然找不到麦克风了
- [05/09]数据库文件无法移动时 用下面的bat命令
- [05/08]hyper-v虚拟机里无法安装SQL的问题
- [05/08]windows系统安装经验总结
- [05/08]SQL SERVE复制需要有实际的服务器名称才能连接到服务器
- [04/21]打开谷歌浏览器 弹出新的hao.360.com的处理方法
- [04/08]Cls_Page_html.asp
- [03/15]MSSQL无法启动
- [02/18]PC站自动跳转到WAP站对应的页面（HTML5+JS）
- [10/16]高版本的SQLServer2016 还原到低版本的SQL Server2012
文章归档
- 2024 November (1)
- 2024 October (1)
- 2024 August (2)
- 2024 July (1)
- 2024 May (5)
- 2024 April (2)
- 2024 March (1)
- 2024 February (1)
- 2023 October (3)
- 2023 August (2)
- 2023 June (1)
- 2023 May (1)
- 2023 March (1)
- 2023 February (1)
- 2023 January (3)
- 2022 October (8)
- 2022 September (2)
- 2022 June (1)
- 2022 May (1)
- 2022 March (2)
- 2022 January (3)
- 2021 September (1)
- 2021 January (2)
- 2020 May (1)
- 2020 March (2)
- 2020 February (1)
- 2020 January (7)
- 2019 December (4)
- 2019 August (2)
- 2019 July (4)
- 2019 June (4)
- 2019 January (1)
- 2018 December (1)
- 2018 September (1)
- 2018 August (1)
- 2018 April (2)
- 2018 February (1)
- 2018 January (1)
- 2017 November (1)
- 2017 August (2)
- 2017 April (1)
- 2017 March (5)
- 2017 January (1)
- 2016 December (1)
- 2016 September (1)
- 2016 August (1)
- 2016 July (1)
- 2016 April (1)
- 2016 March (6)
- 2016 January (5)
- 2015 November (1)
- 2015 October (3)
- 2015 September (7)
- 2015 July (8)
- 2015 June (8)
- 2015 May (6)
- 2015 April (5)
- 2015 March (1)
- 2015 January (1)
- 2014 December (3)
- 2014 October (2)
- 2014 September (3)
- 2014 August (3)
- 2014 June (1)
- 2014 May (1)
- 2014 April (1)
- 2014 March (3)
- 2014 February (5)
- 2014 January (4)
- 2013 September (2)
- 2013 July (6)
- 2013 June (8)
- 2013 May (6)
- 2013 April (5)
- 2013 March (3)
- 2013 February (1)
- 2013 January (6)
- 2012 December (3)
- 2012 November (3)
- 2012 October (2)
- 2012 September (1)
- 2012 July (5)
- 2012 June (2)
- 2012 May (1)
- 2012 April (3)
- 2012 March (3)
- 2012 February (2)
- 2012 January (1)
- 2011 December (4)
- 2011 October (2)
- 2011 September (3)
- 2011 August (5)
- 2011 July (3)
- 2011 June (7)
- 2011 May (6)
- 2011 April (7)
- 2011 March (11)
- 2011 February (7)
- 2011 January (5)
- 2010 December (11)
最新评论