Q. What objects does a SQL Server database contain?
A. A SQL Server database contains the tables, database diagrams, views, stored procedures, functions, and other objects required to support the database’s operations.
Q. Explain what a log file is and why it is important.
A. The log file keeps track of all transactions that occur as the database is used. It is necessary when restoring system information.
Q. Explain why you would want to attach to an existing database.
A. The ability to attach to an existing database allows you to easily utilize a database from another server.