Solved

Controlling all of the backuping and restoring proccess of MSSQL from Delphi

Posted on 2004-10-23
184 Views
Last Modified: 2010-04-05
Hi
becuase users of my applications are not familiar with MSSQL, so i want to backup and restore mdf file by my application.
is there any full source code of this porccess?
thanks in advance
NIMA
0
Question by:Mohamadi
    3 Comments
     
    LVL 12

    Accepted Solution

    by:
    Backup the database:
    BACKUP DATABASE Database_Name to disk='C:\DatabaseName_backup.bak'

    Restore
    RESTORE DATABASE Database_Name from disk='C:\DatabaseName_backup.bak'

    execute the above statements as SQL where you change the Database_Name and the path for the backup...
    0
     
    LVL 6

    Assisted Solution

    by:Amir Azhdari
    0
     

    Author Comment

    by:Mohamadi
    sorry that i was too late :(
    I was in an official journey where i do not have access to the internet.
    now i see that negative action has been added to my profile. what should i do.
    i did not accept the question for that time becuase i said "FULL CONTROL OVER BACKUP AND RESTOR PROCCESS".
    i mean even showing progressbar during backup & restore operation. actually i want to create a form for both operations just like the one in MASSQL.
    I am very sorry that i was too late. tell me what should i do to correct my mistake.
    tahnks.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone. Privacy Policy Terms of Use

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
    In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    875 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now