Archival logic/algoritm

We are in need of finalizing an archival approach for one of our Web and Client server application. The major requirements are



a) User can click on Web front end to start archival process.

b) The system should move the related data to archived space in a backup location.

c) Could be a batch process.

d) The relation between tables is extensive i.e. > 30 tables need to be managed for archival one component.

e) Database size is not very huge < 10 MB.





We were planning to have a table to store archival flag, which will be set when user click on Archival. Then a batch program will copy the database in to a backup location and delete the entries from archived database where archive flag is not set and delete entry from master database where archive flag is set. The problem is how to synchronize the changes when archival process runs next time i.e. the master database would have changed so how to put that data in archival database with out removing existing data.



Any other approach/practical solutions will be very helpful.





Regards,

Mridul MishraWant to reread that and tell us if you think that makes sense?

Archive what? How do you know what to mark?

Maybe a simple explination:

"I build widgets...and when a widget is shipped I need to archive the order..."

What are you doing?|||Hmmm...Sorry for being not clear enough. Some how i thought every one is bugged with the problem as much as i do...;)

Well archival is more an event based task...Let me try to give more relevant information here..it's normal microsoft project plan which are stored and displayed for users. In most of the cases users might decide on their own whims(as most of the users are ;) ) when they feel data need to be moved to archive.

Thanks and regards
Mridul

Application error

What do I do to fix the "the application failed to initalize properly (0xc0000142), Click on OK to termainate the application.

You are going to have to provide more information.

What are you doing when that occurs?

What application/client tool are you using?

What version of SQL Server are you using? And patch level?

What is your OS version and patch level?

|||

Any updates on that ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

Application error

System always popup this message:

Application popup: oprd.exe - Application Error : The application failed to initialize properly (0xc0000142). Click on OK to terminate the application.

I recommend contacting Veritas for help with their application.

Application error

What do I do to fix the "the application failed to initalize properly (0xc0000142), Click on OK to termainate the application.

You are going to have to provide more information.

What are you doing when that occurs?

What application/client tool are you using?

What version of SQL Server are you using? And patch level?

What is your OS version and patch level?

|||

Any updates on that ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

API to create table, stored procedure, etc.

In SQL Manager I can right click on a stored procedure, table, etc. and I am presented with a list of options one of which is "Create >". Clicking this I can get a script that will create the respective stored procedure or table and write the create script to the clipboard, a file, or an SQL query window. I want to automate this to essentially selectively "back up" our data base by creating one large script that will create the tables and stored procedures from the database. Is there an API, tool, or library call that I can get access to the code that implements these menu selections?

Thank you.

Kevin

Yes. Look up the SMO reference in BOL. It has all of the capabilities and the full class library to do what you need.