Dirrectory Structure of SQL - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Dirrectory Structure of SQL

Author

Topic

hunkydude81
Starting Member

4 Posts

Posted - 2008-01-28 : 03:18:26

Hi all,

I just wanted to know the DIRECTORY structure for Ms SQL, and a brief explaination of each of the folders that are created.

For example:
Where is the actaul dbase stored, folder name
Where are logs stored
and Any other folders that are created and their useage?

I am also eager to know HOW WE EXTEND THE TABLESPACES and add DATAFILES using SQL commands?

Thanks and regards
Hunkydude

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-01-28 : 03:34:01

Tell us which chapters in Books Online you have and haven't read, and we might be able to assist you.

E 12°55'05.25"
N 56°04'39.16"