SQL Server Job Overlap
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.
Author
Transaction Log for TempDB is Full
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
Log Shipping vs Always On
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
7-Zip File Manager Application
Free Software by Igor Pavlov Download: https://www.7-zip.org/
Account Log On Permission
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
Break Up Large File by Creating Smaller Multiple Files with 7-Zip
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
Always On and SQL Service Account
Account Setup: Use the same account to run all SQL Server service for all node in the cluster. Account has Administrator permissions on all servers in node. Set in “Local Users and Groups”. Account has sysadmin SQL permission on all servers in node. Set in “Local Security Policy”. Account has log on as service policy... » read more
SQL Server Service Account
AlwaysOn Cluster Setup: Use the same account to run all SQL Server service for all node in the cluster. Account has Administrator permissions on all servers in node. Account has sysadmin SQL permission on all servers in node. Account has log on as service policy on all servers in node. Note: Always use SQL Server... » read more
Log on locally
Problem: Unable to remote desktop on to server. Fix: Make sure the service account running the service is added to “Allow log on locally” Local Security Policy -> Local Policies -> User Rights Assignment -> “Allow log on locally”
Database States
Database State Definitions The following table defines the database states. State Definition ONLINE Database is available for access. The primary filegroup is online, although the undo phase of recovery may not have been completed. OFFLINE Database is unavailable. A database becomes offline by explicit user action and remains offline until additional user action is taken.... » read more