• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

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

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
Mohamadi
Asked:
Mohamadi
2 Solutions
 
Ivanov_GCommented:
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
 
Amir AzhdariCommented:
0
 
MohamadiAuthor Commented:
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

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now