@Matthew-Grieve said in How to Backup Patterson Dental EagleSoft Software:

https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbadmin/da-backup-dbs-5615940.html

SQL Anywhere Volume Shadow Copy Service (VSS)
SQL Anywhere is compatible with the Microsoft Volume Shadow Copy Service (VSS). You can use VSS to create point-in-time snapshots of entire disk volumes or volume sets and to make copies of files that are open for exclusive use by applications such as the SQL Anywhere database server. VSS is supported on 32-bit Windows XP operating systems and on 32-bit and 64-bit editions of Windows 2003 and later operating systems, including Windows Vista.

By default, all SQL Anywhere databases can use the VSS service for backups if the SQL Anywhere VSS writer (dbvss12.exe) is running. You can use VSS without the SQL Anywhere VSS writer to back up databases. However, you might need to use the full SQL Anywhere recovery procedures to restore those databases. To prevent a database server from participating in the VSS service, include -vss- when starting the database server. Alternatively, you can use the Service utility (dbsvc) for Windows to specify when the VSS service is started.

How VSS works with SQL Anywhere:

Your backup application sends a command to VSS to take a snapshot.

VSS issues an identify command to the SQL Anywhere VSS writer (dbvss12.exe).

VSS issues a prepare to snapshot command to suspend all transactions and write all modified pages to disk on all databases on all database servers. If transactions are not suspended on a database within 10 seconds, the snapshot might contain uncommitted transactions and full recovery may be necessary.

VSS issues a freeze command to checkpoint and then suspend all activity on all databases on all database servers. Each SQL Anywhere database server waits a maximum of 60 seconds for all databases to suspend all activity. Typically, this process takes a few seconds.

VSS issues a thaw command to the SQL Anywhere VSS writer to resume all transactions on all databases on all database servers.

In rare circumstances, SQL Anywhere might be unable to suspend transactions or complete a checkpoint within the maximum time allowed by VSS. If this occurs, you must use the transaction log file and the full recovery process to recover the backed up database.

We use StorageCraft ShadowProtect with ImageManager to take hourly incrementals of our clients server volumes. Never had any issues.

That's true when you have SQL Anywhere running as a service. But when embedded, there is nowhere for the VSS to link against. Are you sure that this process will work with EagleSoft and their implementation of SQL Anywhere? I know that a full blown SQL Anywhere can do it. But that's not the issue here.

@scottalanmiller said in Windows 2022 Disk Defrag Freezing System:

@Obsolesce said in Windows 2022 Disk Defrag Freezing System:

You should never Defrag SSDs except for very specific reasons.

Which is why it is surprising that in the SSD era, Windows 2022 has it on by default.

Has Microsoft changed how they handle TRIM yet? I know years ago they only ran TRIM when defrag was run. Why? Because Microsoft is still that bad at managing storage.

@jt1001001 said in Marketing - Video Editing Storage:

I don't' have any specific product but Atto Technologies comes to mind to look at for something like this.

They make pieces for building a serious enterprise scale media workflow like HBAs and iSCSI options for MacOS. Their focus is specialty high performance Mac hardware. I don't think that they offer any solutions, but they have nice components and some software.

@Pete-S said in Easy Computer to Computer File Transfer Over Internet:

@VoIP_n00b said in Easy Computer to Computer File Transfer Over Internet:

@Pete-S said in Easy Computer to Computer File Transfer Over Internet:

@VoIP_n00b said in Easy Computer to Computer File Transfer Over Internet:

Reading thought your requirements again SyncThing is perfect for what your looking to do

Synthings goes through community hosted intermediate servers, called relay servers, so it's not direct. https://relays.syncthing.net/

https://docs.syncthing.net/users/relaying.html

Yes, that's exactly what I'm saying.

The normal situation between two residential computers is that a direct connection is never possible because they're both behind NAT or CGNAT.

A direct connection is only possible if you're willing and able to do port forward on either side.

You have no idea what you are saying.

Syncthing has relay enabled by default, yes, but it does not route traffic through it by default.

When you launch syncthing it uses their public STUN server to resolve your local info.

[PGGH6] 2023/03/13 20:20:39 INFO: quic://0.0.0.0:22000 resolved external address quic://209.XXX.XXX.XXX:22000 (via stun.syncthing.net:3478)

Then when you try to connect from a remote, it uses that connection first. It only relays if that listener has closed.

@BraswellJay said in Can the target of a One Drive link be changed ?:

@Obsolesce said in Can the target of a One Drive link be changed ?:

@scottalanmiller said in Can the target of a One Drive link be changed ?:

I don't know any platform like that that has built in editors to modify the files that are in the storage

OneDrive does let you edit files directly, in the storage.

How were you able to bring up the editor? Did you just click on file name? When I do that on a url link file it just takes me to the file that the link is pointing to. I can then edit that target file. In my case it brings up an image editor since the target is a .png file. I can't seem to find a way to edit the text of the url link file itself without downloading it first.

I just clicked on the file.

However, if you really think about it, you want exactly the behavior you are seeing. Imagine if clicking on the .url file it brought up the editor for users instead of taking them to the pointer file?

That said, can you right-click on it in the browser and open it in text editor? If not, then I guess you'll just have to do it on your computer.

@Pete-S said in Dell Server: The server power action is initiated because the host device initiated a warm-reset operation.:

@scottalanmiller said in Dell Server: The server power action is initiated because the host device initiated a warm-reset operation.:

Just verifying that this log entry tells us that a human hit the power button on the server? This is a log entry in the iDrac.

I don't think so. Warm reset is a reset, like the reset button or alt+ctrl+del.

If you press the power button you get a shutdown / power down but not reset, because after power off it will not start again.

If you have another Dell server available maybe you can verify.

Power button press = Graceful Shutdown
Power button press and hold = Power Off

@gotwf said in Setup NodeBB on Fedora 33 with PostgreSQL and Nginx with HTTPS only:

@JaredBusch So... now that you've had this up and running for a while, care to report on how that is going? Inquiring minds are curious. Particularly w.r.t. resource utilization comparison, performance differences, etc. comparatively. I think you were on Mongo previously, correct? Cuz I am right there with you on the license bullshit. All it takes is one bump in the road, merger, and wham, history repeats and next major version changes license again - only this time to something closed. Have no interest in betting on community to fork and continue. Need a safer bet. It would appear that percona may have already done so w/their percona mongodb offering but I wonder if that would continue as a full fork if/when upstream became closed source.

TIA-- o/

Well 2 years in, i do not run any NobeBB instances with heavy traffic so performance is not even something I look at. I have like 5 of these running for tiny personal projects that people I know have asked for my help with.

@PhlipElder said in MS Edge and pop-ups:

@gjacobse Sorry I wasn't clear. At some point the user was looking for something and clicked on a link in the results that then inserted something into Edge that causes the pop-ups.

We've seen it often enough that we've added search training to our Train the Human regimen.

That - I can see.

@Skyetel said in Skyetel billing error:

Believe it or not, it was caused by a rouge "%" in a SQL query.

Since % is a wildcard, yeah I can see that.

@Pete-S said in ProxMox: Set VM to AutoStart from Command Line CLI Start:

Nice but it's even easier with pure kvm as you don't have to go the roundabout way of using VMid.

virsh autostart somevm

Personally I find the number quite a bit easier.

@Pete-S using your little snippet did not clean up the pinned start menu of the initial admin user that ran it, nor the non admin user account that I subsequently created.

f2e6d053-0b72-4407-9ba8-b1d9dd3d75c8-image.png

It xbox was still in the start menu, but the rest looked gone.
da69b05a-32c4-40e7-ba6d-03ae78e2b092-image.png

@PhlipElder said in Rack LCD Console with Digital KVM:

SIP = Server endpoint?

Server Interface Pod

Taking over a location from an MSP and I found that there were two accounts that were created in 2019 with only one login on that date in 2019, and the password was listed in the account description field..... Luckily this domain will only exist for about a week under our control before we move them to our domain.

Drafted an email for my management to review before I email the CEO of that MSP. Just to make sure it doesn't backfire on me. CYA since I am about to call out an MSP at horrible security.

@NashBrydges Did you try switching the positions of existing CPUs?

@Pete-S said in Force password change on first login over RDP:

Great, so it works if you use RDWeb.

But if you RDP directly to any Windows server or workstation it won't.

Nope. It won't. There's no way around that.

We also have Exchange on-premises so OWA works for that password change.

@PhlipElder 67f0f91e-9123-4f6d-b388-cac7b787e704-image.png
Don't forget to ground that sucker.

...

@Pete-S said in Bookstack - Line break instead of Paragraph:

@dafyre said in Bookstack - Line break instead of Paragraph:

@pmoncho Does SHIFT+ENTER work?

Ctrl+Enter is otherwise the usual key combo.

Thanks. This is to used to save the page.