.sql files question answer asap?

Question

Are .sql text files supposed to be readable by humans? I know that sql backup files are, but what about .sql text files? Thanks BEST Answer to the best answer.

Answer 1

If by sql text files you mean backups in text format, of course. (SQL database files may be - it depends on the human. Some of us can actually read binary files too.) I don't know of any SQL database that uses text files as its data files.

Answer 2

.sql text files should be readable if the program you're opening them in supports the file format. If you don't have one that does, I suggest Notepad ++.



http://notepad-plus.sourceforge.net/uk/site.htm

Answer 3

sq. Server normally makes use of two records to maintain the information contained interior the database. A .mdf record is composed of each and every of the information, and a .ldf record is composed of the transaction log (it particularly is, records that has yet to be written to the database). those records normally stay on the comparable server by using fact the example of sq. Server, yet theoretically, they could be everywhere. once you create a clean database in sq. Server, you're given the alternative as to the place you elect the information and transaction records to stay. it somewhat is maximum efficient to maintain them on separate disk drives to dodge disk thrashing.

Answer 4

very confusing situation. query with yahoo. that can assist!