@scottalanmiller said in Recovering SQL Server 2005 Databases:

Anyone had any luck mounting SQL Server 2005 MDF/LDF to a new SQL Server version
You can move SQLServer 2005 to a new Server version by following this guide: https://solutioncenter.apexsql.com/restore-sql-server-backup-to-a-newer-version-of-sql-server/

@openit said in Building your own lab:

@scottalanmiller @Pete-S
Do we have any complete post or article on ML which describes how to build a Lab with design, like server, switch etc. arrangement.

Really appreciate, if someone can provide any links, which gives complete lab design, to prepare me as a good Windows System Administrator, which should include all tasks, activities a typical SysAdmin requires.

https://www.servethehome.com/

Some tasks would be setting up a monitoring alert system that alerts you of reboots, account lockouts, high CPU usage, disk usage, network, etc. Get familiar with using PowerShell to manage your Windows systems. Setting up a Dev or test to in order test your Windows or 3rd party applications before deploying to production.

@EddieJennings said in Use PowerShell to Disable UAC on Windows 10:

@Obsolesce said in Use PowerShell to Disable UAC on Windows 10:

What special case needs UAC completely off?

I'm curious about this as well.

Installing malware 🙂

@scottalanmiller said in Automated NextCloud Backup to Wasabi or Amazon S3:

@VoIP_n00b said in Automated NextCloud Backup to Wasabi or Amazon S3:

@scottalanmiller said in Automated NextCloud Backup to Wasabi or Amazon S3:

It is indeed. It's running now.

How much data? How long is it taking?

Note: Use the -P/--progress flag to view real-time transfer statistics 🙂

260GB or so, nothing crazy. Not sure, ran it overnight.

Also, WTF... Who watches backups real time?

Ok HP clarifies and said USB A is not powerful enough to deliver a meaningful charge.

https://store.hp.com/us/en/tech-takes/3-different-ways-to-charge-laptop-without-charger

@JasGot said in Skyetel Postcards Redirect Issue:

I believe ./run.sh restarts all services, and I suspect that includes Nginx.

Yes, Nginx is inside a Docker container. But there are three.

All you need is...

systemctl start docker systemctl enable docker

And you are good to go. It's just a process that needs to be started like any other. There's nothing to know about Docker in this instance. Think of it as the server itself, it just needs to be turned on.

Found it -- test-compliance.

@Pete-S said in Is certbot the best way to handle Let's Encrypt certs?:

@stacksofplates said in Is certbot the best way to handle Let's Encrypt certs?:

Lego is another good one from what I've seen. It does all 3 challenge types.

https://go-acme.github.io/lego/

Thanks, might have a look at it next time.

I went with certbot this time because it was very clear what needed to be done. Debian has a package for it's all you need to do is have a http server up and running and then:

# apt-get install certbot python-certbot-apache # certbot --apache

It will do everything for you - create & install the certificate, set up redirection from http to https, set up a job that updates the cert etc.

The site has instructions for every common OS (redhat, ubuntu etc) and http daemon (apache, nginx etc) combination.
https://certbot.eff.org/lets-encrypt/debianbuster-apache

Yeah certbot is the easiest. Lego is just more flexible and you only need the binary. Def start with the easiest for now.

EdkJFXDVoAEXM2i.png

@gjacobse said in NextCloud: Chmod user folders:

Oh - no - the syntax is incorrect for ownership.

sudo chown

Yes,

chown to change owner chmod to change mode (permission)

Remember you can always do man chown to see the syntax.

@scottalanmiller said in MeshCentral Run Commands on Multiple Computers at Once:

"Starting with MeshCentral v0.5.85, you can now select "Run Commands" in the group actions or device actions. Allows running shell commands on many devices at once."

Ecq0qLrUcAEBBek.png

Wow, this is going to really change the way we use Mesh! Awesome stuff!

That seems to have fixed the issue

@ilyas said in Reset 120 Day Grace Period for Windows RDS Server with PowerShell:

@scottalanmiller

Hi, Thanks for wonderful script that save my time.
Could You please guide me how we can run this script on multiple servers?

I tried foreach PowerShell method but it does not work.

From the ISE, load the script and then enter-pssession for each system. Once connected, run the script from the ise. Sorted.

@Texkonc said in Internet outage:

@JaredBusch said in Internet outage:

@PhlipElder said in Internet outage:

@JaredBusch said in Internet outage:

@PhlipElder said in Internet outage:

https://www.cloudflarestatus.com/incidents/46z55mdhg0t5

Hmmm ... this from a little over a year ago.

Same "problem".

Routing is not magic. Errors happen.

That may be so, but the expectation is that the same errors would not happen over and over again.

FFS It is not the same. Are you stupid?

Jesus, calm down. No one pissed in your corn flakes...

No kidding. Don't go all Boomtown Rats on me. 😛

So far the rebuild appears to be still working. It ran all night. No complaints yet.

We know this is a domain, we don't know that the user is using a Windows PC. @AshKetchum is this a Windows PC? Also why the need to do so discreetly?

You can do as Travis/Jared said or use something like scp to do this.

I ran some test on a VM and created some groups and added some top-level directories for those groups.

Changed the group on each top-level directories and files below recursively with chown -R.

Set directories to permission 2770 and files to 0660 with chmod -R.

Changed smb.conf and added create mask=0660 and directory mask=2770.

Now new files and directories created on the share have the right permission and belongs to the right group automatically, simply depending on what group the top-level directory belongs to.

If you're not a member of a group, you will not even see the directories or files that belongs to that group.

I think this is a good interim solution without too much work. Then moving to onedrive or whatever can be done in the future on a department to department basis.

Only admin required for adding users is to add them to linux/samba and make sure they become members of the right groups.

It's also very simple to make a separate share out of the top-level folders if you wanted.

@JaredBusch

Everything works fine now.

The issue was a DNS resolution for devices within the LAN. I added an A record on the router for split dns. That solved the problem.

Thank you so much for your support