<div>
P.S. and connectDB method opens connection G_Connection <br />

</div>


P.S. and connectDB method opens connection G_Connection


<div>
<div class="content wysiwyg-content">
Hii All , <br />
I want to give a backup &amp;&nbsp;restore utility for my appliaction . <br />
Application should be able to backup the database<br />
I use VB 6.0 , SQL Server 2000 . SQL Server Anuthentication mode. <br />
<br />
My main concern is dump file should be password Protected . So that no one should not be able to restore that File to somewhere &amp;&nbsp;can see my DB Structure <br />
<br />
Thanks <br />
rahulbagal<br />
<br />
<br />

</div>
</div>


Hii All , 
I want to give a backup & restore utility for my appliaction . 
Application should be able to backup the database
I use VB 6.0 , SQL Server 2000 . SQL Server Anuthentication mode. 

My main concern is dump file should be password Protected . So that no one should not be able to restore that File to somewhere & can see my DB Structure 

Thanks 
rahulbagal




Backup SQL Server Database from Visual Basic

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.