Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Unanswered: Backup of SQL Database using VB 6.0

    hi all

    Please help me

    I want to know how can I take the backup of my database which I've made in SQL Server by using VB as a front end tool.

    If any 1 of u can please mail me, I would be thankful . My email address is love1best@yahoo.com

    JamalJan

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Your VB could send an SQL script containing the BACKUP command.

    blindman

  3. #3
    Join Date
    Sep 2003
    Posts
    3
    Originally posted by blindman
    Your VB could send an SQL script containing the BACKUP command.

    blindman

    how ?
    Pls Explain. If anyone can tell me the codes, I'll be really thankful.


    Thanking in Advance.

    JamalJan

    [love1best@yahoo.com]

  4. #4
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    From ASP:

    set execommand = Server.CreateObject("ADODB.Command")
    execommand.CommandText = "backup database test_db to disk='f:\backup\test_db.bak'"
    execommand.execute
    set rs=nothing
    set execommand=nothing

    For VB it is almost the same...

  5. #5
    Join Date
    Sep 2003
    Posts
    3
    Originally posted by snail
    From ASP:

    set execommand = Server.CreateObject("ADODB.Command")
    execommand.CommandText = "backup database test_db to disk='f:\backup\test_db.bak'"
    execommand.execute
    set rs=nothing
    set execommand=nothing

    For VB it is almost the same...

    thanks

    Jani

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •