Blog do Edu

How to fix The transaction log for database is full due to 'LOG_BACKUP'.?

2024-10-09T02:43:00.000-07:00

See this

https://learn.microsoft.com/en-us/sql/relational-databases/logs/troubleshoot-a-full-transaction-log-sql-server-error-9002?view=sql-server-2017#common-reasons-for-a-full-transaction-log

Backup copy https://web.archive.org/web/20240000000000*/https://learn.microsoft.com/en-us/sql/relational-databases/logs/troubleshoot-a-full-transaction-log-sql-server-error-9002?view=sql-server-2017

or quick fix, set db recovery to simple

https://www.mssqltips.com/sqlservertutorial/3311/how-to-shrink-the-transaction-log/

Backup copy

https://web.archive.org/web/20240616094706/https://www.mssqltips.com/sqlservertutorial/3311/how-to-shrink-the-transaction-log/

Mail client auto-configuration files for virtualmin

2017-02-24T09:24:00.006-08:00

Mail client auto-configuration files for virtualmin

The following auto-configure files works for virtual hosts with SSL enable for IMAP and TLS for SMTP

Thunderbird auto-configuration XML

<?xml version="1.0" encoding="UTF-8"?>

<domain>$SMTP_DOMAIN</domain>

<displayName>$OWNER Email</displayName>

<displayShortName>$OWNER</displayShortName>

<username>$SMTP_LOGIN</username>

</incomingServer>

<socketType>STARTTLS</socketType>

<username>$SMTP_LOGIN</username>

</outgoingServer>

</emailProvider>

</clientConfig>

Outlook auto-configuration XML

<?xml version="1.0" encoding="utf-8" ?>

<AccountType>email</AccountType>

<Action>settings</Action>

<LoginName>$SMTP_LOGIN</LoginName>

</Protocol>

<LoginName>$SMTP_LOGIN</LoginName>

</Protocol>

</Account>

</Response>

</Autodiscover>

Long Path when coping from shadow copies

2015-12-11T13:41:00.000-08:00

See for the simplified version:

https://bennettadelson.wordpress.com/2012/02/01/previous-versions-and-shadow-copies-with-very-long-paths/

and this for the original version

http://blogs.msdn.com/b/adioltean/archive/2008/02/28/a-simple-way-to-access-shadow-copies-in-vista.aspx

Backups
http://web.archive.org/web/*/https://bennettadelson.wordpress.com/2012/02/01/previous-versions-and-shadow-copies-with-very-long-paths/
http://web.archive.org/web/*/http://blogs.msdn.com/b/adioltean/archive/2008/02/28/a-simple-way-to-access-shadow-copies-in-vista.aspx

Block Windows 7 / 8 from upgrading to Windows 10

2015-12-03T03:11:00.004-08:00

http://www.itworld.com/article/2984220/windows/how-to-block-windows-7-or-windows-8-pcs-from-automatically-downloading-windows-10.html

List all recepients in all Distribution Lists in Office365 / Exchange in powershell

2015-11-02T11:26:00.000-08:00

List all recipients in all Distribution Lists in Office365 / Exchange in powershell

To the screen:

To a File

foreach ($group in Get-DistributionGroup) { get-distributiongroupmember $group.Identity | sort displayname | ft @{expression={$_.displayname};Label="$group"}, @{expression={$_.PrimarySmtpAddress};Label="Emailadres"} | Out-File c:tempDistributionListMembers.txt -append}

Inspirations:

http://www.oxfordsbsguy.com/2014/04/21/exchange-powershell-how-to-enumerate-distribution-lists-managers-and-members/
https://social.technet.microsoft.com/forums/windowsserver/en-US/9a8f028c-db75-4659-8c70-984ab57ad5cc/get-list-of-distribution-groups-that-user-is-a-member-of

Ordem de cópia entre empresas Sage Gestexper GCO

2015-10-28T03:46:00.001-07:00

Actividades
CdPag
CodPod
Idiom
FmArt
Armz
Conce
Grupo
Postos
TpDoc
Tlanc
TLPro
TLMod
Areas
Vendr

Fornc
Artigos

Oper
Perms

Tabelas->Operadores e Permissões->Operadores

Windows 8 Pasta de Arranque

2015-08-20T06:54:00.003-07:00

http://www.softwareok.com/?seite=faq-Windows-8&faq=206

Windows 8.1 Não mapeia as drives no incio

2015-08-20T06:53:00.001-07:00

https://gist.github.com/tkarpinski/1566071

Categorias de Artigos

2015-05-14T04:43:00.003-07:00

Categorias de Artigos

M - MERCADORIAS

“Respeita aos bens adquiridos pela empresa com destino a venda, desde que não sejam objecto de trabalho posterior de natureza industrial.” – POC

P - MATÉRIAS-PRIMAS, SUBSIDIÁRIAS E DE CONSUMO

Matérias primas e outras para fabricação de produtos.

A - PRODUTOS ACABADOS E INTERMÉDIOS

Inclui os principais bens provenientes da actividade produtiva da empresa, assim como os que embora normalmente reentrem no fabrico podem ser objecto de venda.” – POC

S - SUBPRODUTOS, DESPERDÍCIOS, RESÍDUOS E REFUGOS

Representam produtos secundários, de reduzido valor económico, resultantes do processo produtivo da empresa. Subprodutos – bens obtidos simultâneamente com os principais.

Ex.Serradura numa serração (tem reduzido valor económico)

Desperdícios, resíduos e refugos – São os outros bens derivados do processo produtivo (ex. trapos das têxteis)

T - PRODUTOS E TRABALHOS EM CURSO

Trata-se de produtos em fabricação não estando em condições de serem armazenados ou vendidos.
Produtos Acabados e Intermédios.

Referencias:

http://icm.clsbe.lisboa.ucp.pt/docentes/url/sic/cfii/Aula%2005.pdf. Arquivo
http://www.ipb.pt/~hn2r/index_files/sebenta2.pdf Arquivo

Bind DNS records for Google Apps

2014-10-28T09:41:00.000-07:00

If you are configuring a domain on Google Apps and the domain name server for that domain is running on BIND just add this records to the zone file. Just change "change.me" to yourdomain.us.



change.me. 1H IN MX 1 ASPMX.L.GOOGLE.COM.

change.me. 1H IN MX 5 ALT1.ASPMX.L.GOOGLE.COM.

change.me. 1H IN MX 5 ALT2.ASPMX.L.GOOGLE.COM.

change.me. 1H IN MX 10 ALT3.ASPMX.L.GOOGLE.COM.

change.me. 1H IN MX 10 ALT4.ASPMX.L.GOOGLE.COM.

DNS Bind Records for Office365

2014-10-24T13:42:00.000-07:00

If you are configuring a domain on Office365 and the domain name server for that domain is running on BIND just add this records to the zone file. Just change "change.me" and "change-me" to yourdomain.us and youdomain-us



change.me 3600s IN MX 0 change-me.mail.protection.outlook.com.

change.me  IN TXT "v=spf1 include:spf.protection.outlook.com -all"

autodiscover.change.me  IN CNAME autodiscover.outlook.com.

msoid.change.me  IN CNAME clientconfig.microsoftonline-p.net.

_sip._tls.change.me  IN SRV 100 1 443 sipdir.online.lync.com.

_sipfederationtls._tcp.change.me IN SRV 100 1 5061 sipfed.online.lync.com.

sip.change.me  IN CNAME sipdir.online.lync.com.

lyncdiscover.change.me  IN CNAME webdir.online.lync.com.

enterpriseregistration.change.me 1h IN CNAME enterpriseregistration.windows.net.

enterpriseenrollment.change.me 1h IN CNAME enterpriseenrollment.manage.microsoft.com.

Intel NUC Wireless correct instalation

2014-06-16T11:42:00.002-07:00

Intel NUC Wireless correct instalation

Install the wireless card
Connect the black wire to connector 1
Connect the grey wire to connector 2

NUC Wireless Card Installed

Error sysprep Windows 8.1

2014-05-21T13:22:00.001-07:00

Getting error syspreping Windows 8.1?

Try on an administrator powershell session:

Get-AppxPackage -AllUsers | Remove-AppxPackage

or with a more selective approach

http://gallery.technet.microsoft.com/scriptcenter/Remove-Windows-Store-Apps-a00ef4a4

https://social.technet.microsoft.com/Forums/windowsserver/en-US/7c66c123-39fc-426a-8fbb-feb78ea08d3c/windows-server-2008-sysprep-error-error-0x0f0073-sysprp-runexternaldllsnot-running-dlls-either?forum=winserversetup

Relatório Único 2013

2014-04-11T02:54:00.004-07:00

Link para a aplicação de preenchimento do Relatório Único de 2013

https://www.relatoriounico.pt/ru-app_2013/application/launch.jnlp

Azure VM Static Ip Address

2014-03-09T03:22:00.002-07:00

http://windowsitpro.com/windows-azure/set-azure-vm-static-ip-address

Microsoft Exchange 2003 Raising the limits over 16G on datastores

2013-11-19T03:18:00.003-08:00

http://support.microsoft.com/kb/912375

Microsoft Windows 7 patch to delete old Windows Updates

2013-11-06T07:00:00.001-08:00

http://support.microsoft.com/kb/2852386

Kloxo, secundary domain name server solution

2013-11-03T14:55:00.000-08:00

Follow this (not my instructions) (from http://project.lxcenter.org/issues/969)

Secondary DNS
The previous tutorial described a DNS server on the same machine as the web server using a single IP address. That works just fine if all you are doing is hosting simple websites. In that case, a good argument can be made that if the web server goes down for some reason (along with the DNS server, most likely), that a secondary DNS server can’t help visitors get to your website because the web server is down anyway. And all of that is true.
Where it makes a difference is when you have clients who are counting on email that is handled by your server. So if you have a business that is hosting its email with you and both your server and DNS are down, mail will be immediately returned to senders as a bad email domain. That’s obviously not good for business. But if you had a secondary DNS server running someplace the sender’s email server will hold the email message until your email server comes back up, then try sending again.
So if your business reaches a point where you believe that a secondary DNS server is necessary, you need to consider a solution. If you only have a limited number of domains then you might consider a free service to host your secondary DNS. You might consider BuddyNS.com for that. It’s very good service, and you can host an unlimited number of DNS zones (domains) with them, but you will have to enter new domains manually.
If you are going to be running a hosting business where a lot of domains are likely to be created or deleted, particularly if you are going to have resellers who will be creating domains that you aren’t even aware of, then you need to find a more automated solution. To that end, I am going to provide an automated method of making the slave DNS server aware of new or deleted domains.
It’s important to understand that while BIND comes with the capability to automatically update zones, it does not have the capability to know when new zones are added in the master DNS server. The first part of this tutorial will be to take care of that by transferring a zone list to the slave server.
These steps are done in the Master DNS server
The first thing that needs to be done is to create a zone listing file in the master DNS server machine that can be used as a .conf file by BIND in the slave DNS server. However, we’ll use the file extension .txt in this script, since Apache is funny about transferring .conf files.
You will need to determine where the active .conf file is on the master DNS server. The BIND default location is /etc/named.conf, but I use the Kloxo control panel so my conf file happens to be:
/var/named/chroot/etc/kloxo.named.conf
Also you need to decide where your zone files should be in the slave machine. In my case I wanted the files to be in the following directory.
/var/named/chroot/var/named/slaves/dallas/named/
Note that I used “dallas” in the path, since my master DNS server VPS happens to be in Dallas. That not only leaves room for future server locations, but also keeps files orderly. With my master DNS server in Dallas and my slave DNS server in Denver, I keep things straight by referencing those locations. For that
2
reason, I’ll called the script we are going to create updatedenver. So you should use a text editor to create a file in /var/named/ called updatedenver, then paste the following code into it.
#!/bin/sh
#
for domain in `grep ^zone /var/named/chroot/etc/kloxo.named.conf |grep "type master" |/bin/awk '{print $2}' |/bin/awk -F\" '{print $2}'`
do
/usr/bin/printf "zone \"${domain}\" { type slave; file \"/var/named/chroot/var/named/slaves/dallas/named/${domain}\"; masters { 174.34.133.23; }; };\n"
done > /home/admin/entomy.com/dns/updatedenver.txt
In the first line of code (the “for” statement), the only thing you need to change is the path to your named.conf file. In this case it will be the path to the kloxo.named.conf.
In the “printf” statement, change the path to where you want to zone files to be put. Change the IP address (174.34.133.23) to the IP address of your master server. When this conf file is eventually applied in the slave DNS server, BIND will create empty zone files in the slave server according to where you specify in this statement.
In the last line (i.e., the“done” statement) enter the path to a web accessible location to deposit the output file of this script, usually someplace in /var/www… or someplace in /home/…
Once you are finished editing the file, save it. I called my script updatedenver and put it in the /var/named/ directory, which will work fine.
Now login to SSH as root and enter the following command to make sure that the web accessible script is writable. You will edit the path to the web accessible location of your choice.
# mkdir /home/admin/entomy.com/dns/
# chown 755 /home/admin/entomy.com/dns/
Now test run the script.
# sh /var/named/updatedenver
Check the output of the script buy navigating to the web accessible directory and opening the output file with a text editor. Mine is located at.
/home/admin/entomy.com/dns/updatedenver.txt
You should see a line in that file for each existing zone, specifying the path location for the zone file in the slave DNS machine.
Once you get the script running properly, you should create a cron job to run the script at regular intervals. In this case, we’ll run it once per hour so there will always be a fresh listing of your zones available to the slave DNS server to fetch. Using webmin, click the System icon at the top and click the Scheduled Cron Jobs icon. Click the “Create a new scheduled cron job” link. Fill it out like this:
3
That concludes the Master DNS server configuration, at least as far as updating zone names is concerned.
These steps are done in the Slave DNS server
The objective of this section is to configure the slave DNS server to fetch a zone information file from the master DNS server, place the file in a location that is accessible to BIND, and then apply those zones to BIND by restarting the application. To do that you need to create a script.
Create a text file and paste the following code into it:
#!/bin/sh
wget http://entomy.com/dns/updatedenver.txt -O /var/named/chroot/var/named/slaves/dallas.conf
/etc/init.d/named restart
The wget statement fetches the file from the master DNS server, and then saves it as a file called dallas.conf in the specified location. You will need to edit the URL of the text file location to the actual web accessible location you put it in on the master DNS server. Likewise, edit the name and location of the .conf file to your liking. When done, save the file. I called the file getdallas, since my master DNS server is in Dallas, and saved it in the var/named/chroot/var/named/slaves/ directory, the same location as I put the .conf file.
Now open your named.conf file (normally found in /etc) and place this statement at the end of the file.
4
include "/var/named/chroot/var/named/slaves/dallas.conf";
You will need to edit the path and file name to match the location of the .conf file you specified in the script. Save the file. Also not that if BIND is running “chrooted” (as it is under Kloxo) that the path will be shortened to make the command look like this.
include "/var/named/slaves/dallas.conf";
Now login to SSH as root and create the .conf file so it can be written to by your script, editing for the proper path and file name, of course.
# touch /var/named/chroot/var/named/slaves/dallas.conf
Create the directory for the zone files to be created in, make the directory writable, and then restart BIND.
# mkdir /var/named/chroot/var/named/slaves/dallas/
# mkdir /var/named/chroot/var/named/slaves/dallas/named/
# chown 777 /var/named/chroot/var/named/slaves/dallas/
# chown named:named /var/named/chroot/var/named/slaves/dallas/
# chown 777 /var/named/chroot/var/named/slaves/dallas/named/
# chown named:named /var/named/chroot/var/named/slaves/dallas/named/ # /etc/rc.d/init.d/named restart
Of course, all of the above can be done a lot quicker & easier using the webmin file manager, but it works fine from the command prompt.
With those tasks done, test run the script from the command prompt.
/var/named/chroot/var/named/slaves/getdallas
With any luck, your output will look like this.
5
You can see from the output that the file was fetched, saved in the proper location, then named was restarted successfully.
Once you have the script running the way you want it to, create a cron job to run the script soon after the script on the master DNS server runs. Scheduling the scripts to run once or twice an hour is normally sufficient for redundant DNS.
Note that the zone files that were created from these scripts will be empty files. These scripts are only intended to make the slave DNS server aware of changes in the master DNS server zone listing. You will need to configure another solution to fetch the zone file contents, such as AXFR, rsync, or scp. However, it’s important to note that any zone files that existed in the slave DNS server before the script was run that already contained zone details will not be overwritten.

Domain testing webtools

2013-11-03T14:48:00.000-08:00

Just some sites I use to test my dns domain configurations

http://www.dnsqueries.com/en/
http://mxtoolbox.com/
http://dnscheck.pingdom.com
http://dnscheck.iis.se/

Solve authentication problems when connecting to a Hyper-V Server

2013-10-27T10:36:00.000-07:00

Use

http://code.msdn.microsoft.com/windowsdesktop/Hyper-V-Remote-Management-26d127c6

Unable to change product key Windows 2012

2013-10-15T04:16:00.001-07:00

Run this command on the command line

Slui.exe 0x3

or

Cscript.exe %windir%\system32\slmgr.vbs /ipk <Product key>

Linux RAID Recovery

2013-05-17T11:28:00.002-07:00

mdadm --assemble /dev/md1 /dev/sd{b,c,d,e,f}1 -v -f

mdadm --manage -a /dev/md1 /dev/sdc1

Disable automount of raid drives at boot up on Ubuntu

2013-05-17T10:55:00.001-07:00

Just del/move /usr/share/initramfs-tools/scripts/local-premount /md and do update-initramfs -u

X install in Centos

2013-04-06T08:11:00.001-07:00

yum groupinstall "X Window System"

Testing if Exchange 2007 2010 services are started

2013-03-13T06:21:00.000-07:00

Open the Exchange Command Shell and type:

Test-ServiceHealth

[PS] C:\Windows\system32>Test-ServiceHealth

Role          RequiredServicesRunning ServicesRunning        ServicesNotRunning
----          ----------------------- ---------------        ------------------
Mailbox       True                    IISAdmin
                                      MSExchangeADTopology
                                      MSExchangeIS
                                      MSExchangeMailboxAssis
                                      tants
                                      MSExchangeMailSubmissi
                                      on
                                      MSExchangeRepl
                                      MSExchangeSA
                                      MSExchangeSearch
                                      MSExchangeServiceHost
                                      MSExchangeTransportLog
                                      Search
                                      MSFTESQL-Exchange
                                      W3Svc
Client Access True                    IISAdmin
                                      MSExchangeADTopology
                                      MSExchangeFDS
                                      MSExchangePOP3
                                      MSExchangeServiceHost
                                      W3Svc
Hub Transport True                    MSExchangeADTopology
                                      MSExchangeEdgeSync
                                      MSExchangeTransport
                                      MSExchangeTransportLog
                                      Search

Role          RequiredServicesRunning ServicesRunning        ServicesNotRunning
----          ----------------------- ---------------        ------------------
Mailbox       False                   IISAdmin               MSExchangeSearch
                                      MSExchangeADTopology   MSFTESQL-Exchange
                                      MSExchangeIS
                                      MSExchangeMailboxAssis
                                      tants
                                      MSExchangeMailSubmissi
                                      on
                                      MSExchangeRepl
                                      MSExchangeSA
                                      MSExchangeServiceHost
                                      MSExchangeTransportLog
                                      Search
                                      W3Svc
Client Access True                    IISAdmin
                                      MSExchangeADTopology
                                      MSExchangeFDS
                                      MSExchangePOP3
                                      MSExchangeServiceHost
                                      W3Svc
Hub Transport False                   MSExchangeADTopology   MSExchangeEdgeSync
                                      MSExchangeTransportLog MSExchangeTranspor
                                      Search                 t