SQLSafe Freeware Edition – Log Backup

So, back to the Freeware Edition of SQL Safe.

In order to create a log backup using the extended stored procedures, the script is almost identical to the one used for a Full Backup, but with one simple change which you can see on line 5 in the code below

 

EXEC [master].[dbo].[xp_ss_backup]
@database = 'AdventureWorks',
@filename = 'D:\Backup\AdventureWorks.safe',
@backuptype = 'Log'

 

And also, not forgetting the additional parameter if you are working on a named instance of SQL Server rather than the default

 

EXEC [master].[dbo].[xp_ss_backup]
@database = 'AdventureWorks',
@Instancename = 'Instance',
@filename = 'D:\Backup\AdventureWorks.safe',
@backuptype = 'Log'

Advertisement