Thanks Atul but but but...

I want to transfer all backups from my disk device to tape device... This is the issue. Can you/anyone help?

-LK

Many thanks. This helped.

-LK

Awesome Pradeep. Thanks

Oh I found. When sql server express edition is installed then sql server agent service is installed but this never runs. Dumb service is installed by Microsoft.

-LK

Rohit,

As you are moving to different server so take a backup of master key and restore this on new server. This should resove the issue. Do inform me if this...

run following commands to clear your cache

DBCC FREEPROCCACHE

DBCC FREESESSIONCACHE

Run your query and inform us how much time does this take? Also use task manager and job monitor to see what...

This is quite impossible to assist w/o correct information. Members, please avoid this.

-lk

Yes it affects performance if logging is more. If you see that a lot of dump files are getting created then you can shred them out, if you don't need...

Sorry for being a bit confusing here.

I was able to use windows login but suddenly this stopped accepting windows login. Acrually I changed the name of my server some...

Everyone is correct. I would like you to take a rest but you can really do something here to make the rollback faster. Lessen the load on your server. Try...

Thanks ALZDBA,

This was what I was expecting.

-LK

Thanks DNA

Pradeep you say that heap is cleared off and only clustered index exists as a form of organized data. Now when we drop the clustered index then the index is...

No Pradeep, my question is as follows:

When the clustered key is created does the heap still exist?

-Lucky

Good suggestion Matt Thanks.

-LK