从sql备份并保存在其他驱动器中...

本文介绍了从sql备份并保存在其他驱动器中...的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

每个人都支持????

i拥有sql 2008的数据库

i想创建一个大步程序或者你认为更好的一切

从我的数据库备份

并保存在其他驱动器中

我该怎么办？

hi every body sup??!
i have database with sql 2008
i wanna create a strode procedure or everything you think is better for
backup from my database
and save that in other drives
how can i do this??

推荐答案

BACKUP DATABASE [ReportServer] TO  DISK = N'H:\Backup\ReportServer.bak' WITH NOFORMAT, NOINIT,  NAME = N'ReportServer-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO


RESTORE DATABASE [ReportServer] FROM  DISK = N'H:\Backup\ReportServer.bak' WITH  FILE = 1,  NOUNLOAD,  REPLACE,  STATS = 10
GO

快乐编码..

问候

anurag

Happy Coding..

regards
anurag