I'm using an SQL Server 2000.
We have a live database with over 10gb of data. I want to create a new backup database which is was easy to do. so after creating my new backup database I want to create based on time (eg. 1 day) a query or a procedure to copy new data from live database to backup database.
Live_Database(Table1, Table2, Table3.....)
Backup_Database(Table1, Table2, Table3.....)
So, I need to update records on Backup_database(Table1, Table2, Table3.....) from Live_database(Table1, Table2, Table3.....).
After updating the records in Backup_Database(Table1, Table2, Table3.....) i want to delete records in Live_database(Table1, Table2, Table3.....) where record_id from table1 from Live_database is older than x days.