Defragmentation of database file

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.
Hi,
Have a look into the below article.
http://www.winnetmag.com/SQLServer/A...283/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/pro.../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 database? If so,
how to do it?
> thanks.
|||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 t
he data records as a flat file to a tape drive.
thanks.
"Tibor Karaszi" wrote:

> http://www.microsoft.com/technet/pro.../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...
> 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/pro.../ss2kidbp.mspx[vbcol=seagreen]
for indexes?[vbcol=seagreen]
into the database? If so,[vbcol=seagreen]