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...

Now i requested client to

1)run dbcc checkdb

2)enable torn page detection

and then take a full backup.

Is that ok

What happens if i enable torn page detection???

Will it affect performance or any other issues if it is enable in a LIVE Database??

When i run sp_helpdb 'db_name' on database which i restored i got the following message

Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=611, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics

Client took the backup from a live database.

No idea about torn page detection ..how to check that???

I got backup from client only.

1)Its a full backup

2)Compatability level 80

No idea about partitioned tables and other file groups,But i think if there is some other filegroup then at...

Hi ,

I found 'sp_helpsrvrole' which gives all server roles and description(full name):D

If you are using SQL Server 2005 ,

import using wizard and there is one option "write query to specify the data transfer" use that.:)

Try giving INSTANCE_NAME\SQLEXPRESS,1433..Make sure your SQL Server service is up and running.

vote vote vote.......................:P