Viewing 15 posts - 781 through 795 (of 6,676 total)
Heh... Wecome aboard but... "Must Look Eye!"
You've posted what looks like Oracle code in an SQL Server forum and it's not going to work in SQL Server.
On a 6+...
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
September 21, 2021 at 8:11 pm
Follow question on this as I am not 100% clear on what to do here.
If I restore a 2016 backup to a 2019 server, after the restore, I MUST...
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
September 20, 2021 at 5:41 pm
I would definitely move the comments column to its own table - with keys to identify when the comment was made and who made the comment. I would also look...
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
September 20, 2021 at 5:34 pm
If the secondary node was restarted - or unavailable, that would cause the kinds of messages you are seeing. As for the cluster shutting down, it shows that the cluster...
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
September 20, 2021 at 5:17 pm
Not quite - the transaction log will be truncated after a log backup has occurred *and* there are no open transactions in the previous VLF's. The log also cannot 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
September 20, 2021 at 5:11 pm
Redgate's SQL Search is the best answer - and it is free. If you - for some reason - cannot use that tool then you are going to have to...
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
September 19, 2021 at 2:05 pm
If you are on Enterprise Edition for SSRS - then you can add the new reporting services server in a scale-out deployment. Configure the new server to use the existing...
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
September 18, 2021 at 4:34 pm
There is also the schema changes report available - that shows not only changes to tables but will also show changes to any objects and who made the change. However,...
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
September 15, 2021 at 9:21 pm
Why would you do that? That would just mean rerunning this code over and over until all rows matching the criteria have been deleted. What purpose would that serve?
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
September 12, 2021 at 2:41 pm
I have already put code in place to block the NULL values for some of the Attributes, not sure why is was ever code to allow those into the...
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
September 11, 2021 at 4:32 pm
The steps you outlined are correct - that process will allow for patching with minimal interruption.
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
September 11, 2021 at 3:01 pm
This is a basic template for a batch delete/update/insert process:
Declare @rowsAffected int = 1
, @batchSize int = 50000; --increase/decrease as...
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
September 10, 2021 at 5:04 pm
What is the purpose of the AG node? I am assuming that the FCI cluster is primary - SERVER3 is an AG secondary, and that secondary is set to asynch...
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
September 10, 2021 at 4:41 pm
Ola's utility - and many procedures that were built to do the same thing - will have a post-step after an index reorganize that updates the statistics. So either a...
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
September 7, 2021 at 9:54 pm
That is expected - the /netonly credentials will be used for that connection even though it shows your local windows credentials.
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
September 7, 2021 at 6:05 pm
Viewing 15 posts - 781 through 795 (of 6,676 total)