Error: The transaction log for database ‘xxxxx’ is full due to ‘ACTIVE_TRANSACTION’. Fix: Backup the transaction log. Set database recovery model from “Full” to “Simple”. If database setup for Always On, make sure Always On is working and synchronizing on all secondary database servers. Backup Transaction Log If you don’t care about the transaction log... » read more
Installing Failover Clustering feature using Server Manager The Failover Clustering feature can be installed with either Server Manager or Windows PowerShell cmdlets. In Server Manager, the Add Roles and Features Wizard is used to add roles and\or features. The Add Roles and Features Wizard are accessed in the Server Manager Menu bar by choosing Add Roles... » read more
https://outlook.office.com/
This website allows other people to control your PC Software from this website gives other people access to your PC – scammers might use it to secretly gain access to your personal info. If you’re asked to download software or give out your personal info, be sure it’s by someone you trust. Company Website https://www.connectwise.com/software/control... » read more
The SQL Server agent checks whether the job is already running before starting a new iteration. If you have long running job and its schedule comes up, it would be skipped until the next interval.
Issue: The transaction log for database ‘tempdb’ is full due to ‘ACTIVE_TRANSACTION’ Fix: Restart server to clear up tempdb. Tempdb database is part of SQL Server System database and gets created every time SQL Server Service starts. Tempdb stores temporary operations (like sorting and grouping data output etc) and tables, it stores lots of information in... » read more
AlwaysOn high availability group, HAG, is easier to maintain than log shipping. An AlwaysOn HAG gives you the flexibility of being able to fail over back and forth between your AlwaysOn replicas. Now lets take a look at Log Shipping. Without doing a cut and paste from the Microsoft books online there are five steps... » read more
Free Software by Igor Pavlov Download: https://www.7-zip.org/
Log on as a batch job This policy setting determines which accounts can log on by using a batch-queue tool such as the Task Scheduler service. When you use the Add Scheduled Task Wizard to schedule a task to run under a particular user name and password, that user is automatically assigned the Log on... » read more
You can use 7-Zip to create smaller multiple files. This is useful when you want to transfer large files and your VPN file transfer is very slow. You can specific how big to set each file. xxxxxx.7z.001xxxxxx.7z.002xxxxxx.7z.003 Select “Split to volumes, bytes” section option to split up the file to smaller files. Entering 20M for... » read more