SQL Server 2008备份直接在网络驱动器上 [英] SQL server 2008 Backup direct on network drive

问题描述

我有2台服务器



Ex。 192.168.0.11和192.168.0.12



现在我想通过sql server直接从共享文件夹中的11到12服务器上进行数据库备份



如果有人知道这个，请帮助我。



谢谢

解决方案

< blockquote>查看链接

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/02/27/how-to-backup-sql-server-databases-to-a -mapped-drive.aspx [ ^ ]



净使用文档：

http：// technet .microsoft.com / zh-cn / library / bb490717.aspx& lt; / pre& gt;< / pre> [ ^ ]

我个人不会直接将备份带到网络驱动器。相反，我会分两个阶段进行：

• 将备份带到本地目录
• 将备份复制到远程目录

这样做的原因是，无论网络出现什么问题，备份始终都能正常进行，并且备份的持续时间不受网络的影响速度。



当然，将备份复制到远程服务器或其他安全的地方至关重要，因此我将复制操作包含在创建备份的作业中。这样就很容易设置错误通知等。

I have 2 server

Ex. 192.168.0.11 and 192.168.0.12

now I want take DB backup from 11 to on 12 server in sharing folder direct via sql server

Please if any one know this then help me.

Thanks

解决方案

see the link
http://blogs.msdn.com/b/sqlserverfaq/archive/2009/02/27/how-to-backup-sql-server-databases-to-a-mapped-drive.aspx[^]

Net use documentation:
http://technet.microsoft.com/en-us/library/bb490717.aspx&lt;/pre&gt;</pre>[^]

Personally I wouldn't take the backup directly to a network drive. Instead I'd do it in two phases:

• Take the backup to a local directory
• Copy the backup to remote directory

The reason for this is that this way the backup is always taken properly regardless of possible network problems and the duration of the backup isn't affected by the network speed.

Of course it's vital to copy the backup to the remote server or some other safe place so I'd include the copy operation to the job that creates the backup. This way it would be easy to set up the error notifications etc.

这篇关于SQL Server 2008备份直接在网络驱动器上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！