SQLServer2008 Express数据库备份和还原

最新推荐文章于 2023-02-09 10:17:21 发布

iteye_15391

最新推荐文章于 2023-02-09 10:17:21 发布

阅读量735

点赞数

分类专栏：数据库文章标签：数据库

本文链接：https://blog.csdn.net/iteye_15391/article/details/82452232

版权

数据库专栏收录该内容

12 篇文章 0 订阅

订阅专栏

BACKUP DATABASE [AdventureWorks] TO
DISK = N'\\nas\Backup\L40\SQL2005\AdventureWorks_backup_200702120215.bak'
WITH NOFORMAT, NOINIT, NAME = N'AdventureWorks-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10

RESTORE DATABASE [AdventureWorksNew]
FROM DISK = N'\\nas\Backup\L40\SQL2005\AdventureWorks_backup_200702120215.bak'
WITH FILE = 1,
MOVE N'AdventureWorks_Data' TO N'C:\Data\MSSQL.1\MSSQL\Data\AdventureWorksNew_Data.mdf',
MOVE N'AdventureWorks_Log' TO N'C:\Data\MSSQL.1\MSSQL\Data\AdventureWorksNew_Log.ldf',
NOUNLOAD, STATS = 10

http://msdn.microsoft.com/zh-cn/library/ms165673(v=sql.105).aspx