Backup Transaction Log

Mar 18, 2008 at 10:12 PM
Hi,

is there a way to backup Transaction Log using Express Maint?

Alex
Coordinator
Mar 20, 2008 at 7:11 PM
Sure. To backup the log you just need to specify LOG for the -T parameter e.g. to backup the log for Northwind on a standard SQL Express instance use the following command

expressmaint -S (local)\SQLExpress -D Northwind -T LOG -R c:\reports -RU DAYS -RV 1 -B c:\backups -BU DAYS -BV 1


AlexanderZeitler wrote:
Hi,

is there a way to backup Transaction Log using Express Maint?

Alex

Mar 21, 2008 at 6:46 PM
Thanks

Alex


jaspersmith wrote:
Sure. To backup the log you just need to specify LOG for the -T parameter e.g. to backup the log for Northwind on a standard SQL Express instance use the following command

expressmaint -S (local)\SQLExpress -D Northwind -T LOG -R c:\reports -RU DAYS -RV 1 -B c:\backups -BU DAYS -BV 1