SQLServer2008如何copydatabase--https://www.2cto.com/database/201411/351603.html
来源:互联网 发布:淘宝旗舰店都是真的吗 编辑:程序博客网 时间:2024/05/01 07:12
xjh测试有效
- 首页 >数据库 >SQL Server > 正文
- SQLServer2008如何copydatabase
- 2014-11-12 09:22:27 个评论 来源:tianshijianbing1989的专栏
- 收藏 我要投稿
SQL Server 2008如何copy database:
方法一:使用Microsoft SQL Server Management Studio中的Copy Database Wizard来辅助完成。(很容易失败)
方法二:采取Backup/Restore的方式(推荐)
a.备份数据库到磁盘
BACKUP
DATABASE
Source_Database
TO
DISK =
'D:\Backup\Source_Database.bak'
WITH
FORMAT;
RESTORE FILELISTONLY
FROM
DISK =
'D:\Backup\Source_Database.bak'
;
CREATE
DATABASE
Target_Database;
/*
利用bak恢复数据库,强制还原(REPLACE)
STATS = 10 每完成10%显示一条记录
Source_Database和Source_Database_log是上面D:\Backup\Source_Database.bak里的逻辑文件
*/
RESTORE
DATABASE
Target_Database
FROM
DISK=
'D:\Backup\Source_Database.bak'
WITH
MOVE
'Source_Database'
TO
'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Target_Database.mdf'
,
MOVE
'Source_Database_log'
TO
'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Target_Database_log.ldf'
,
STATS = 10,
REPLACE
restore database [DB_Product_EmissionTrade_Version]
from disk = 'D:\DB_Product_EmissionTrade_Version3.0_20171024.bak'
with nounload, replace, stats = 10,
move 'Platformv32' to 'D:\ProgramFiles\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DB_Product_EmissionTrade_Version.mdf',
move 'Platformv32_log' to 'D:\ProgramFiles\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DB_Product_EmissionTrade_Version.LDF'
go
DB_Product_EmissionTrade_Version-->新数据库名称
D:\DB_Product_EmissionTrade_Version3.0_20171024.bak -->备份文件名
Platformv32-->源文件名 通过sql语句查询可以知道
- SQLServer2008如何copydatabase--https://www.2cto.com/database/201411/351603.html
- http://www.2cto.com/database/201408/327315.html
- ORACLE中DBMS_SQL的用法——http://www.2cto.com/database/201209/156873.html
- Linux下C语言执行MySQL语句 http://www.2cto.com/database/201312/268374.html
- 使用HTTP协议访问网络 原网址https://www.2cto.com/kf/201701/552932.html
- 留作笔记,原文链接:https://www.2cto.com/kf/201607/529682.html
- http://www.2cto.com/kf/201112/115476.html
- http://www.2cto.com/kf/201205/131945.html
- http://www.2cto.com/kf/201402/280576.html
- http://www.2cto.com/kf/201410/344061.html
- http://www.2cto.com/os/201202/118033.html
- http://www.2cto.com/kf/201311/255432.html
- 优化exp/imp导入导出速度大全__www.2cto.com/database/201308/238175.html
- android ContentResolver详解 http://www.2cto.com/kf/201207/144022.html
- ASP.NET MVC HtmlHelper用法大全(转:http://www.2cto.com/kf/201105/90985.html)
- nginx source:http://www.2cto.com/os/201109/104264.html
- inux的安装和启动流程(http://www.2cto.com/os/201208/145165.html)
- argparse解析器 转自http://www.2cto.com/kf/201208/149418.html
- 【java web】实现form表单提交时弹出提示框确认功能
- find命令的扩展
- CentOS7.2 安装Pyhton3.6.1 ,与python2.7 共存
- 获取水仙花数
- Robots Crossing River hiho一下第175周
- SQLServer2008如何copydatabase--https://www.2cto.com/database/201411/351603.html
- PS流的格式和解析总结
- 小程序幻灯片组件swiper使用。
- 阿里云网站部署域名
- XMLHttpRequest异步获取文件流
- 性能分析工具JMH(一)
- Error: Unable to access jarfile resin-desktop-dashboard-8090/bin/../lib/resin.jar
- kotlin学习笔记(四)
- 【Java作业】2017.11.04 / 11.05