Viewing 15 posts - 766 through 780 (of 6,676 total)
Finally found the reason for the error. Thought add that so anybody who have this issue can benefit.
On the secondary database , properties, Advanced, Enable Contained Databases Option should...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Just curious - but do you have the option 'Optimize for Adhoc Workloads' enabled on that server? I would also review the parameterization setting on the database - the default...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
You should also not use SELECT to set the variable - use SET instead:
DECLARE @SQL NVARCHAR(4000);
SET @SQL = 'SELECT * FROM TableA; ';
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
If you enable automatic seeding - then you only have to restore the database to the primary and add the database back to the AG. So your steps would be:
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
@JeffModen - I rather like Peter's version to get the Nth Weekday outlined here: https://weblogs.sqlteam.com/peterl/2009/06/17/how-to-get-the-nth-weekday-of-a-month/
And we had a discussion about my changes to his function here: https://www.sqlservercentral.com/forums/topic/get-particular-date-from-a-month/page/3
I would think using...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
What are you looking at to determine that the instance was not upgraded and instead was installed side-by-side?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
What have you tried so far?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Or is it possible that the backup process is switching the recovery model before performing backup - then switching it back to full? Those are the only reasons I can...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Peter Larrson created the function outlined here: https://weblogs.sqlteam.com/peterl/2009/06/17/how-to-get-the-nth-weekday-of-a-month/
I updated that function and showed it here: https://www.sqlservercentral.com/forums/topic/get-particular-date-from-a-month
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 15 posts - 766 through 780 (of 6,676 total)