Viewing 15 posts - 46 through 60 (of 648 total)
Thank you..
First statement executed successfully immediately - Will it require restart SQL Server for taking effect?
Second Statement tested Development setup - but it will take too much...
January 25, 2018 at 3:26 am
Hi NorthernSoul.
Nothing found in blocking and deadlocking at that time...
I checked event viewer application logs/system - no error found related...
August 2, 2017 at 5:45 am
1. Received call from user side for application hang and not responding..
2. Login server and checked database instance both were up/running state.
3. Server take restart manually at 08/02/2017 04:20:21...
August 2, 2017 at 4:01 am
[
Date,Source,Severity,Message
08/02/2017 04:20:38,spid8s,Unknown,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
08/02/2017 04:20:30,spid12s,Unknown,Service...
August 2, 2017 at 3:26 am
i have checked error log file and found those error messages.. Please suggest which resource are busy in terms of CPU, memory. I have checked these resource are normal state...
August 2, 2017 at 1:28 am
Hi Thom..
Second JOIN condition not valid due to database_id field not available in sys.dm_exec_sessions,
USE
July 20, 2017 at 10:21 pm
Thank you Mr. Eirikur's and Gail.. I resolved LDF file corruption problem and database working as expected. I followed Mr. Eirikur's steps and slightly changed..
1. Stop SQL services
2. Copy the...
July 18, 2017 at 9:45 am
Ok..I will follow Mr. Eirikur's suggestions.
I have doubt.. How TLOG backup successed till time if LDF file got corrupted. I think some of the log block was issues.
July 18, 2017 at 6:45 am
CHECKDB command output no errors.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'JMDBIOMET'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
July 18, 2017 at 6:13 am
During database backup Error message record in error log file.
Message
Error: 3041, Severity: 16, State: 1.
Backup detected log corruption in database JMDBIOMET. Context is FirstSector. LogFile: 2...
July 18, 2017 at 6:03 am
3. Database to changed FULL recovery mode from SIMPLE
then try to take FULL backup again. but this full backup not successes again same error
July 18, 2017 at 4:59 am
Hello Perry,
Combination of windows 2016 and SQL 2016 alwayson HA feature can support windows cluster multi subnet failover in workgroup environments, So in this setup where windows cluster object and...
May 9, 2017 at 1:31 am
Thanks Mr. Perry.
I have gone through Microsoft Link and documents which is suggested by you.
In that architecture backup share server introduced and this backup share folder storing TLOG backup files which...
May 8, 2017 at 10:41 pm
Thank you Mr. Perry and Mr. Anthony. for yours valuable comments
I will disable custom TLOG backup in Principal database server during configuration of log shipping.
Does Log shipping...
May 5, 2017 at 7:16 am
Hi jigging.tech, Thanks for reply..
One of the OLTP database recently configured AG setup in SITE A (Primary datacenter). the same database will going to extent for DR setup at SITE...
November 3, 2016 at 10:24 pm
Viewing 15 posts - 46 through 60 (of 648 total)