/*i got a mail that HOW TO TAKE THE BACKUP OF THE DATABASE FROM USING FRONT END WEBAPPLICATION?
very simple,u juz need to create a backup device in ur database
*/
SYNTAX:-
EXEC sp_addumpdevice 'disk', 'testdevice', 'c:\dump\dump1.bak';
explanation:-
'disk'-- device type i.e tape or disk
'testdevice'--device name
'd:\databse\test.bak'--local path to save the backup file
No comments:
Post a Comment