Viewing 15 posts - 16 through 30 (of 249 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.
Thank You.
Regards,
Raghavender Chavva
July 4, 2018 at 7:14 am
Thank You.
Regards,
Raghavender Chavva
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.
Thank You.
Regards,
Raghavender Chavva
June 29, 2018 at 9:25 am
Thank You.
Regards,
Raghavender Chavva
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...
Thank You.
Regards,
Raghavender Chavva
May 22, 2018 at 9:49 am
Thank You.
Regards,
Raghavender Chavva
May 22, 2018 at 9:38 am
Thank You.
Regards,
Raghavender Chavva
April 18, 2018 at 3:26 am
After 1 st log backup free space on the log file was 98%. Thank You. Regards,
I checked for any open transactions are running on that database but nothing was found. nothing shown in
Raghavender Chavva
April 16, 2018 at 9:17 am
Thank You For your reply.
Can we know when the backup was taken to virtual disk.
Thank You.
Regards,
Raghavender Chavva
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...
Thank You.
Regards,
Raghavender Chavva
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.
Thank You.
Regards,
Raghavender Chavva
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...
Thank You.
Regards,
Raghavender Chavva
April 24, 2017 at 4:00 am
Hi Team,
Any Help please.
Thank You.
Regards,
Raghavender Chavva
April 14, 2017 at 5:16 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.
Thank You.
Regards,
Raghavender Chavva
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...
Thank You.
Regards,
Raghavender Chavva
March 10, 2017 at 4:13 am
Viewing 15 posts - 16 through 30 (of 249 total)