Viewing 15 posts - 16 through 30 (of 248 total)
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.
July 4, 2018 at 7:14 am
July 4, 2018 at 7:01 am
Is there any maintainance jobs scheduled to that DB.
Have checked Indexes.
Try to run updatestatistics on the DB if not done already.
June 29, 2018 at 9:25 am
May 31, 2018 at 5:54 am
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...
May 22, 2018 at 9:49 am
May 22, 2018 at 9:38 am
April 18, 2018 at 3:26 am
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
April 16, 2018 at 9:17 am
Thank You For your reply.
Can we know when the backup was taken to virtual disk.
October 5, 2017 at 7:03 am
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...
June 21, 2017 at 5:26 am
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.
June 21, 2017 at 5:07 am
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...
April 24, 2017 at 4:00 am
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.
March 22, 2017 at 10:30 am
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...
March 10, 2017 at 4:13 am
Viewing 15 posts - 16 through 30 (of 248 total)