SQL pieces-parts

[Jim85CJ]

I'm very familiar with Oracle at a conceptual level and need to
understand MSSQL as well. Can anyone point me to a document/web page
that describes the different files used in MSSQL and a discussion of how
they relate? (ex. with Oracle, there is tempdb, redo, archive, db files,
rollback, etc.)

[Hugo Kornelis]

Re: SQL pieces-parts

On Tue, 25 May 2004 18:00:19 GMT, Jim85CJ wrote:
[color=blue]
>I'm very familiar with Oracle at a conceptual level and need to
>understand MSSQL as well. Can anyone point me to a document/web page
>that describes the different files used in MSSQL and a discussion of how
>they relate? (ex. with Oracle, there is tempdb, redo, archive, db files,
>rollback, etc.)[/color]

Hi Jim,

Books Online would be an eexcellent starting point, IMO.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[Jim85CJ]

Re: SQL pieces-parts

what is "Books Online"? Do you have a link?

Hugo Kornelis wrote:
[color=blue]
> On Tue, 25 May 2004 18:00:19 GMT, Jim85CJ wrote:
>
>[color=green]
>>I'm very familiar with Oracle at a conceptual level and need to
>>understand MSSQL as well. Can anyone point me to a document/web page
>>that describes the different files used in MSSQL and a discussion of how
>>they relate? (ex. with Oracle, there is tempdb, redo, archive, db files,
>>rollback, etc.)[/color]
>
>
> Hi Jim,
>
> Books Online would be an eexcellent starting point, IMO.
>
> Best, Hugo[/color]

[Hugo Kornelis]

Re: SQL pieces-parts

On Tue, 25 May 2004 20:11:45 GMT, Jim85CJ wrote:
[color=blue]
>what is "Books Online"? Do you have a link?
>
>Hugo Kornelis wrote:
>[color=green]
>> On Tue, 25 May 2004 18:00:19 GMT, Jim85CJ wrote:
>>
>>[color=darkred]
>>>I'm very familiar with Oracle at a conceptual level and need to
>>>understand MSSQL as well. Can anyone point me to a document/web page
>>>that describes the different files used in MSSQL and a discussion of how
>>>they relate? (ex. with Oracle, there is tempdb, redo, archive, db files,
>>>rollback, etc.)[/color]
>>
>>
>> Hi Jim,
>>
>> Books Online would be an eexcellent starting point, IMO.
>>
>> Best, Hugo[/color][/color]

Hi Jim,

Books Online is installed as part of SQL Server. You'll find it in the SQL
Server program group on your computer.

You can also read Books Online on Internet:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[Erland Sommarskog]

Re: SQL pieces-parts

Jim85CJ (jim_85cj@NOSPA Myahoo.com) writes:[color=blue]
> I'm very familiar with Oracle at a conceptual level and need to
> understand MSSQL as well. Can anyone point me to a document/web page
> that describes the different files used in MSSQL and a discussion of how
> they relate? (ex. with Oracle, there is tempdb, redo, archive, db files,
> rollback, etc.)[/color]

I cannot compare with Oracle, but here is a brief overview of how
SQL Server is organized filewise:

Each database is spread out on two or more files. In many case you
have exactly two: one data file and one file for the transaction log.
The transaction log is from where ROLLBACK and REDO:s are performed.

Both logs and data can be spread out on more than one file or even
file groups, but I have never used this myself.

tempdb is a database which is organized in the same way.

Backups (archives) are you take to disk or directly to tape. On disk,
they are just files.

As for Books Online, see below for a link to the most recent version.



--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp