daily basis backup in express edition

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 1

Since SQL express has no SQL Agent you will need to script out a backup command and have it scheduled using windows scheduler.

i.e create a batch file and call sqlcmd to execute the backup script, the batch file itself would need to be scheduled in windows.

Jayanth Kurup[/url]

spaghettidba SSC Guru Points: 105732 More actions · Answer 2

This is a good SQLAgent replacement for Express edition:

Hope this helps.

Gianluca

-- Gianluca Sartori

shilpa.shankar87 Ten Centuries Points: 1084 More actions · Answer 3

Ten Centuries

Points: 1084

June 28, 2011 at 2:26 am

Thanks a lot jayanth, it worked fine.