在获取SQL备份方面需要帮助 [英] Need help in taking SQL backup

问题描述

嗨



我写下以下代码进行备份

Hi

I wrote the below code for taking the backup

If str = "backup" Then
               SaveFileDialog1.FileName = cmbdatabase.Text
               SaveFileDialog1.ShowDialog()
               Timer1.Enabled = True
               ProgressBar1.Visible = True
               Dim s As String
               s = SaveFileDialog1.FileName
               query("backup database " & cmbdatabase.Text & " to disk='" & s & "'")

但是当我选择时使用文件对话框的位置，它没有创建任何备份文件



请告诉我问题。



谢谢

But when i m selecting the location using file dialog, it''s not creating any backup file

Please tell me the problem.

Thank you

推荐答案

备份路径应该是服务器上的有效路径，而不是客户端（您提供客户端路径），备份命令在服务器上执行。

The backup path should be a valid path on the server and not on the client (you are giving a client side path), the backup command is executed on the server.

这篇关于在获取SQL备份方面需要帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！