Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


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

Posted on 2004-10-23
Medium Priority
Last Modified: 2010-04-05
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
Question by:Mohamadi
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 12

Accepted Solution

Ivanov_G earned 252 total points
ID: 12391904
Backup the database:
BACKUP DATABASE Database_Name to disk='C:\DatabaseName_backup.bak'

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...

Assisted Solution

by:Amir Azhdari
Amir Azhdari earned 248 total points
ID: 12393274

Author Comment

ID: 13527128
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.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

610 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