Defragmentation of database file

Can I do the defragmentation of database file in SQL Server 2000, not for in
dexes?
Is the only way to export data from the database and then import back into t
he database? If so, how to do it?
thanks.Hi,
Have a look into the below article.
http://www.winnetmag.com/SQLServer/...4283/24283.html
Thanks
Hari
MCDBA
"SY" <SY@.discussions.microsoft.com> wrote in message
news:19838AE1-9327-49D1-BCE1-135AABE88F53@.microsoft.com...
> Can I do the defragmentation of database file in SQL Server 2000, not for
indexes?
> Is the only way to export data from the database and then import back into
the database? If so, how to do it?
> thanks.|||http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SY" <SY@.discussions.microsoft.com> wrote in message
news:19838AE1-9327-49D1-BCE1-135AABE88F53@.microsoft.com...
> Can I do the defragmentation of database file in SQL Server 2000, not for
indexes?
> Is the only way to export data from the database and then import back into the dat
abase? If so,
how to do it?
> thanks.|||We are using database having a current size of over 300GB to store attachmen
t files in an image column of a table. is the approach of exporting and impo
rting data records from the table a good way to defragment the table? if so,
is it possible to export t
he data records as a flat file to a tape drive.
thanks.
"Tibor Karaszi" wrote:

> l]
> --
> Tibor Karaszi, SQL Server MVP
> [url]http://www.karaszi.com/sqlserver/default.asp" target="_blank">http://www.microsoft.com/technet/pr...ver/default.asp
> http://www.solidqualitylearning.com/
>
> "SY" <SY@.discussions.microsoft.com> wrote in message
> news:19838AE1-9327-49D1-BCE1-135AABE88F53@.microsoft.com...
> how to do it?
>
>|||Hi,
Check the fragmentation for those tables using the below command
dbcc showcontig('table_name')
If the scan desity is too bad then execute
DBCC DBREINDEX('table_name')
for those table with high fragmentation.
Note:
It is not required to export and import data for tables.
Thanks
Hari
MCDBA
"SY" <SY@.discussions.microsoft.com> wrote in message
news:B95EB230-210D-4B40-96B6-5B7C05CACA7C@.microsoft.com...
> We are using database having a current size of over 300GB to store
attachment files in an image column of a table. is the approach of exporting
and importing data records from the table a good way to defragment the
table? if so, is it possible to export the data records as a flat file to a
tape drive.[vbcol=seagreen]
> thanks.
>
> "Tibor Karaszi" wrote:
>
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx[vbcol=seagreen]
for indexes?[vbcol=seagreen]
into the database? If so,[vbcol=seagreen]