Click here to Skip to main content
13,559,672 members
Rate this:
Please Sign up or sign in to vote.
See more:
How to take back up of sql server7.0 and restore it from web project using vb code..i want to do it using two buttons . im using 2008.
plz help its very urgent
thanks in advance
Ridan Khan
Posted 1-Jan-13 22:50pm
Updated 1-Jan-13 23:01pm
Orcun Iyigun 2-Jan-13 5:00am
It can be urgent for you but not CP community you just need to be patient...
Zoltán Zörgő 2-Jan-13 5:06am
Back up of sql server??? All of it? Really? Not just a concrete list of databases?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Have a look at this: Backing up an SQL Database in C#[^] - it is in C#, but the code should be easily translated (see here:[^]) and it explains the pitfalls as you go though the process.
Zoltán Zörgő 2-Jan-13 7:19am
Sorry I had to downvote your answer, but you have disregarded an important aspect of the question: from That code snippet and the article is good, but in there are several things to be considered besides the ones in the article:
- Who will be the user running that code: the authenticated one, the application pool user, a third one? How to change user context or spawn a process?
- How to grant the necessary privileges to that user without affecting the security of the server?
- How long it will take compared with the execution timeout?
- How to get detailed feedback, eventually how to react?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Cookies | Terms of Service
Web04-2016 | 2.8.180527.1 | Last Updated 2 Jan 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100