If you are boring on reading long text in my previous post, here’s some little text for you. Do you know how many data file type created from SQL 2005 after you created your database? You didn’t notice or forgot, right? If you didn’t create partition(s), there’re two files created which are .MDF file and .LDF file. .MDF for your primary data file and .LDF for your log file. If you created partition(s), you see .NDF file as secondary data file(s). In one database, there’s only one primary data file.
Friday, March 28, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment