Backing Up SQL 2005 Express

[ckissack]

All

I found this article useful for backing up SQL 2005 Express running locally if Plesk Backup doesnt cover it.

http://www.sqldbatips.com/showarticle.asp?ID=27

Also as part of getting it to work Surface Area Config will need to be changed to allow OLE Automation and xp_cmdshell

Regards

Colin

 

[Gris@]

you may do backup by osql utility
backup database databasename to disk="path to file"

 

[ckissack]

Hi

Thanks for the additional suggestion, but I did a search and can only find OSQL.EXE inside W2003 SP1 sqlrun.cab. It didnt install as part of SQL Express 2005.

Colin

 

[JackL]

This one will be quite enough for everything else:
"http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en"

John S.G.