SQL Server Express nu beneficiaza de SQL Server Agent.

Se pot realiza solutii proprii ca de exemplu:

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

- o aplicatie rulata periodic de task manager care sa ruleze scripturi de copiere.

- triggere pe tabele care sa copieze automat datele.

Ca ultima solutie puteti achizitiona soft care sa faca asta: http://www.valesoftware.com/products-express-agent.php

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro