Forum Replies Created

Viewing 15 posts - 16 through 30 (of 249 total)

  • RE: Restore Backup from 2012 to 2017 GTM

    what is results of restore verify command.

    As a trial try to restore it in 2014 or 2016, then take the backup and restore it on 2017.

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: SQL Server Dependencies

    Lynn Pettis - Friday, June 29, 2018 10:46 AM

    Raghavender Chavva - Friday, June 29, 2018 9:21 AM

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: Jobs running indefinitely

    Is there any maintainance jobs scheduled to that DB.

    Have checked Indexes.

    Try to run updatestatistics on the DB if not done already.

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: Solving the Target Principal Name is Incorrect

    Alex Gay - Thursday, May 31, 2018 5:15 AM

    This also happens if a user changes their password after logging in to their...

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: How to fix this deadlock?

    Did you checked the execution plan of both the queries.

    If the deadlock is between Insert and Select queries try to run the select query with nolock and check...

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: Backup

    adisql - Tuesday, May 22, 2018 9:27 AM

    Yes i verified SQLServer error log and msdb - backupset, backupmediaset, backupmediafamily, backupfile, etc. 
    for...

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: Finding table name based on a specific value

    jeffgonnering - Tuesday, April 17, 2018 8:38 AM

    query does not take into account the table schema so it is fails in my...

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: Shrinking Transnational Log File

    After 1 st log backup free space on the log file was 98%.
    I checked for any open transactions are running on that database but nothing was found. nothing shown in 

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: Tape backups or disk backups

    Thank You For your reply.

    Can we know when the backup was taken to virtual disk.

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: Can you disable the sa account if it used as a local login for Linked Server?

    Yeah, don't use SA login. Most of the cases SA has to be with DBAs, should not be used for other purpose until there is no alternate. 
    Retry also affects...

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: Can you disable the sa account if it used as a local login for Linked Server?

    Yes we can disable it. If the connection is there it will work untill it attempt for retry.
    New connections won't be able to connect.

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: Uninstallation Logs

    Seems all the folders and files were deleted after uninstallation. There is no SQL related folders exists on the server.
    In windows event viewer I could not find anything related...

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: Uninstallation Logs

    Hi Team,

    Any Help please.

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: Log file growth

    If the database is in Full Recovery mode and log backups not scheduled or log backups happening in very less frequency on database which has very high number of transactions.

    Thank You.

    Regards,
    Raghavender Chavva

  • RE: SQL Cluster on VMs in cross DCs

    We have setup the physical cluster in cross DCs, but I am not sure about cluster on VMs if there will be any issues on cluster on VMs and in...

    Thank You.

    Regards,
    Raghavender Chavva

Viewing 15 posts - 16 through 30 (of 249 total)