Forum Replies Created

Viewing 11 posts - 16 through 26 (of 26 total)

  • RE: Comparing the data in two tables

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

  • RE: Integrity Checks Job Failed

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

  • RE: Moving DTS

    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.

  • RE: tempdb deleted

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

  • RE: tempdb deleted

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

  • RE: tempdb deleted

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

  • RE: General Database Questions (shrink db, suspect db)

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

  • RE: Transaction Log Growing

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

  • RE: URGENT NEED HELP KILL/ROLLBACK PROCESS KEEPS RUNNING AND EATING CPU

    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.

  • RE: Query Timeout

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

  • RE: URGENT NEED HELP KILL/ROLLBACK PROCESS KEEPS RUNNING AND EATING CPU

    Hi,

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

     

    Thank you

Viewing 11 posts - 16 through 26 (of 26 total)