Here is my problem, my website is using a SQL server Express Database which Microsoft has toned down on a lot of its replication capabilities. However I have the full Enterprise version of SQL Server 2005 running locally - so I am looking for a way to create a backup plan in the Management Console that will append any new data from my remote server to my local database at whatever time interval I have scheduled - does anyone know of a way of doing this, or can someone please point me in the right direction.

I just started working with '05 and don't see how this can be done so I at the least have the previous days data backed up locally.

Any pointers would be greatly appreciated...

The way to schedule backups in SQL Express is to use the Windows Scheduler. Have it call a cmd file. That cmd file should contain the T-SQL syntax to back up your database.

I have that occurring now thanks, but locally I have the full blown license of SQL 2005 - so I was wondering how to set up the backup locally (couple of times a day) to append backup what is online (which is SQL express)...