Fragen im Vorstellungsgespräch bei Microsoft: How many physical files are r... |

Frage im Vorstellungsgespräch

Applications Development Manager-Vorstellungsgespräch

How many physical files are required to create a database

  within SQL Server.

Antwort im Vorstellungsgespräch

1 Antwort


i answered three, since that was the way we did it where I worked before. The correct answer was two. All that is required is a single physical file for the databases, master, temp, and user created, etc. The second file is for the log. We used three to keep the master, temp and other standard databases somewhat pristine and then used other physical files for all databases created for actual users and projects. The log file is required regardless of what you do.

Bewerber im Vorstellungsgespräch am 03.10.2011

Antwort oder Kommentar posten

Um dies zu kommentieren, bitte anmelden oder Konto anlegen.