About Me

My photo
MCTS FOR SQL SERVER 2008 DOT NET PROGRAMMING WEB DESIGNING

Friday, 21 October 2011

BACKUP DEVICE IN SQL?


/*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