Apologies for the basic level of the question but I wanted some input into the following:
Our DBA backups the user and system databases - and in their opinion that is all they need to backup on the windows database server
They claim that if they needed to rebuild the server hey could do it from scratch with minimal effort.
Question: What is your view on this? What outside of the SQL backups would be included in a backup of the system drive and would be required when rebuilding the DB server from scratch? Why are these so important? Is rebuilding from scratch a lot more effort than restoring the backup? What files in the system backup would need configuring from scratch if building from fresh.
Please keep answers pretty basic and management / risk freindly.
As far as the database server is concerned, backup of the databases should be enough and that's very much need to rebuild the system from scratch.
If you are in a virtual environment, taking the backup
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…