Backup/Recovery of DATABASE

[sanjay gupta]

I want to take backup/restore of SQL database from asp, can you help me to do so?

[phpmaet]

hi,
you should use the following queries in your asp code.

BACKUP LOG <dbname>
TO DISK = 'c:\backup\TLOG .bak'
WITH NO_TRUNCATE



RESTORE DATABASE <dbname>
FROM DISK = 'c:\backups\nwi nd\nwind_diff.b ak'
WITH RECOVERY

thanks