Access MDB Files and SQL Server Device Files

By Chris Miller on 16 August 2000 | Tags: Storage/Sizing


Byron Fillmore writes "I am very new to SQL server. Does SQL server hold the names of tables and queries in a single file like an Access .MDB file?"

SQL Server stores all of the objects associated with a database in at least two but possibly more files. The database itself is broken up into two pieces, the data portion and the log portion. The log is a transaction log which allows SQL Server to avoid data loss in the event of a server crash or power failure. The data file contains the tables, indexes, and other objects that SQL Server uses to store and manipulate data.

The SQL Server system administrator (sa) can configure a given database to reside in several (more than two) files so the sa can spread the data access out across several different physical disk drives or drive arrays, so the data access time will be really fast. This also allows the sa to tune backups so the backups can run more quickly.

rocketscientist.


Related Articles

Handling database file growth (18 December 2002)

Finding the biggest tables in a database (4 August 2000)

Network Attached Storage: An Overview (11 July 2000)

SQL Server and Network Attached Storage (6 July 2000)

Other Recent Forum Posts

Good Book for Configuring Availability Groups (12m)

Mbm Bet game cusTomer care helPliNe number ☎️❾❶+{{❾❸❹❶❼❼❺❻❸❾}} uvk (29m)

Mbm Bet game cusTomer care helPliNe number ☎️❾❶+{{❾❸❹❶❼❼❺❻❸❾}} yh (33m)

Mbm Bet game cusTomer care helPliNe number ☎️❾❶+{{❾❸❹❶❼❼❺❻❸❾}} h (36m)

How do I raise a complaint against Meesho?.. call me ☎️ (42m)

How do I raise a complaint against Meesho? (45m)

How can I complain to Meesho? (51m)

How to get money back from Paytm if wrong transaction? aa (64m)

- Advertisement -