This stored procedure is useful ..when u will take a backup of database from front end(from ur application)
Just pass the databse name to stored procedure...it will take back on ur given path... which is given in stored procedure.
CREATE procedure DBbak(@dbname varchar(50))
as
DECLARE @path varchar(1000)
set @path =replace(replace(Convert(varchar(50),getDate(),9),' ','-'),':','-')
set @path = 'D:\sandeep\DataBackup\'+@dbname+'BACKUP ON'+@path+'.bak'
print @path
BACKUP DATABASE @dbname
TO DISK=@path
WITH FORMAT
|
No responses found. Be the first to respond and make money from revenue sharing program.
|