Viewing 15 posts - 1 through 15 (of 195 total)
The script contains scripted database objects(schema) and the data.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
April 9, 2021 at 7:55 am
he finding was that there was an audit trail function that was enable and contributing to datbase growth.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
March 5, 2020 at 7:01 am
I found the error I had two similar jobs doing the same thing and the maintenance plan that I was sending notification I was checking was actually failing.Noted and thank...
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
August 19, 2019 at 10:48 am
I think the maintenance plan should have created a SQL Server agent job. Can you have a look at the history of that job and see if it shows any...
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
August 19, 2019 at 10:28 am
As a follow-up question how do i ensure that the databases are identical when I failover from production to DR and then from DR to live without data loss and...
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
May 2, 2019 at 2:06 pm
AGs in two different clusters can be connected into a Distributed Availability Group (https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-2016), which will provide you with AG-to-AG (in your case, site-to-site) replication. When using Distributed Availability...
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
April 24, 2019 at 10:19 am
1.Windows Cluster 2
What kind of cluster?----Windows failover cluster
2.Availability Group with four databases (2 syncronous and 2 asyncronous)
Where are the availability groups failing over to?---database level when the primary database health...
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
April 24, 2019 at 10:17 am
Did not know interesting to know.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
April 23, 2019 at 2:04 pm
I created the procedure as per advice above the only hassle is that when transactions where the procedure is called did not commit,or fail some.It will arise in some document...
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 15, 2017 at 2:11 am
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 5, 2017 at 1:44 am
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 4, 2017 at 11:20 am
Thanks for the question!!
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
June 26, 2017 at 6:03 am
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
May 19, 2017 at 9:01 am
R becoming easy for me...thanks Steve.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
May 19, 2017 at 1:52 am
That was an easy one for me thanks.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
May 19, 2017 at 1:44 am
Viewing 15 posts - 1 through 15 (of 195 total)