We decided to go with Full and Differential BackUp and Restore.

Thank you all for your time and feedback.

Thanks Satish! I am not sure if we can use SSIS package at this time. I am trying to understand the process in details . Will come back for some...

Thank you all for your responses.

We can not use Log Shipping because Our databases do not store transactions. We load data everynight from different sources . So it is...

I am facing similar issues...Thank you so much.

Found it and I thought I should share..:-)

After new schema is created, we should modify table. Table properties will be appeared with dbo schema, from there we can assign new...

Thank you Lowell. Now that I think about it, I might have created the script back then.

Thank you for your response. I thought we can change it in properties. I have done it once long time back in SQL Server 2005. Now I don't remember it.

Thank you. I was trying to delete parent first. It works now.

Thank you Lutz for your guidance. I am still trying to figure out if it is code or sql server agent. You indeed pointed me in right direction. I will...

Thanks for your patience.

Since it didn't run so i had to cancel the job so it stopped after that. The error msg is "Execution of job ' ' failed. See...

The status is in progress but it is continously trying to run the job for last 2 minutes.

the status is failed..

the status is idle..

I started job. It keeps running and running but doesn't really complete the job. I don't see any error as well.

I don't see anything in history. what should be my next step?