Am with Jack 😀 ..Thats the way you can do ...

Create a secondary datafile on your D drive and then move some tables to that location

Thanks for reply,

1)How to backup...

IMPORT/EXPORT is there in 2000 and 2005 .Error file in bcp is that the those data which are not able to get inserted into the new table will go to...

Is there any option in SQL Server IMPORT/EXPORT like error file in BCP

What are all the ways to migrate a database from 2000 to 2005??

Check whether you have enough disk space at those instance of time.

Thanks for your reply HANSHi

I want to migrate only the data .A new SQL 2005 DB have to be created having more constraits.

Is it possible to migrate SQL Server 2000 SP2 to SQL Server 2005.

TIA

Thanks Earl,

I like to know how to check whether a...

Thanks to ALL

How to setup security so that noone can change the...

Both database on same instance.

Both had 2Gb of log and after i cleared the log they are telling that the issue is solved.Am sure that its not the log but...

No issues when i query through SSMS.

Done using select * into...Can anyone please tell how to delete a post???I tried to delete but no use :hehe:

Hi,

Also check whether any maintenance plan is created in some other remote server to take backup of this server .

Have you delete database files???

Check whether sufficient disk space is available in the drive where the database files resides.