Quick question, is it at all possible to combine a "newer version" of the LDF file with and older version of MDF file and keeping changes logged in the LDF? Instincts and 1 hour trying says no it is not possible.
Long version:
1. Database in full recovery mode 2. Take a full backup 3. Make some changes 4. Detach database 5. Make a filecopy of the LDF-file 6. Restore from full backup 7. Detach database 8. Make a filecopy of the MDF-file 9. Throw away the backup 10. Delete the database 11. Somehow make the MDF and LDF play together with the change made in step 3 still in place.
If you think it might be possible I could make it a question on site. But a short "no forget about it" works just fine in here.
G'morning folks! A MySQL instance of mine just took a nose dive this morning, after booting in recovery mode & then booting in normal mode, everything is back and working, but accessing a specific unrelated schema from the app is taking a long time
There were a fair few indexes and generated columns in the DB, is it safe to say it's slow because it needs to rebuild them? Ah scratch that, everything seems to be slow
@gbn Ok, But they are from the same database only different places in time. Error I get with restore is The log scan number (38:194:42) passed to log scan in databaseattach
I assumed deleted so try this... 1. copy current MDF and LDF to a safe place 2. create a new db same name, same file names etc. 3. take new one offline 4. copy original MDF and LDF back 5. bring online 6. now won't start
At this point, SQL server has an database that won't come online
> If a database is offline and fails to start and you need to restore the database, first back up the tail of the log. Because no transactions can occur at this time, using the WITH NORECOVERY is optional.
> ...Tail log backups capture the tail of the log even if the database is offline, damaged, or missing data files.
Please let me know. It's a long time since I had to rescue something like this. SQL 2000 on some idiot's desktop that was "critical for trading" (investment bank). Also see multiple LDFs, no backups, LDF filled disk because full recovery model
@ypercubeᵀᴹ it's your story, you can do what ever you'd like. If you use Yper Cube, then that's how you'll appear to any employers. We do offer two fields though, one for your Display Name on the site and a Full Name for employers.
Just wanted you folks to know that table-swap I did last night went really well, both tables are performing much better today. Going to keep an eye on it and see if it changed more.
So... This is one of those ideas that sounds really caring. Who could possibly be against expressions of gratitude!
I mean, sure, they get noisy for 3rd-party readers after a while, but hey, small cost compared to making authors feel good right?
Well... After a while, they ain't that much fun f...
Even better: Instead of up and down arrows implement a box containing positive emojis and negative emojis. Clicking on positive emojis is an up-vote and clicking on negative emojis is a down-vote.
Not sure how I myself feel about this, but to me it doesn't seem to play well with their initiative to become more welcoming and inclusive. Thanks are unnecessary noise as far as finding a ready solution to your problem is concerned, but not letting you express your gratitude in your own way, offering you a standardised "reaction" instead – not sure if that's going to play well for newcomers. But I'm curious to see what it'll be like
turdle: (noun) A nice word for an otherwise objectionable description of an excrement, which can be used in chats, which would otherwise be moderated away. Not to be confused with turtle.
Meanwhile, in August 2009 "noise" was added as reason for comment flagging, and the comment flags show in the 10k tools. And Allow low-rep users to suggest edits is on its way. Hence: I don't care for this request myself anymore. An explicit [status-declined] would be fine.
What about being ab...
Is it possible to combine a "newer version" of the LDF file with an older version of the MDF file and keep changes logged in the LDF? Lets assume there has been no log-backups in the time between as I guess that would make this truly impossible.
Steps:
Database in full recovery mode
Take a fu...
Let's assume that you have an availability group with only one secondary replica (you could easily expand this sample for more replicas)
1. Connections
You will need 3 connections:
AG listener (to run the query that will return which server is holding the primary an secondary)
Primary (to be...
> The dispute, which has played out in a series of closed-door meetings around the world over the past three years and has not been previously reported, turns on whether the International Organization of Standards should approve two NSA data encryption techniques, known as Simon and Speck. The U.S. delegation to the ISO on encryption issues includes a handful of NSA officials, though it is controlled by an American standards body, the American National Standards Institute (ANSI).
Oh gawd,
> ANSI, the body that leads the U.S. delegation to the ISO, said it had simply forwarded the NSA proposals to the organization and had not endorsed them.
It doesn't work like that, from the a mailing list thread in 2017-2018
We searching for continuous extent of second string trigrams (in original orders) which has best similarity with first string trigrams.
Possible solution could be forcing this extent boundaries to be at word
boundaries...
Meanwhile, in August 2009 "noise" was added as reason for comment flagging, and the comment flags show in the 10k tools. And Allow low-rep users to suggest edits is on its way. Hence: I don't care for this request myself anymore. An explicit [status-declined] would be fine.
What about being ab...
Is it possible to combine a "newer version" of the LDF file with an older version of the MDF file and keep changes logged in the LDF? Lets assume there has been no log-backups in the time between as I guess that would make this truly impossible.
Steps:
Database in full recovery mode
Take a fu...
Let's assume that you have an availability group with only one secondary replica (you could easily expand this sample for more replicas)
1. Connections
You will need 3 connections:
AG listener (to run the query that will return which server is holding the primary an secondary)
Primary (to be...
It doesn't work like that, from the a mailing list thread in 2017-2018
We searching for continuous extent of second string trigrams (in original orders) which has best similarity with first string trigrams.
Possible solution could be forcing this extent boundaries to be at word
boundaries...
