I have SQL express installed on 2 different machines. Each SQL express install has one Database. I also have a different server running SQL 2008 R2 enterprise.
Server A (SQL Express with database DB1)
Server B (SQL Express with database DB2)
Server C (SQL Server 2008 Enterprise)
On server A, I need to schedule a task to copy DB1 nightly to Server C and also on server B I need to do the same copy DB2 nightly to Server C.
DB1 and DB2 on Server C can be overwritten nightly.
How do I accomplish this?