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.

Thanks all

The problem is that there is not enough space in local disk and am trying to take back from a client machine to another remote machine..

But its throwing...

You created the maintenance plan for remote machine or local one????

Better take

1)full backup then

2)issue checkpoint

3)shrink datafile using dbcc shrinkfile(mdf_file_name,truncateonly) or use dbcc shrinkdatabase

3)take a transaction log backup

4)issue dbcc shrinkfile(ldf_file_name,10)

you specify how much you want to free up ...give 1Gb first...

The problem is with SQL Server 2005 and 2000...

How to change a database from emergency to normal???

I found that nothing wrong with the dump ,the issue is with SQL server Result set as it can display only upto some extend....What can i do to view the...