Click here to Skip to main content
12,443,996 members (39,549 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: ASP.NET
How to take back up of sql server7.0 and restore it from asp.net web project using vb code..i want to do it using two buttons . im using vb.ne 2008.
plz help its very urgent
thanks in advance
Ridan Khan
Posted 1-Jan-13 22:50pm
Updated 1-Jan-13 23:01pm
v3
Comments
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
 
good
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: http://www.developerfusion.com/tools/convert/csharp-to-vb/[^]) and it explains the pitfalls as you go though the process.
  Permalink  
Comments
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 asp.net. That code snippet and the article is good, but in asp.net 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 asp.net 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 | Mobile
Web02 | 2.8.160811.3 | Last Updated 2 Jan 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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