AnsweredAssumed Answered

Any value in backing up the Data Warehouse?

Question asked by Robert Ensinger on May 9, 2016
Latest reply on May 31, 2016 by Robert Ensinger

Hi all.

   Our full load of our data warehouse randomly fails with a

Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.

error.

 

My hunch is my DBAs are running database maintenance at the time of the full load - Microsoft Knowledge Article KB2979636.

 

Question: If one runs a 'Full Load' on the data warehouse each night, is there a need for database backups or other maintenance activities such as shrinking files and indexing?

 

What are the best practices for maintenance of the Data Warehouse, and more specifically, what, if any, standard activities that are performed on the CA PPM OLTP database can be dropped?

Outcomes