Viewing 15 posts - 106 through 120 (of 1,179 total)
DBCC CHECKDB uses an internal database snapshot to prevents blocking. However as mention by Gail provide the detail deadlock chain/graph for further investionation.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 5:01 am
Did backup configured through maintenance plan? If not create it with maintenance plan and check.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 4:55 am
As mentioned in the error there are issue with the said index drop the index and recreate it later after changing the collation.
If you are getting multiple this kind...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 4:51 am
Interesting question, thank you Andy.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 2:46 am
Thanks for QOD, Barry.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 1:21 am
Check the permission for linked server for specific login which you are using to access data.
Are you able to execute any other command for that linked server?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 12:04 am
It looks like before Log shipping restore the backup file it is deleting. Hence this is having issue. You can increase the backup retention time to 48 or 36 and...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 13, 2014 at 3:22 am
Easy one!
Thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 13, 2014 at 1:30 am
Have you checked the query plan? Can you share the query plan too?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 13, 2014 at 1:21 am
It may take little long compare to Mirroring. However check if any blocking or anyother issues on the server. Check for any error message for further indication.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 13, 2014 at 1:19 am
Beatrix Kiddo (6/12/2014)
Under these circumstances you need to...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 12, 2014 at 10:39 pm
Nice one thanks Steve.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 12, 2014 at 6:41 am
It depends on what is the purpose. If you would like to restore point in time or all the current transaction which is not backed up in your current T-log...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 11, 2014 at 12:22 am
Is the hardware configuration of prod and test are same?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 11, 2014 at 12:16 am
Run update statistics or Reindexing on the database and re-play the production load.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 11, 2014 at 12:14 am
Viewing 15 posts - 106 through 120 (of 1,179 total)