By mistake we have executed the ttaad4231m000 session and deleted all the baan tables. including (baan table,customised table)

we have backup of sql table backup. with this can we restore and reactivate the BaaN system.no sequential dump backup available.

Please advice.

simply restoring your sql based backup should do the job.

Thanks.. We shall try in test server.

Can you advice how to schedule SQL backup automatically. send me with example

presently we are taking manually.

Try this,

1.Open EM for SQL 200 Server
2.select the database server (note : Server must be Registeredin EM)
3.Goto "Tools"->"Database maintenance Planner"

It opens a wizard, there you would be able to take / Schedule Backup .

BR,
Sushil Kumar Mudaliar

closed..............