Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Professional
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Professional section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 8th, 2006, 12:13 PM
Authorized User
 
Join Date: Feb 2006
Location: Ahmedabad, Gujarat, India.
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to savan_thakkar Send a message via Yahoo to savan_thakkar
Default How to take SQL Server Database Backup via .NET??

Hi,
Can anyone tell me that How can I take the Backup of an SQL Server 2000
Database and store it on Disk...I want this to be done Programetically in VB.NET-ASP.NET application.

Savan
__________________
Savan
  #2 (permalink)  
Old February 9th, 2006, 08:40 AM
Registered User
 
Join Date: Nov 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,
Can anyone tell me that How can I take the Backup of an SQL Server 2000
Database and store it on Disk...I want this to be done Programetically in VB.NET-ASP.NET application.

Savan

  #3 (permalink)  
Old February 13th, 2006, 12:37 AM
Authorized User
 
Join Date: Dec 2005
Location: bangalore, karnataka, India.
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to g_vamsi_krish
Default

just like an update/delte write the backup command. it will automatically creates backup.

USE master
EXEC sp_addumpdevice 'disk', 'MyNwind_1',
   DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'

-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_1


vamsi
  #4 (permalink)  
Old February 15th, 2006, 06:38 AM
Authorized User
 
Join Date: Feb 2006
Location: Ahmedabad, Gujarat, India.
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to savan_thakkar Send a message via Yahoo to savan_thakkar
Default

I got this result when I executed _addumpdevice .

(1 row(s) affected) 'Disk' device added.

But there was no any .dat backup file generated..

Savan
  #5 (permalink)  
Old February 15th, 2006, 12:21 PM
Authorized User
 
Join Date: Dec 2005
Location: bangalore, karnataka, India.
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to g_vamsi_krish
Default

try by using this

BACKUP DATABASE MyNwind TO MyNwind_1

check wheather u r able to make a backup


vamsi
  #6 (permalink)  
Old February 16th, 2006, 01:22 PM
Authorized User
 
Join Date: Feb 2006
Location: Ahmedabad, Gujarat, India.
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to savan_thakkar Send a message via Yahoo to savan_thakkar
Default

Gr8..
That really worked fine...
Actually the first command was working fine but it did not generate any physical file on disk.
But then using "BACKUP DATABASE MyNwind TO MyNwind_1", it generated the Backup.
Thanks a lot for help...

Savan
  #7 (permalink)  
Old February 20th, 2006, 01:01 AM
Authorized User
 
Join Date: Dec 2005
Location: bangalore, karnataka, India.
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to g_vamsi_krish
Default

u r welcome.

vamsi
  #8 (permalink)  
Old February 22nd, 2006, 07:11 AM
Registered User
 
Join Date: Feb 2006
Location: surat, Gujarat, India.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hello everybody,

i have been searching for a way to take back of my access database from the web. can anyone tell me how it can be done...??

Thanks & Regards,
Ankesh Maradia

Thanks & Regards,
Ankesh Maradia
  #9 (permalink)  
Old February 22nd, 2006, 07:13 AM
Registered User
 
Join Date: Feb 2006
Location: surat, Gujarat, India.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Can any one plz help with the following prob spec.:

i need to copy the data present in existing access database to new access database and empty the existing one using asp.



Thanks & Regards,
Ankesh Maradia
  #10 (permalink)  
Old February 22nd, 2006, 08:01 AM
Wrox Technical Editor
 
Join Date: Dec 2005
Location: , , Canada.
Posts: 271
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Perhaps you should consider copying the original database then generating a new one.

- A.Kahtava
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How i can Backup and Restore Sql Server Database hamor ASP.NET 2.0 Professional 1 April 24th, 2007 07:03 AM
How to Backup database - SQL Server 2000 cancer10 SQL Language 2 March 1st, 2007 07:21 AM
SQL Server 2000 backup from command line vmaruv SQL Server 2000 3 February 3rd, 2005 07:54 PM
sql server database backup by script mateenmohd SQL Server 2000 4 July 6th, 2004 12:32 PM
SQL Server Backup Restore zaeem Classic ASP Databases 0 December 4th, 2003 09:02 AM



All times are GMT -4. The time now is 10:26 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.