Showing posts with label thethe. Show all posts
Showing posts with label thethe. Show all posts

Thursday, March 8, 2012

Backup and zip the Transaction log file

Once the procedure is executed the database transaction log would be backed up and zipped with a blank text file which has the
the current date DD/MM/yyyy as the text file name

exec ('exec master..xp_cmdshell ''dtsrun /SItchy /Usa /PF!gl@.59b#fl@.#f!uxr /N'+@.defaultCSVFeed_DTS+''' ')
exec ('exec master..xp_cmdshell ''E:\Inetpub\wwwroot\BIASS\wzzip.exe E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.zip E:\Inetpub\wwwroot\'+@.SiteFolder+'\Admin\BIA_DataF eed\'+@.FileName+'.'+@.defaultCSVFeed_FileType+''' ')

Pls let me know how can i zip the backup file with a blank text file with the date as the file name of the blank text file...hey... its URGENT.... pls can anybody help me on this...... :(