SQL Data Backup - Visual Basic , VB.NET

	Find Code:
Home : Code : Forums : Submit : Mailing List : About : Contact

All

VB.NET

ASP.NET

C#

Snippets

Popular

Forums

Articles

Tips

Links

Books

Contest

SQL Data Backup
Author: Syed Hasan Afzal
E-mail: Click to e-mail author
Website: http://shafzal.mailas.com
Submitted: 6/4/2005
Version: VB6
Compatibility: VB6
Category: Databases
Views: 21608
Stored procedure for database backup creation in SQL Server.
Declarations:
'SQL Stored Procedure for creating Database Backup in Hard Disk. You can use this procedure from Visual Basic (Front End) to do the backup from Interface.
Code:
--/HARD DISK BACKUP/ USE <Database Name> drop procedure DISKBACKP go create procedure DISKBACKUP @temp_dump varchar(255), @database varchar(255) as set @temp_dump='Backup Location' set @database='Database Name' backup database Database Name to disk='Backup Location' with init --END HARD DISK BACKUP--