Tag: backup

backup – The media family on device incorrectly formed for read only file group restore

Yes the databases (source and destination) are the same version. I have checked 3 times. Both are “Microsoft SQL Server 2019 (RTM-CU8-GDR) (KB4583459) – 15.0.4083.2 (X64)”

The database itself restores ok without error. Only when I try the read-only file group restore does it give the error. I have redone the back up and attempted the restore again just in case I had something wrong with the backup.

I have done the numerous times with ss 2016 and even when upgrading from ss2016 to ss2019. But now I am testing the restores it just looks broken to me. Almost like this is a bug

Does PostgreSQL have some ability to “compare” a backup with the live database automatically and neatly?

I make full backups of my PG databases each day. I store these pg_dumped archives/blobs in a dir on the same computer, as well as on offline disks, up to a year before they are culled.

I’m constantly worried that my “live” data is being either deleted or modified by accident or through malice. It would be extremely useful to be able to do something like:

pg_compare.exe "path to pg_dump of my database X" "Database X" --deletes --updates

And then it would return a JSON array of any records found in the dump but not in the live database, as well as any changes in existing data found between the backup and the live database. (It would not care about new INSERTed rows, of course.)

Basically (translated to human form):

1. The row in table "invoices" with "id" 4825 has changed its numeric "amount" column cell from "49" to "499".
2. The row in table "bookkeeping" with "id" 13459 is no longer present.
3. ...

At the very least, this would help against honest mistakes and severely help against my paranoia and fear. As I’m working in pgAdmin 4, for example, I’m always worried that maybe I had selected a row out of sight or something as I press that “trash can” icon and then the “accept changes” icon. I don’t want to lose data.

It’s important that this can be done in an automated fashion, constantly behind the scenes (or maybe once a day if it’s resource-demanding). It must not involve manual creating of databases and a bunch of complex custom SQL queries etc. And please, no extensions! I hate extensions.

Is there such an ultra-useful feature built into PG?

backup – External HD FileVaulted

A friend of mind backup, (not via Time Machine) drag and dropped her files onto an external drive. This drive was password protected and encrypted though Disk Utility.

What she thought was the password is not. She knows the right number of characters but she can’t figure it out.

Can you use a brute force option on an external drive or will it lock her out?

If brute force an an option where do I find software for that?

Or is there some other option to end run this via the Terminal or such?

I know the news probably won’t be good, but………anything will help.

iphone – Creating a copy of an ITunes backup using Apple ComputerMobile SyncBackup folder

Instructions found on internet says that I need to edit the:
“Info.plist” file.
Here is where the backup folder was found: “C:Users%username%AppDataRoamingApple ComputerMobileSyncBackup” folder, where “%username%” represents your Windows username

Proceeding with the instructions: 1) I copied and pasted a copy of the backup folder.
2) Renamed the copy with date, time and “nickname”.
3) opened the copied folder and found the Info.plist file.
4) Used Windows Notepad to open the Info.plist in order to edit it.
5) as directed went to the bottom of the file for the purpose of finding “Yourname’s iPhone” per this instruction: “Edit the last line, which should look similar to ” Yourname’s iPhone”. Change it to something like “Yourname’s iPhone – Dec 12, 2013″ so that you can easily identify the date of the backup.”
6) there was no such ‘last line’.

So my questions are: A) how can I edit the copied backup folder’s Info.plist since I did not find that line?
B)The instructions indicate that the purpose of changing the last line is to differentiate it from all other backup folders. However, in the Library listing where I found the original file, I did change the name of the copied file so from that I can differentiate it from all others. So the question is: do I really need to change the last (non-existant) line of the Info.plist file when I can easily differentiate the copied backup folder by the name change I performed?

Any help is, of course, gratefully appreciated.

samsung – Does deleting a photo from my android phone’s gallery app also delete it from Google Photos(I have backup & sync turned on).If yes, how to prevent it

I have a samsung (android) device and I use samsung gallery app. Question: Does deleting a photo from the gallery app also delete it from Google Photos in which I have my backup and sync turned on. And if yes, then how to prevent it. ie I want a photo to stay in Google Photos even after I delete it from Samsung Gallery app.

PS: If the solution is to turn off sync then how to Turn on just backup on Google Photos without turning on sync.

Migration assistant won’t let me use an umlaut in the password for the encrypted time machine backup

I’m trying to restore a mac from a time machine backup. The time machine backup is found but requires a password and it happens to include one of those funny letters with an accent. The usual way to type those letters would be with option + u and the character you want the dots above, e.g. a. But when I click the option + u key I hear an error sound and no new character is added to the password field. Even ignoring that the password won’t work as it likely doesn’t write it out properly. I can’t copy past things, there is no accessibility keyboard… it seems I am unable to write my password…

Any way I can solve this at all?

I tried typing the password into the username field in an earlier screen and copy it but the clipboard is empty or pasting is disabled in the password field here.

I also don’t think you can remove/change passwords from encrypted backups even if you have the password?

enter image description here