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--
Showing posts with label regards. Show all posts
Showing posts with label regards. Show all posts
Friday, March 9, 2012
Saturday, February 25, 2012
Restore a database
hello,
How to restore a database without the master database?
Regards,
without the master database, your sql server instance will not be able to start up.no, you do not need to restore the master database before restoring your user database.
Tuesday, February 21, 2012
Restore .mdf file as database
Hi.
Is it possible to restore a database from a .mdf file or a .log file?
Regards
Mr. Smith"Mr. Smith" <nospam@.blindfolded.gone> wrote in message
news:%23nV1xYG3EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi.
> Is it possible to restore a database from a .mdf file or a .log file?
>
You can attempt to sp_attach_db or sp_attach_single_file_db
Good luck.
> Regards
> Mr. Smith
>|||You should just attach the .mdf and .ldf
"Mr. Smith" wrote:
> Hi.
> Is it possible to restore a database from a .mdf file or a .log file?
>
> Regards
> Mr. Smith
>
>
Is it possible to restore a database from a .mdf file or a .log file?
Regards
Mr. Smith"Mr. Smith" <nospam@.blindfolded.gone> wrote in message
news:%23nV1xYG3EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hi.
> Is it possible to restore a database from a .mdf file or a .log file?
>
You can attempt to sp_attach_db or sp_attach_single_file_db
Good luck.
> Regards
> Mr. Smith
>|||You should just attach the .mdf and .ldf
"Mr. Smith" wrote:
> Hi.
> Is it possible to restore a database from a .mdf file or a .log file?
>
> Regards
> Mr. Smith
>
>
Subscribe to:
Posts (Atom)