说明：由于本人要还原的数据库比较大，所以采用CMD命令脚本方式
一.备份数据库，生成sql脚本备用
1. 右击数据库 --> 任务 --> 生成脚本。
2. 在生成脚本的“选择对象”步骤选择“编写整个数据库及所有数据库对象的脚本选项”。下一步。
搜索
文章分类
最新文章
- [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
- [10/12]MssqlServer数据库文件降级(如sql2008降到sql2005)
- [10/10]镞犳硶鏄剧ず椤甸溃锛屽洜涓哄彂鐢熷唴閮ㄦ湇锷″櫒阌欒?銆
- [08/28]任务管理 windows logon user interface host 进程 内存占用高
- [08/08]mp4格式 chrome浏览器播放不了 火狐可以播放
- [06/03]HP DL160 G6 服务器安装步骤
- [05/12]叶子分页 传递参数
- [03/03]数据库“XXX”的事务已满，原因为：“LOG_BACKUP”
- [02/02]mssql 自动回收内存
- [01/30]js 提交按钮
- [01/28]批量搜索文件
文章归档
- 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)
最新评论