<div>
You can create a backup of a SQL Server by running a TSQL command:<br />
<br />
sSQL = &quot;BACKUP DATABASE [databasename] TO DISK='C:\temp\backup.bak'&quot;<wbr /><br />
Connection.Execute(sSQL), , 128<br />
<br />
<br />

</div>


You can create a backup of a SQL Server by running a TSQL command:

sSQL = "BACKUP DATABASE [databasename] TO DISK='C:\temp\backup.bak'"
Connection.Execute(sSQL), , 128




<div>
That backup the db on the server but I need it to backup on the local computer.
</div>


That backup the db on the server but I need it to backup on the local computer.

<div>
In general, it is not recommended to backup (not to mention difficult to accomplish) using the standard SQL Backup. &nbsp;You are better off doing a backup to the server and then copying the backup to the local drive. &nbsp;Assuming you have permissiong, that is.
</div>


In general, it is not recommended to backup (not to mention difficult to accomplish) using the standard SQL Backup.  You are better off doing a backup to the server and then copying the backup to the local drive.  Assuming you have permissiong, that is.

<div>
<div class="content wysiwyg-content">
Backup the database from remotely<br />
<br />
Sometime users will need to send us their backup so we can review their data or fix it. It has been done for years using MS Access and we are now migrating over to MS SQL. &nbsp;Is it there syntax or something that I can write in VB6 to copy the database to the user machine then zip it up? In the past all we had to do was zip up the mdb file and this was possible because mdb file has to be in shared folder out on the server. <br />
<br />
<br />
I am open to any suggestions. 
</div>
</div>


Backup the database from remotely

Sometime users will need to send us their backup so we can review their data or fix it. It has been done for years using MS Access and we are now migrating over to MS SQL.  Is it there syntax or something that I can write in VB6 to copy the database to the user machine then zip it up? In the past all we had to do was zip up the mdb file and this was possible because mdb file has to be in shared folder out on the server. 


I am open to any suggestions. 

backup the db remotely via vb6

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.