Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DUMP DATABASE

0 views
Skip to first unread message

Paul Jacobs

unread,
Nov 29, 1998, 3:00:00 AM11/29/98
to
To what degree is a 'DUMP DATABASE' non-physcial. What I mean is does the
server find the first table, find the first record and then dump it in a
proprietary format, and then find the second record and dump it and so
forth? Or does it simply start dumping any full or partially full page that
it finds, subject to locking, from the bottom of the device(s) to the top.

Paul


Tony Rogerson

unread,
Nov 30, 1998, 3:00:00 AM11/30/98
to comp.databases.ms-sqlserver
Paul,

On 6.5 a dump database dumps all used extents to disk.

I think it reads sequentially through the database and looks for any used
extents, if an extent is used it write's it off to disk in proprietarty
format.

--
Hope the above helps.
-------------------------------------------------------------
Tony Rogerson MCP/SQL Server MVP
Torver Computer Consultants Ltd.
London, England.

Paul Jacobs wrote in message
<2Yn82.274$4C.4...@brnws01.ne.mediaone.net>...

Neil Pike

unread,
Nov 30, 1998, 3:00:00 AM11/30/98
to
Paul,

The latter



> To what degree is a 'DUMP DATABASE' non-physcial. What I mean is does the
> server find the first table, find the first record and then dump it in a
> proprietary format, and then find the second record and dump it and so
> forth? Or does it simply start dumping any full or partially full page that
> it finds, subject to locking, from the bottom of the device(s) to the top.

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise)
For SQL FAQ entries see www.ntfaq.com/sql.html
and http://www.swynk.com/friends/hotek/articles/sqlserverfaq.asp

0 new messages