Our Training Programs

All contents are copyright of their authors.

how to get database backup

how to get database backup

yesubabu k

9yAsked Apr 1, 2017, 1:34 AM712Windows Forms

Dear Sir

i am developing windows application using c# with sql server 2005

for that i have to create one more option in that application

i.e when i login into my application it automatically raise question "do you want data base backup" ?

if the user clicks ok its take database backup then strores in d drive

so kindly help me to complete this task

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Jitendra Shekhawat9y ago
Back up a database
1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
2. Expand Databases, and either select a user database or expand System Databases and select a system database.
3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.
http://www.serverintellect.com/support/sqlserver/database-backup-ssmse/
Amit Gupta9y ago
1. BACKUP DATABASE YourDatabase TO DISK = 'D:\\YourDatabase.Bak';