Welcome to my blog!

Hi! My name is Resnef

Thank you for visiting my blog. I hope you'll get something helpful here. Please subscribe also to my Youtube Channel.

Looking for something?

What Can I Find Here?

Subscribe to this blog!

Receive the latest posts by email. Just enter your email below if you want to subscribe!

Enter your email address:

Delivered by FeedBurner


Backup and Restore SQL Database within Your Application



    IDE: Microsoft Visual Studio 2008/2010/2012
    Project Type: Visual Basic - Windows
    Database: Microsoft SQL Server 2005
    OS Compatibility: Windows XP, Vista, 2007 and 2008
    Additional References:  Microsoft.SqlServer.ConnectionInfo
                                          Microsoft.SqlServer.Management.Sdk.Sfc
                                          Microsoft.SqlServer.Smo


A client once asked me: 'is there a way to backup and restore the database aside from doing it on the SQL Management Application window? And I answered him 'Yes. There is.'

You can do it within your project to have a backup and restore form inside the application that will do the process. This will make the task easy to make a regular backup of the database.

  

Subscribe to: Comments (Atom)