SQL Server 2005 Express Question 2

[Apollo21]

Will the management studio be able to conduct scheduled automated backups of databases in 2005 express? I have just gotten this request out of the blue. I need to know the answer and do not have the time to download all the free peices and find out. Can anyone help me?

Thank you in advance.

[I know the alternative would be to create my own t-sql statements and execute them via a scheduler] I would like not to have to do that for once...] - Thanks.

 

[gmmastros]

Unfortunately, no.

Automated backups occur because of the SQL Server Agent which is another service installed with the 'paid' version of SQL Server. SQL Server Express does not include this service. You're on your own for creating backups (or any other scheduled task).

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mrdenny]

This article should be able to help you out.

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1307822,00.html#

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog