 |
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
February 8th, 2006, 12:13 PM
|
|
Authorized User
|
|
Join Date: Feb 2006
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
February 9th, 2006, 08:40 AM
|
|
Registered User
|
|
Join Date: Nov 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
February 13th, 2006, 12:37 AM
|
|
Authorized User
|
|
Join Date: Dec 2005
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
February 15th, 2006, 06:38 AM
|
|
Authorized User
|
|
Join Date: Feb 2006
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
February 15th, 2006, 12:21 PM
|
|
Authorized User
|
|
Join Date: Dec 2005
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
try by using this
BACKUP DATABASE MyNwind TO MyNwind_1
check wheather u r able to make a backup
vamsi
|
|
February 16th, 2006, 01:22 PM
|
|
Authorized User
|
|
Join Date: Feb 2006
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
February 20th, 2006, 01:01 AM
|
|
Authorized User
|
|
Join Date: Dec 2005
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
u r welcome.
vamsi
|
|
February 22nd, 2006, 07:11 AM
|
|
Registered User
|
|
Join Date: Feb 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
February 22nd, 2006, 07:13 AM
|
|
Registered User
|
|
Join Date: Feb 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
February 22nd, 2006, 08:01 AM
|
|
Wrox Technical Editor
|
|
Join Date: Dec 2005
Posts: 271
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Perhaps you should consider copying the original database then generating a new one.
- A.Kahtava
|
|
|
