Online Documentation for SQL Backup for SQL Server
Welcome to EMS SQL Backup! |
What's new |
System requirements |
Installation |
Purchasing |
How to register SQL Backup |
License activation |
Selecting license activation method |
Entering license key |
Web-site activation |
Entering license activation code |
Performing online activation |
Completing operation |
License deactivation |
Selecting deactivation method |
Web-site deactivation |
Performing online deactivation |
Completing operation |
License Manager |
Version history |
EMS SQL Backup FAQ |
Other EMS Products |
Getting started |
EMS SQL Backup overview |
Policy overview |
Navigating |
Servers |
Popup menus |
Groups popup menu |
Group popup menu |
Server popup menu |
Database popup menu |
Register Server Wizard |
Specifying connection parameters |
Defining additional options |
Performing operation |
Install server-side SQL Backup components |
Selecting installation type |
Specifying service account settings |
Specifying clustered service parameters |
Performing operation |
Update/Remove server-side SQL Backup components |
Selecting updating/removing type |
Selecting operation type |
Specifying service account settings |
Performing operation |
Update server-side components |
Service account settings |
Standalone local server-side components installer |
Choosing action |
Configuring installation settings |
Installer connection properties |
Specifying clustered service parameters |
Performing operation |
Server properties |
Server connection info |
Server options |
Server-side components properties |
Server options |
Email settings |
Log storage settings |
Backup settings |
Get backup files from server |
Specifying backup source |
Selecting backup files |
Viewing summary information |
Reports |
Policies |
Popup menus |
Policy popup menu |
Task popup menu |
Step context menu |
Schedule context menu |
Server context menu |
Policy creation wizard |
Setting policy name and description |
Defining set of tasks |
Defining notification options |
Creating policy |
Policy editor |
Name and description |
General |
Notification |
Maintenance plan conversion |
Welcome |
Selecting Maintenance plan to convert to policy |
Performing conversion |
Operation execution |
Execute policy |
Policy status |
Policy synchronization |
Launches |
Resolve problem |
Viewing Policy History |
Sorting |
Grouping |
Filtering |
Templates |
Policy templates |
Creating template from policy |
Task templates |
Create task wizard |
Set service task name and description |
Select servers |
Define a set of steps for service task |
Constraint editor |
Define schedule for service task |
Creating task |
Task editor |
Name and description |
Selection |
Steps |
Schedules |
Creating template from task |
Step templates |
Creating template from step |
Schedule template |
Schedule editor |
Creating schedule from template |
Activities |
Maintenance steps |
Creating Steps |
Backup Database |
Naming step |
Selecting database provider |
Selecting database |
Defining SQL Backup settings |
Setting SQL Server backup options |
Setting SQL Server data transfer options |
Setting file options |
Specifying cloud connections |
Specifying backup verifying options |
Performing operation |
Restore Database |
Selecting available backup |
Selecting files manually |
Specifying the elements of backup |
Choosing file and filegroups |
Defining target database parameters |
Specifying restore options |
Performing operation |
Database Shipping |
Naming step |
Specifying database pairs |
Specifying backup options |
Specifying folders and recovery options |
Viewing summary information |
Execute SQL Server Agent job |
Naming step |
Selecting job |
Performing operation |
Execute T-SQL statement |
Naming step |
Selecting server |
Defining T-SQL statement |
Performing operation |
History Cleanup |
Naming step |
Selecting server |
Selecting historical data |
Performing operation |
Database Integrity Check |
Naming step |
Selecting databases |
Setting options |
Performing operation |
Reorganize Indices |
Naming step |
Selecting objects |
Defining rules |
Advanced options |
Performing operation |
Shrink Database |
Naming step |
Selecting database |
Setting options |
Performing operation |
Update Statistics |
Naming step |
Selecting objects |
Setting options |
Performing operation |
Database Parameters Logger |
Naming step |
Selecting database |
Setting conditions |
Performing operation |
Maintenance Cleanup |
Naming step |
Selecting files/folders for cleanup |
Defining cleanup criteria |
Performing operation |
Transaction Log Shipping |
Naming step |
Specifying database pairs |
Specifying backup options |
Specifying folders and recovery options |
Performing operation |
Bulk Restore |
Naming step |
Selecting servers |
Restore options |
Performing operation |
Editing Steps |
Backup database |
Name and description |
General |
Selection |
SQL Backup settings |
Backup file options |
Backup options |
Verify options |
Clouds |
Database Shipping |
Name and description |
Backup options |
Restore options |
Selection |
Execute SQL Server Agent job |
Name and description |
Selection |
Execute T-SQL statement |
Name and description |
General |
Selection |
History Cleanup |
Name and description |
General |
Selection |
Database Integrity Check |
Name and description |
General |
Selection |
Shrink Database |
Name and description |
General |
Selection |
Reorganize Indices |
Name and description |
General |
Selection |
Rebuild options |
Update Statistics |
Name and description |
General |
Selection |
Database Parameters Logger |
Name and description |
General |
Selection |
Maintenance Cleanup |
Name and description |
General |
Selection |
Transaction Log Shipping |
Name and description |
Backup options |
Restore options |
Selection |
Bulk Restore |
Name and description |
Selection |
Options |
Gears menu |
Switch/Save configuration |
Options |
General |
Data refreshing |
Cloud Connection Settings |
Cloud Connection Settings Wizard |
Selecting connection type |
SMB/CIFS connection |
FTP connection |
SFTP connection |
Amazon S3 connection |
Microsoft Azure connection |
Dropbox connection |
Google Drive connection |
Authorization settings |
Connection creation |
Cloud Connection Settings Editor |
SMB/CIFS connection settings |
FTP connection settings |
SFTP connection settings |
Amazon S3 connection settings |
Microsoft Azure connection settings |
Dropbox connection settings |
Google Drive connection settings |
Authorization type settings |
Proxy server parameters |
How to... |
Install EMS SQL Backup |
Install server-side components without having permissions for remote installation |
Activate license on SQL Server instance |
Schedule backup database task daily |
Setup uploading backup files to different storage locations (Network folders/FTP/SFTP/Clouds) |
Create a policy based on predefined templates |
Configure transaction log shipping |
Monitor server productivity counters |
Add database/server to an existing policy |
Create a policy rapidly on several servers/databases |
Transfer policy tasks to another set of databases/servers |
Reveal a reason of a failed policy execution |
Restore successful policy status |
Convert SQL Server maintenance plan to SQL Backup policy |
Manage templates effectively |
Configure policy notifications |
Create a report on policy execution |
Ensure simultaneous policy execution on servers from different time zones |
Report bugs and suggestions |
Update EMS SQL Backup |
Remove EMS SQL Backup |
Use Free version of EMS SQL Backup |
Appendix |
Database states |
Backup Converter Utility |
Server folder dialog |
© 1999-2023 EMS Software Development