I would prefer Yelena's query. If you have two different databases then you might need to change query from tablename.column to "databasename..tablename.column" and if you have if on two different...

Have you checked "Attempt to repair any minor problems" checkbox in the integrity check tab inside maintenance plan? If yes then that answers your question, because you can't run dbcc...

Open the DTS Package, Save it as script file.

copy it to destination server.

Go to DTS open package and then save on the server.

Hi Everybody,

Thank you for all your help and suggestions.

GBN I am not sure how this happened as when i got to know that i have to fix this server...

The problems is this server is not supported by my team. So we had no ideas about what's going on this server. They contacted us when they got this problem...

I tried start sql server with -f parameter from command prompt but didn't start. I think this is what happened in this case, this is my understanding please correct me if...

i had shrink process ran for almost 15 hours. So time to shrink database or file really varies on database condition. Another thing you might want to check physical_io or...

run following command, just replace device_name with the devicename where you want to back up the logs and DBName with Database name.

Backup log DBName to device_name with Truncate_Only

If you dont...

Thank you all. Reboot took care of everything. It took couple of hours to recover databases as those were real big ones but everything seems fine now. Thank you.

You might want to run the index tunning wizard against that table and pass all the queries running on that table. At the end of the wizard it will show...

Hi,

What are the chances of database getting corrupted in this situation or going to suspect mode if i reboot the server?

Thank you