从sql备份并保存在其他驱动器中... [英] backup from sql and save in other drive...

问题描述

每个人都支持????

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??

推荐答案

在你的存储过程中包含以下2个脚本，它会起作用..它会进行备份并恢复它。

Hi,

Include the below 2 scripts in your stored procedure and it will do the trick..it will take a backup and will restore it too.

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

1。首先在数据库中编写所有程序。

2.备份。

3.恢复数据库服务器中的备份。



您可以从以下链接找到的图示说明：



http://kb.eukhost.com/backup-and-restore-ms-sql-server-2008-database/ [ ^ ]



- Arindam

1. First write all your procedures in your database.
2. Take a backup.
3. Restore the backup in your database server.

Pictorial description you can find from the below link:

http://kb.eukhost.com/backup-and-restore-ms-sql-server-2008-database/[^]

- Arindam

这篇关于从sql备份并保存在其他驱动器中...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！