DRAG DROP
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 Server.
You are requested to make it easier to export data from the database to Microsoft Excel 2007
format. In particular you want to be able run a command from the command line that exports the
data to Excel format.
What steps should you take?
Explanation:
Why not B and F (instead of B and E) ?
The master-DB had already been restored and rebuilt.
Now we should have a look at other important system-DBs :
(B) model-DB
(F) msdb-DB
Point (F) does matter here for sure, because important data and settings of SQL-Server-Agent-Jobs are stored in the msdb-DB.
Point (B) : The tempdb-DB is created automatically during startup based on the model-DB and does not need to be handled. This is only one of a lot good reasons for a good preparation of the model-DB.
information sources :
@see http://www.mssqltips.com/sqlservertip/1420/sql-server-system-databases/
@see http://www.mssqltips.com/sqlservertip/1531/rebuilding-the-sql-server-master-database-part-1-of-3/ a.s.o.
@see http://www.mssqltips.com/sqlservertip/3266/restoring-the-sql-server-master-database-even-without-a-backup/