I didn't submitted the correct data as I don't want to send company data out...Next time I will make sure to put question in right format...sorry this time...Plz let me...

What if the database does not have any indexes and I want to know when it was last accessed.....We are having many unused database which we are planning to decommission...

Thanks a lot for all help. I checked book online but can't fine the answer, thus I put question here....

Sys.dataspaces Contains a row for each data space. This can be...

I have two questions...

1. For a table without any indexes, as you said I can move it to another filegroup by using above script(which creates clustered index on new filegroup)....

Can you please give detailed description or any article for this for moving table with clustered index, non clustered index and a table without any index...I have tried using this...

Can you please give example with script for this?

Thanks.

Here's some more informaiton.

1.Database is in full recovery mode and we are using database mirroring on it. We are doing nightly full backup and hourly trans backups.after each trans backup...

We are currently doing RCA on that problem.

What kind of disk level diagnostic are you talking about? We talk to our server and storage admins and they said that they...

Our transaction logs are growing because of very very large transactions from application. We have notified them a lot of times to break their transactions but they are still researching...

Thanks a lot paul,

We did the same, we called Microsoft support. Problem resolved. Following were our steps to resolve the problem.

1. We...

O/P of checkdb,

DBCC results for 'LES'.

Service Broker Msg 9675, State 1: Message Types analyzed: 14.

Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.

Service Broker Msg 9667, State 1: Services...

The mdf file from that database sits on one drive(contains one disk) and ldf file sits on another drive(contains one disk). This is not SAN storage but local storage.

Hi Jonathan, Thanks for your reply. We have changed recovery mode for that database to "Simple" recovery mode last week. Because they are doing bunch of data load on that...

The database is only 320 GB. Our hardware guys did some scan on disk but they said that disk are ok....I am still waiting on Checkdb output for more investigation....

Hi Gilamonster,

Thanks for your help. I will wait till this process complete and so as our application team..I will post the output here, please help...