A data-driven software application should be secured from unauthorized users that might destroy, alter, corrupt or steal the data stored in the database. Including a user login before a user could access the application's main form and tasks can be a way to prevent unauthorized user. Another way to prevent this is to make a backup of the data.
In this post I made a video on how to back up database in your VB.Net project without using the Microsoft SQL Server Backup feature which makes it difficult to do most especially to those who are not used with SQL Server database management.
To make the project working, you should consider these things first.
IDE: Microsoft Visual Studio 2008/2010/2012
Project Type: Visual Basic - Windows
Database: Microsoft SQL Server 2005/ 2008
OS Compatibility: Windows XP, Vista, 2007 and 2008
Additional References: Microsoft.SqlServer.ConnectionInfo
Microsoft.SqlServer.Management.Sdk.Sfc
Microsoft.SqlServer.Smo
No comments:
Post a Comment