Category
主题
副主题
How to build a SQL database directly from scripts (4283908)
How to build a SQL database directly from scripts "<p> In a SQL database lifecycle two major deployment tasks are: the building of a new SQL database and an upgrade of the existing one. ... ApexSQL Diff is a <a href="" target="_blank">SQL database comparison</a> tool that can help for both of them; it allows deploying SQL scripts saved in a script folder to a new or an existing SQL database.
How to activate ApexSQL software manually (4216052)
To activate an ApexSQL product online, a Hardware ID and a product activation key are needed. ... To manually activate an ApexSQL product online: ... Navigate to ‘ Product activation’ web page ... Select the ApexSQL product to be activated from the ‘Product’ pick list and the appropriate product version from the ‘Version’ pick list
Why, when and how to rebuild and reorganize SQL Server indexes (4281054)
Why, when and how to rebuild and reorganize SQL Server indexes "<p> The purpose of SQL Server index is pretty much the same as in its distant relative – the book index – it allows you to get to the information quickly, but instead of navigating through the book, it indexes a SQL Server database.
How to restore specific table(s) from a SQL Server database backup (4287890)
How to restore specific table(s) from a SQL Server database backup "<p> If restoration of an original database to a previous state is not an option, in the case of accidentally updated, dropped, deleted, damaged data, it is still possible to restore these tables if a database backup was created prior to the accident.
Licensing and activation of centralized system products (4318747)
This article describes what you need to know about the licensing and activation of centralized ApexSQL products. ... Definitions ... Central instance – this is a computer where the main application and SQL Server instance that hosts the central repository database is installed.
Restore job fails during the log shipping process and the ‘System.Data.SqlClient.SqlError: …. An earlier log backup that includes LSN can be restored.’ error is encountered (4292640)
During the process of Log shipping, the restore transaction log job fails and the ‘System.Data.SqlClient.SqlError: The log in this backup set begins at LSN, which is too recent to apply to the database.
"RESTORE LOG is terminating abnormally" error is encountered in during the restore database step in the log shipping job (4214936)
Symptoms: ... If a destination database recovery state is not set to the no-recovery (restoring) state, log shipping job will fail during the process of transaction log restore with the "The log or differential backup cannot be restored because no files are ready to rollforward.
The ‘Cannot connect to server’ error is encountered during the installation of ApexSQL Backup (4292645)
Symptoms: In the process of selecting a SQL Server that will host the ApexSQL Backup Central Repository Database the ‘Cannot connect to server’ error is encountered if selected server has a default named instance.
How to setup an e-mail alert system for ApexSQL tools (4214934)
Summary This article describes how to create e-mail alert system for ApexSQL tools using PowerShell in order to send e-mails upon executed ApexSQL tool providing the necessary information. ... Summary This article describes how to create e-mail alert system for ApexSQL tools using PowerShell in order to send e-mails upon executed ApexSQL tool providing the necessary information.
Four ways of handling database/login credentials during automated execution via the CLI (4292458)
Summary ... This article explains how to automate the execution of ApexSQL tools via the CLI while handling the passing of database credentials or using Windows authentication. ... Applies to ... Summary
How to back up a database without the index data (4288504)
This article explains how to create filegroups and move indexes into a different file group, and how to backup a database without indexes with the purpose to reduce the amount of data required to perform backups thus reducing backup time and space required.
ApexSQL Backup installation and troubleshooting guide (4211735)
ApexSQL Backup application components ApexSQL Backup is a powerful tool used for managing SQL Server database backup and restore jobs across multiple servers. ... The application consists of three main components:
ApexSQL Backup CLI support (4209596)
This article explains how to use ApexSQL Backup command line interface (CLI) and create output files. ... To start the ApexSQL applications GUI via the command line interface enter the product name.
ApexSQL Backup CLI examples (4209396)
Beside scheduled jobs CLI supports direct backup, restore, and transaction log execution. ... CLI switches are split into five different categories: ... Monitoring or print switches ... To illustrate CLI usage each command line switch will be covered with a simple example.
How to create and manage SQL backup policies (4215951)
Performing regular database back-ups is a crucial part of any disaster recovery plan. ... There are many aspects that should be taken into consideration when planning long term backup strategies.
SQL Server database backup encryption (4215911)
A database is one of the most important parts of every information system and therefore is an often target of hackers. ... Encryption is the process of obfuscating data with the use of a key and/or password making the data unintelligible to anyone without a corresponding decryption key or a password.
Using SQL database backups instead of live databases in a large development team (4209355)
In scenarios where a development project of a large scale is being completed, DBA skills can really be put to the test. ... Due to the nature and the dependencies of the software which is being developed, it's not uncommon for the DBA to be in charge of dozens of environments, used by multiple development teams working on different aspects of the project.
How to schedule a SQL Server backup (4288956)
Having a good backup and restore plan is an important part of a disaster recovery strategy. ... This article will describe 3 different solutions/approaches for creating a scheduled backup in SQL Server
How to delete old database backup files automatically in SQL Server (4290641)
While working with a number of databases, creating a recovery plan can be challenging, especially if we want a foolproof design. ... Automated backup and restore strategies ensures the recovery plan is successful.
Multi server PowerShell script to backup SQL Server databases automatically (4295223)
Eighty-two percent of the enterprises expect the number of databases to increase over the next twelve months. ... An increase in data volumes can have negative effects on the performance of databases.
How to schedule a database backup restore in SQL Server (4209781)
When recovering from a SQL Server database failure, a database administrator needs to restore a set of SQL Server database backups in a logically correct and meaningful restore sequence. ... With this in mind, to the goal is to devise a disaster recovery strategy by creating a solid backup plan, as well as a proper database restore plan in SQL Server.
How to get a backup SQL database history (4213373)
This article will review how to get information on your backup SQL database history, including the metadata in MSDB that can be queries, as well as value added tools and features to group, sort, report and export this critical information
How to perform a SQL backup and restore history cleanup (4211375)
SQL Server stores a complete history of all SQL backup and restore operations, and other historical activities such as activities like Database Mail, Jobs, Log Shipping, Policies, Maintenance Plans, etc. on a server instance in the msdb database.
Manage multiple database backups across different SQL Server instances (4291170)
One of the most common ways to ensure that the recovery will be possible if a data-file corruption or any other disaster occurs is to create a recovery plans for this scenario. ... The most popular recovery plans include regular creation of database backups which can later be used to restore a database to a nearest available point in time, prior to disaster.
Verifying SQL database backups automatically (4210473)
Backups are the starting point for any serious disaster recovery strategy. ... Creating SQL database backups on a regular basis is just the first step. ... Equally important is to make sure they are also reliable and restorable.
新产品关联性