Category
主题
副主题
How to create a simple database recovery solution using SQL Server log shipping (4213362)
To prevent accidental data loss, it is always good to ensure that there is a disaster recovery solution available. ... This can be easily achieved by having a standby copy of a primary database on another SQL Server instance, which can be achieved via log shipping.
Licensing and activation of centralized system products (4214761)
This article describes what you need to know about the licensing and activation of centralized ApexSQL products. ... Those currently includes ApexSQL Monitor, ApexSQL BI Monitor, ApexSQL VM Monitor, ApexSQL Defrag, ApexSQL Backup, ApexSQL Job and ApexSQL Audit.
Create daily database backups with unique names in SQL Server (4211374)
When working with a large number of databases on multiple SQL Servers, creating a foolproof disaster recovery plan can be challenging. ... Well organized backup and restore strategies will definitely help with this.
How to create and manage database backup chains in SQL Server (4291847)
Each event that causes data loss or disruption of regular daily operations on a SQL Server can be defined as a “disastrous” event. ... These events include power outages, hardware failure, virus attacks, various types of file corruption, human error, natural disasters, etc.
Restore a database to a point in time – part 2 (4210820)
In the first part of the series, we’ve showed how to perform a point in time restore using SQL Server Management Studio and ApexSQL Log. ... In the second part of the article, we’re going to introduce two more solutions – performing a virtual restore (in time) with ApexSQL Restore, and performing a full point in time restore with ApexSQL Backup.
SQL Server database shrink - How and when to schedule and perform shrinking of database files (4217555)
From time to time, DBAs find themselves in a situation where a SQL Server database becomes too large for their production environment, and needs to be shrunk in size in order to free space and allocate it back to the system.
How to verify SQL database backups (4304037)
When disaster strikes, the only thing more frustrating than not having an up to date and relevant database backup is having a corrupt backup. ... When you first create a backup file, it should be good, with 'should' being the operative word.
How to create multiple SQL Server backup mirrors (4213401)
One of the most important tasks for any database administrator is to create a foolproof disaster recovery plan. ... This plan usually includes multiple backup and restore operations. ... Most of the time, opting for conventional backups should suffice, but in some cases, storing all backups on a single backup device may prove to be a bad idea.
How to create Copy-Only backups in SQL Server (4296420)
Creating a foolproof disaster recovery solution is imperative for every business. ... Most DBAs tend to automate the majority of tasks related to database backup plans. ... Regular database backup schedules are set in order to create continuous backup chains, that can later be used to recover a database in the case of a disastrous event.
How to restore only a specific filegroup – A piecemeal restore (4209582)
What is a piecemeal restore? ... A piecemeal restores allow the user to restore only a specific filegroups from a database instead of restoring a whole database. ... In cases of emergency the important thing is to get the needed data as quickly as possible, and restore the rest of the data later while having the most significant data online.
How to automate the process of restoring a SQL database (4295643)
It’s very likely that you frequently refresh a development or test environment with recent production SQL server database backups. ... However, depending on the size and contents of a production database, this process might take a large amount of disk space and be pretty slow since the SQL server database backup needs to be fully restored.
How to automate DBCC CHECKDB after a database restore (4218639)
DBCC CHECKDB checks the logical and physical integrity of all the objects in a database and provides information of any corruption. ... As performing DBCC CHECKDB is a resource exhaustive task it is recommended to run it on a production server when there is as less traffic as possible, or even better, as one of the ways to speed up the DBCC CHECKDB process, is to transfer the work to a different server by automating a process and run CHECKDB after a database restore.
Manage and monitor SQL Server backups from a central location (4296111)
Running and maintaining multiple SQL Server instances can often be a formidable challenge, especially if these instances run on multiple servers. ... It is easy enough to set up a SQL Server agent job for each server to automate the backups, but what happens if there are 20, 30, or 100 servers that need maintenance?
Use database backups as live SQL Server databases to reduce downtime (4218279)
Being able to revert to the latest available backup immediately is a key requirement that every SQL Server DBA needs to meet. ... There are so many scenarios in which immediate action needs to be taken - starting from actual disk failure or corruption, system failure all the way to UPDATEs without WHERE clauses, malicious INSERTs or accidental DELETEs, DROPs or TRUNCATE operations.
How to backup multiple SQL Server databases automatically (4308042)
In situations with few databases, maintaining the regular backup routine can be achieved easily, either with the help of a few simple scripts, or by configuring a SQL Server agent job that will perform the backup automatically.
How to set up email notifications for backup jobs in SQL Server (4303289)
For a SQL Server DBA handling multiple databases on any given time, knowing how to set up regular backup schedules, backups with unique names on a daily basis, making backup mirrors for redundancy, cleaning up old backup files is important.
How to create SQL Server database split backup files (4291414)
One of the main tasks for every database administrator is creating a reliable disaster recovery plan. ... The plan always includes multiple backup and restore operations. ... Usually, opting for conventional, single file backups should suffice, but in some cases, resources like disk space, backup time, or both could be the issue.
Send logs feature in ApexSQL tools (4288785)
In this article, it will be explained how to use the Send logs feature for sending application log files through ApexSQL tools to the support team. ... Every ApexSQL tool collects all important information regarding work processes and stores them in the log files.
Is my ApexSQL application version vulnerable to Log4j - CVE-2021-44228? (4309395)
Determine if the installed ApexSQL application version is vulnerable to <a href="https://nvd.nist.gov/vuln/detail/CVE-2021-44228" target="_blank">Log4j - CVE-2021-44228</a>. The discovery of critical vulnerability <a href="https://nvd.nist.gov/vuln/detail/CVE-2021-44228" target="_blank">CVE-2021-44228</a> in the Apache Log4j library (CVSS severity level 10 out of 10). <p><strong>Unaffected products:</strong></p><p>ApexSQL Analyze<br>ApexSQL Audit<br>ApexSQL Backup<br>ApexSQL Build<br>ApexSQL Compare<br>ApexSQL Complete<br>ApexSQL Data Diff<br>ApexSQL Data Diff for MySQL<br>ApexSQL Database Power Tools for VS Code<br>ApexSQL Decrypt<br>ApexSQL Defrag<br>ApexSQL DevOps Toolkit<br>ApexSQL Diff<br>ApexSQL Diff for MySQL<br>ApexSQL Discover<br>ApexSQL Doc<br>ApexSQL Doc for MySQL<br>ApexSQL Enforce<br>ApexSQL Generate<br>ApexSQL Job<br>ApexSQL Log<br>ApexSQL Manage<br>ApexSQL Mask<br>ApexSQL Model<br>ApexSQL Monitor<br>ApexSQL Plan<br>ApexSQL Propagate<br>ApexSQL Pump<br>ApexSQL Recover<br>ApexSQL Refactor<br>ApexSQL Script<br>ApexSQL Search<br>ApexSQL Source Control<br>ApexSQL Trigger<br>ApexSQL Unit Test</p><p></p>
Microsoft SQL Server 2022 Support for ApexSQL Log? - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Source Control Action Center: how can one ignore user changes and not default select - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Unable to download free trail ApexSQL Devops Plus toolkit for ApexSQL doc - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Understand the true significance of "perpetual." - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Unable to download free trail ApexSql doc. - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
When will SourceControl work with MSSMS 2019? - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
新产品关联性