Question on the evacuate of the datafile

Hi
I am using sqlserver 2000. I want to evacuate and drop a datafile.
It is around 10gb. My question is
Is it a online operation? and is there a performance impact on the database
druing this.
Are the tables available for DML during the time of evacuation?
TKs
MangeshMangesh,
What do you mean by evacuation? Do you want to empty a data file? If so use,
DBCC SHRINKFILE WITH EMPTYFILE. Let us know exactly what you're trying to do.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Mangesh Deshpande" wrote:
> Hi
> I am using sqlserver 2000. I want to evacuate and drop a datafile.
> It is around 10gb. My question is
> Is it a online operation? and is there a performance impact on the database
> druing this.
> Are the tables available for DML during the time of evacuation?
> TKs
> Mangesh|||Yes. It is referred in some books as evacuation of datafiles.
If i run DBCC SHRINKFILE WITH EMPTYFILE can I have DML on the tables whose
data is emptied on the other datafile.
Thanks
Mangesh
"Mark Allison" wrote:
> Mangesh,
> What do you mean by evacuation? Do you want to empty a data file? If so use,
> DBCC SHRINKFILE WITH EMPTYFILE. Let us know exactly what you're trying to do.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Mangesh Deshpande" wrote:
> > Hi
> >
> > I am using sqlserver 2000. I want to evacuate and drop a datafile.
> > It is around 10gb. My question is
> > Is it a online operation? and is there a performance impact on the database
> > druing this.
> >
> > Are the tables available for DML during the time of evacuation?
> >
> > TKs
> > Mangesh|||Yes it is basically an online operation except for the extents it is
physically moving at any particular time. And yes there can be a
performance impact since you are moving large quantities of data about.
This kind of operation is best done in off peak hours.
--
Andrew J. Kelly SQL MVP
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:6E692DBD-5CA9-4243-995F-3B4BF3D9F8F2@.microsoft.com...
> Hi
> I am using sqlserver 2000. I want to evacuate and drop a datafile.
> It is around 10gb. My question is
> Is it a online operation? and is there a performance impact on the
> database
> druing this.
> Are the tables available for DML during the time of evacuation?
> TKs
> Mangesh