Visual Basic.NET
  Home arrow Visual Basic.NET arrow Simple Backup/Restore Utility With SQL-DMO...
Iron Speed
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Dedicated Servers 
Download TestComplete 
Windows Web Hosting
 
IBM® developerWorks 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
VISUAL BASIC.NET

Simple Backup/Restore Utility With SQL-DMO Using VB.NET
By: Jagadish Chaterjee
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 48
    2005-09-08

    Table of Contents:
  • Simple Backup/Restore Utility With SQL-DMO Using VB.NET
  • Understanding SQL-DMO Objects
  • Programming SQL-DMO using .NET
  • Backup/Restore utility using SQL-DMO with .NET
  • Understanding Backup and Restore processes

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
     
    ADVERTISEMENT

    Free Web 2.0 Code Generator! Generate data entry and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!

    Simple Backup/Restore Utility With SQL-DMO Using VB.NET
    (Page 1 of 5 )

    This article primarily introduces the concept of SQL-DMO together with a small and simple Backup/Restore utility developed using the .NET platform. It mainly focuses on the basics of SQL-DMO, its main objects and how to use them in .NET platform to design and develop MS SQL Server based database administration utilities/applications.
    A downloadable file for this article is available here.

    Introduction to SQL-DMO

    SQL-DMO uses the Microsoft® SQL Server™ ODBC driver to connect to and communicate with instances of SQL Server.  SQL-DMO clients require the SQL Server ODBC Driver, version 3.80 or later, which ships with SQL Server 2000.  All required SQL-DMO components are installed as part of an instance of the Microsoft® SQL Server™ server or client. SQL-DMO is implemented in a single dynamic-link library (DLL). We may develop SQL-DMO applications on either a client or a server.

    SQL Distributed Management Objects (SQL-DMO) is a collection of objects encapsulating the Microsoft® SQL Server™ database and replication management. SQL-DMO is a dual interface COM, in-process server implemented as a dynamic-link library (DLL). SQL-DMO encapsulates SQL Server components, presenting the attributes of the component piece to you as the properties of an object instance. We can alter the properties of the instance, or use object methods to automate SQL Server administration, including replication.

    An instance of SQL Server may be viewed as a collection of components.  These components may also include several processes or services of SQL Server.  An SQL-DMO object exposes the attributes of a Microsoft® SQL Server™ 2000 component to the other applications. The referenced component may be a new or existing database object, a replication or SQL Server Agent component, or could encapsulate a SQL Server management process.

    We interact with SQL-DMO objects with the help of the following members with respect to that that object:

    • Properties
    • Methods
    • Events

    As they are part of the fundamentals of dot net (or any OOPS) and not a part of SQL-DMO, I leave it to the programmer to understand their functionalities.

    Before proceeding further, let us grasp a small idea about the hierarchy of SQL-DMO objects.  For quick reference, I included a huge GIF file (as part of a downloadable file) of an SQL-DMO object tree extracted from SQL Server Books On Line.  I suggest you download and open it before proceeding to the next page. (See link above near the top of this page). 

    More Visual Basic.NET Articles
    More By Jagadish Chaterjee


       · Hello guys, this is my article on SQL-DMO together with VB.NET. You can start...
       · Tried to download the file for the article but the link doesn't seem to...
       · Hello, I fixed that link. Thank you for pointing it out to us :-)Mike
       · backup code is working perfectly , but the restor code is not working its giving...
       · please follow the "note" section of the article. Try to close Enterprise manager...
       · Dear Jagdish,This is a wonderful article! Can you kindly help for a similar kind...
       · Hai, thanks for your compliments. And thanks again for requesting me on...
       · Hi jagdish Have u released the article about replication which was asked by...
       · Hi JagdishNice article, but I am connecting to sql server using windows...
       · Hi Sita, This is palash. I have faced a similar problem like you. Did you find any...
       · DEAR SIR I IMPLEMENTED THT CODE BUT ITS NOT WORKING ,SO PLS SEND ME RELAVT CODE or...
       · Hi There,My Backup and restore code works fine but I have one problem.It...
       · This is wonderful artical.Can u help me to take the backuo of selected table(not...
       · This helps:oSQLServer.LoginSecure = true; oSQLServer.Connect("ServerName",...
       · Hi, Thanks for such a simple and useful utility. It is really cool. it works...
       · Can anyone help me with this problem?I want to restore selected backup which can...
       · The restore cannot be done if the database is being used. So if the datagrid uses...
       · This article is simply perfect! Short, Clear and concise. Thanks a lot..For...
       · Hi Sita and PalashI am Kulwinder Singh. I found out the solution for ur...
       · where is the link? i cant download the file.. please help me.
       · I am Rohit, I am using VB.Net. I am Beginner in .Net VS 2005. I want to know how...
       · can you give me the link to download this program
       · i am jerry can you give me link to download this program:)) thank
       · Hey Thanks For The code....!!Bi!
       · Hello.. i have got an error like "type SQLDMO.SQLServer is not defined" now what to...
       · Hello Mr. chaterjee and all friends,This article is great ! I m new to back up...
     

    VISUAL BASIC.NET ARTICLES

    - Types of Operators in Visual Basic
    - Operators
    - Understanding Custom Events using Visual Bas...
    - Polymorphism using Abstract Classes in Visua...
    - Shadowing using Shadows in Visual Basic.NET ...
    - Overloading and Overriding in Visual Basic.N...
    - More on Controlling Windows Fax Services Usi...
    - Programmatically Controlling Windows Fax Ser...
    - Focusing on Forms and Menus in Visual Basic
    - Manipulating Forms with the Windows Forms Li...
    - Basics of the Windows Forms Library
    - Forms, Controls, and Other Useful Objects
    - Implementing OOP to Develop Database Oriente...
    - Using Themes and Skins for Personalization w...
    - A Deeper Look at Personalization using Visua...

     
    Accelerating Trading Partner Performance
     
    Competing on Analytics
     
    Cost Effective Scaling with Virtualization and Coyote Point Systems
     
    Five Checkpoints to Implementing IP Telephony
     
    Hosted Email Security: Staying Ahead of New Threats
     




    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway