Please go one step further. Use SSIS in place of maintenance plans. IIRC it has backup database tasks (and also others). It will also allow you to FTP the backup...

However it’s irrelevant to SSC (& SQL Server) but to complete the discussion, Oracle provides us the control on refresh rate of the Materialized View. It’s a major feature (as...

Following snippet is from the same article I suggested earlier.

Use NOEXPAND if you want to be sure to have SQL Server process a query by reading the view itself instead...

Users can verify the data till FULL restore. You have already recovered the database so there is nothing left to do.

If you can afford (in terms of time) to restore...

Please don’t take it otherwise or discourage yourself. We just severed few options in front of you. I very well understand that schema design changes will have severe ramifications, if...

Thread title ‘Transactions deleted in production and stage table only populating new data’ suggests few things but not sufficient to help you.

I assume you lost few transaction records in PROD...

Sorry to disagree with you Tom but I also believe it violates 1st NF. It’s a case of ‘Repeating groups across columns’.

According to Date's definition of 1NF, a table is...

Please start another thread for your question & provide details. It will help us focusing on your issue specifically & won’t mix the responses for previous question.

It makes sense if you have multiple users & have multiple databases for users. You can take one database offline and only one user will be impacted. The rest can...

Thanks for the feedback!

That’s what I assumed. Please keep us informed with debug progress.

select snapshot_isolation_state, snapshot_isolation_state_desc, is_read_committed_snapshot_on

from sys.databases

where name = <your DB name>

http://msdn.microsoft.com/en-us/library/ms178534.aspx

Can you give ‘full control’ on the file / folder to everyone (tentatively, for debugging purpose only)? It will confirm the permission issues with domain user as well as path...

When you say ‘the data is the same for both’, do you really mean data or data structure (DDLs)?

I am also finding difficulty in understanding the application architecture. Do...

This is precisely the reason you are getting errors.

Please make sure you have sufficient rights (which I...