1.

“One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click start mirroring again.”

Answer»

The physical database architecture is a description of the way the database and files are organized in a SQL server.

  • Pages and extents- A page is the size of 8KB and set of 8 Pages are called extent. This is the FUNDAMENTAL unit where data is stored.
  • Physical Database Files and Filegroups- Database files visible at file system to store data and logs.
  • Table and INDEX Architecture- Database objects inside the database to store & access data.
  • Database- Database is a set of data & Log file which resides over the filesystem and managed by the operating system.
  • SQL Instance- SQL instance is a LOGICAL entity controlled databases. One SQL instance can have multiple databases. Security and accessibility is ALSO part of the SQL instance.


Discussion

No Comment Found