Hi
A friend asked me if SQL Server 2000 restore reorganizes data and indexes. I
don't believe it does. What do you think?
Regards,
AndrésThis is a multi-part message in MIME format.
--060007060400070804080405
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
No it doesn't. It pretty much just copies the pages as they are from
the backup media to the physical database files. If he wants to
reorganise or rebuild indexes he'll need to use DBCC INDEXDEFRAG or
DBCC DBREINDEX respectively (or copy the data in afresh using bcp, DTS,
etc. if he wants to do it the hard way).
--
*mike hodgson*
http://sqlnerd.blogspot.com
AFG wrote:
> Hi
> A friend asked me if SQL Server 2000 restore reorganizes data and
> indexes. I don't believe it does. What do you think?
> Regards,
> Andrés
--060007060400070804080405
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>No it doesn't. It pretty much just copies the pages as they are
from the backup media to the physical database files. If he wants to
reorganise or rebuild indexes he'll need to use DBCC INDEXDEFRAG or
DBCC DBREINDEX respectively (or copy the data in afresh using bcp, DTS,
etc. if he wants to do it the hard way).</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
AFG wrote:
<blockquote cite="midDEEF3E03-DCEF-4595-9C29-C3115F097364@.microsoft.com"
type="cite">Hi
<br>
<br>
A friend asked me if SQL Server 2000 restore reorganizes data and
indexes. I don't believe it does. What do you think?
<br>
<br>
Regards,
<br>
<br>
Andrés <br>
</blockquote>
</body>
</html>
--060007060400070804080405--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment