How to back up and resotre in windows applicaiton using C#?
I am developing windows application using C# and MS sql server.
Now i have completed the project except how to backup and restore.
now i want to have a backup and restore buttons.
when i click.. backup button i will have an option where to put the backup
or a mechanism to take schedule backup then each back up is different, not replacing the previous backup.
Restore: when i click restore i will have an option from where can i restore.
please please i really need how to take backup and restore from windows interface.
thank you for your all helps.
Re: How to back up and resotre in windows applicaiton using C#?
Are you saying, without actually saying, that you want to backup and restore the SQL Server database? If so then it's a simple matter of executing an appropriate SQL statement against the server using a SqlCommand, just as you would for any SQL statement. The SQL Server documentation can provide you with the appropriate syntax for a BACKUP DATABASE statement and a RESTORE DATABASE statement.