Showing posts with label Backups. Show all posts
Showing posts with label Backups. Show all posts

Monday, January 23, 2023

Robocopy to replicate SQL backups

 Robocopy to replicate SQL backups


robocopyFullBackups.bat

ROBOCOPY \\192.168.1.10\SQLSRV01 D:\Backups\SQLSRV01\SQLSRV01 *.bak /S /XO /MT:16 /log:"C:\Robocopy\robocopyLogs\theFullLog.log"

ROBOCOPY \\192.168.1.10\SQLSRV01-other D:\Backups\SQLSRV01\SQLSRV01 *.bak /S /XO /MT:16 /log:"C:\Robocopy\robocopyLogs\theFullLog.log"


robocopyDiffBackups.bat

ROBOCOPY \\192.168.1.10\SQLSRV01 D:\Backups\SQLSRV01\SQLSRV01 *.dif /S /XO /MT:16 /log:"C:\Robocopy\robocopyLogs\theDiferentialLog.log"

ROBOCOPY \\192.168.1.10\SQLSRV01-other D:\Backups\SQLSRV01\SQLSRV01 *.dif /S /XO /MT:16 /log:"C:\Robocopy\robocopyLogs\theDifLog.log"


robocopyTrnBackups.bat

ROBOCOPY \\192.168.1.10\SQLSRV01 D:\Backups\SQLSRV01\SQLSRV01 *.trn /S /XO /MT:16 /log:"C:\Robocopy\robocopyLogs\theTransLog.log"

ROBOCOPY \\192.168.1.10\SQLSRV01-other D:\Backups\SQLSRV01\SQLSRV01 *.trn /S /XO /MT:16 /log:"C:\Robocopy\robocopyLogs\theTransLog.log"


robocopy



robocopy
Article
10/04/2022
9 minutes to read
18 contributors
Copies file data from one location to another.

Syntax
cmd

Copy
robocopy <source> <destination> [<file>[ ...]] [<options>]
For example, to copy a file named yearly-report.mov from c:\reports to a file share \\marketing\videos while enabling multi-threading for higher performance (with the /mt parameter) and the ability to restart the transfer in case it's interrupted (with the /z parameter), type:

dos

Copy
robocopy c:\reports '\\marketing\videos' yearly-report.mov /mt /z
Parameters
Parameter Description
<source> Specifies the path to the source directory.
<destination> Specifies the path to the destination directory.
<file> Specifies the file or files to be copied. Wildcard characters (* or ?) are supported. If you don't specify this parameter, *.* is used as the default value.
<options> Specifies the options to use with the robocopy command, including copy, file, retry, logging, and job options.
Copy options
Option Description
/s Copies subdirectories. This option automatically excludes empty directories.
/e Copies subdirectories. This option automatically includes empty directories.
/lev:<n> Copies only the top n levels of the source directory tree.
/z Copies files in restartable mode. In restartable mode, should a file copy be interrupted, Robocopy can pick up where it left off rather than recopying the entire file.
/b Copies files in backup mode. Backup mode allows Robocopy to override file and folder permission settings (ACLs). This allows you to copy files you might otherwise not have access to, assuming it's being run under an account with sufficient privileges.
/zb Copies files in restartable mode. If file access is denied, switches to backup mode.
/j Copies using unbuffered I/O (recommended for large files).
/efsraw Copies all encrypted files in EFS RAW mode.
/copy:<copyflags> Specifies which file properties to copy. The valid values for this option are:
D - Data
A - Attributes
T - Time stamps
S - NTFS access control list (ACL)
O - Owner information
U - Auditing information
The default value for this option is DAT (data, attributes, and time stamps).
/dcopy:<copyflags> Specifies what to copy in directories. The valid values for this option are:
D - Data
A - Attributes
T - Time stamps
The default value for this option is DA (data and attributes).
/sec Copies files with security (equivalent to /copy:DATS).
/copyall Copies all file information (equivalent to /copy:DATSOU).
/nocopy Copies no file information (useful with /purge).
/secfix Fixes file security on all files, even skipped ones.
/timfix Fixes file times on all files, even skipped ones.
/purge Deletes destination files and directories that no longer exist in the source. Using this option with the /e option and a destination directory, allows the destination directory security settings to not be overwritten.
/mir Mirrors a directory tree (equivalent to /e plus /purge). Using this option with the /e option and a destination directory, overwrites the destination directory security settings.
/mov Moves files, and deletes them from the source after they are copied.
/move Moves files and directories, and deletes them from the source after they are copied.
/a+:[RASHCNET] Adds the specified attributes to copied files. The valid values for this option are:
R - Read only
A - Archive
S - System
H - Hidden
C - Compressed
N - Not content indexed
E - Encrypted
T - Temporary
/a-:[RASHCNET] Removes the specified attributes from copied files. The valid values for this option are:
R - Read only
A - Archive
S - System
H - Hidden
C - Compressed
N - Not content indexed
E - Encrypted
T - Temporary
/create Creates a directory tree and zero-length files only.
/fat Creates destination files by using 8.3 character-length FAT file names only.
/256 Turns off support for paths longer than 256 characters.
/mon:<n> Monitors the source, and runs again when more than n changes are detected.
/mot:<m> Monitors the source, and runs again in m minutes, if changes are detected.
/mt[:n] Creates multi-threaded copies with n threads. n must be an integer between 1 and 128. The default value for n is 8. For better performance, redirect your output using /log option.
The /mt parameter can't be used with the /ipg and /efsraw parameters.

/rh:hhmm-hhmm Specifies run times when new copies may be started.
/pf Checks run times on a per-file (not per-pass) basis.
/ipg:n Specifies the inter-packet gap to free bandwidth on slow lines.
/sj Copies junctions (soft-links) to the destination path instead of link targets.
/sl Don't follow symbolic links and instead create a copy of the link.
/nodcopy Copies no directory info (the default /dcopy:DA is done).
/nooffload Copies files without using the Windows Copy Offload mechanism.
/compress Requests network compression during file transfer, if applicable.
 Note

The /mt parameter was introduced in Windows Server 2008 R2 and its functionality applies to current versions of Windows Server.

 Important

When using the /secfix copy option, specify the type of security information you want to copy, using one of these additional copy options:

/copyall
/copy:o
/copy:s
/copy:u
/sec
File selection options
Option Description
/a Copies only files for which the Archive attribute is set.
/m Copies only files for which the Archive attribute is set, and resets the Archive attribute.
/ia:[RASHCNETO] Includes only files for which any of the specified attributes are set. The valid values for this option are:
R - Read only
A - Archive
S - System
H - Hidden
C - Compressed
N - Not content indexed
E - Encrypted
T - Temporary
O - Offline
/xa:[RASHCNETO] Excludes files for which any of the specified attributes are set. The valid values for this option are:
R - Read only
A - Archive
S - System
H - Hidden
C - Compressed
N - Not content indexed
E - Encrypted
T - Temporary
O - Offline
/xf <filename>[ ...] Excludes files that match the specified names or paths. Wildcard characters (* and ?) are supported.
/xd <directory>[ ...] Excludes directories that match the specified names and paths.
/xc Excludes existing files with the same timestamp, but different file sizes.
/xn Source directory files newer than the destination are excluded from the copy.
/xo Source directory files older than the destination are excluded from the copy.
/xx Excludes extra files and directories present in the destination but not the source. Excluding extra files will not delete files from the destination.
/xl Excludes "lonely" files and directories present in the source but not the destination. Excluding lonely files prevents any new files from being added to the destination.
/im Include modified files (differing change times).
/is Includes the same files. Same files are identical in name, size, times, and all attributes.
/it Includes "tweaked" files. Tweaked files have the same name, size, and times, but different attributes.
/max:<n> Specifies the maximum file size (to exclude files bigger than n bytes).
/min:<n> Specifies the minimum file size (to exclude files smaller than n bytes).
/maxage:<n> Specifies the maximum file age (to exclude files older than n days or date).
/minage:<n> Specifies the minimum file age (exclude files newer than n days or date).
/maxlad:<n> Specifies the maximum last access date (excludes files unused since n).
/minlad:<n> Specifies the minimum last access date (excludes files used since n) If n is less than 1900, n specifies the number of days. Otherwise, n specifies a date in the format YYYYMMDD.
/xj Excludes junction points, which are normally included by default.
/fft Assumes FAT file times (two-second precision).
/dst Compensates for one-hour DST time differences.
/xjd Excludes junction points for directories.
/xjf Excludes junction points for files.
Retry options
Option Description
/r:<n> Specifies the number of retries on failed copies. The default value of n is 1,000,000 (one million retries).
/w:<n> Specifies the wait time between retries, in seconds. The default value of n is 30 (wait time 30 seconds).
/reg Saves the values specified in the /r and /w options as default settings in the registry.
/tbd Specifies that the system will wait for share names to be defined (retry error 67).
Logging options
Option Description
/l Specifies that files are to be listed only (and not copied, deleted, or time stamped).
/x Reports all extra files, not just those that are selected.
/v Produces verbose output, and shows all skipped files.
/ts Includes source file time stamps in the output.
/fp Includes the full path names of the files in the output.
/bytes Prints sizes, as bytes.
/ns Specifies that file sizes are not to be logged.
/nc Specifies that file classes are not to be logged.
/nfl Specifies that file names are not to be logged.
/ndl Specifies that directory names are not to be logged.
/np Specifies that the progress of the copying operation (the number of files or directories copied so far) will not be displayed.
/eta Shows the estimated time of arrival (ETA) of the copied files.
/log:<logfile> Writes the status output to the log file (overwrites the existing log file).
/log+:<logfile> Writes the status output to the log file (appends the output to the existing log file).
/unicode Displays the status output as Unicode text.
/unilog:<logfile> Writes the status output to the log file as Unicode text (overwrites the existing log file).
/unilog+:<logfile> Writes the status output to the log file as Unicode text (appends the output to the existing log file).
/tee Writes the status output to the console window, and to the log file.
/njh Specifies that there is no job header.
/njs Specifies that there is no job summary.
Job options
Option Description
/job:<jobname> Specifies that parameters are to be derived from the named job file. To run /job:jobname, you must first run the /save:jobname parameter to create the job file.
/save:<jobname> Specifies that parameters are to be saved to the named job file. This must be ran before running /job:jobname. All copy, retry, and logging options must be specified before this parameter.
/quit Quits after processing command line (to view parameters).
/nosd Indicates that no source directory is specified.
/nodd Indicates that no destination directory is specified.
/if Includes the specified files.
Exit (return) codes
Value Description
0 No files were copied. No failure was encountered. No files were mismatched. The files already exist in the destination directory; therefore, the copy operation was skipped.
1 All files were copied successfully.
2 There are some additional files in the destination directory that are not present in the source directory. No files were copied.
3 Some files were copied. Additional files were present. No failure was encountered.
5 Some files were copied. Some files were mismatched. No failure was encountered.
6 Additional files and mismatched files exist. No files were copied and no failures were encountered. This means that the files already exist in the destination directory.
7 Files were copied, a file mismatch was present, and additional files were present.
8 Several files did not copy.
 Note

Any value equal to or greater than 8 indicates that there was at least one failure during the copy operation.

Additional References
Command-Line Syntax Key
Recommended content
icacls
Reference article for the icacls command, which displays or modifies discretionary access control lists (DACL) on specified files, and applies stored DACLs to files in specified directories.
takeown
Reference article for the takeown command, which enables an administrator to recover access to a file that was previously denied.
Get-SmbConnection (SmbShare)
Use this topic to help manage Windows and Windows Server technologies with Windows PowerShell.
Close-SmbSession (SmbShare)
Use this topic to help manage Windows and Windows Server technologies with Windows PowerShell.





Wednesday, September 2, 2020

Acronis DR Disaster Recovery - How to Get Started With Acronis Disaster Recovery Cloud

 Acronis DR Disaster Recovery - How to Get Started With Acronis Disaster Recovery Cloud

As per the article found at: 

https://www.acronis.com/en-us/blog/posts/how-get-started-acronis-disaster-recovery-cloud#:~:text=Acronis%20Disaster%20Recovery%20Cloud%20is%20just%20one%20of%20the%20Acronis,to%20move%20their%20business%20elsewhere


As Vice President and General Manager, Disaster Recovery Services, Mark Jameson is focused on empowering partners and clients across the globe to grow and protect their business with Acronis disaster recovery solutions.  Mark has built over 30 years of experience in the disaster recovery and information technology markets with companies such as nScaled, SunGard Availability Services, Unisys and IBM. 
 

Acronis has announced the availability of Acronis Disaster Recovery Cloud to enable our Service Provider partners to deliver disaster recovery services to their clients. You are using Acronis Backup Cloud, but you now ask yourself why should I use Acronis Disaster Recovery Cloud and how do I get started? I would like to help you answer these questions.

Why should I use Acronis Disaster Recovery Cloud?

Our world is continuing to become more and more dependent upon an exponentially expanding wealth of data. Even if you are not thinking about disaster recovery, your clients are! So why should you use Acronis Disaster Recovery Cloud to deliver Disaster Recovery as a Service to your clients?

  • Rapidly growing market – According to MarketsandMarkets the Disaster Recovery as a Service marketplace will grow from $1.7B in 2016 to $12.5B in 2022. This growth is not limited to just enterprises, but more and more mid-market and small businesses are considering cloud-based disaster recovery solutions.
     
  • Easy – Acronis Disaster Recovery Cloud is delivered through the same easy-to-use console that you already are using with Acronis Backup Cloud. The additional disaster recovery functions have the same touch and feel as Acronis Backup Cloud.
     
  • Quick – There is no waiting to deploy an infrastructure to start providing disaster recovery services. You or your clients can add disaster recovery to any backed up server or virtual machines in just seconds.
     
  • Client retention – Acronis Disaster Recovery Cloud is built on top of the world’s easiest and fastest backup solution. Acronis Disaster Recovery Cloud is just one of the Acronis Cyber Cloud services that you can upsell to your clients to provide them a full suite of data protection. The more services they use from you, the less likely are to move their business elsewhere.
     
  • Revenue and margins – There is no CAPEX to start providing disaster recovery. Straightforward pay-as-you-go pricing allows you to build upon your Acronis Backup Cloud to incrementally grow your revenue and margins.

So now that we have established the “why”, let’s talk about the “how”.

How to get started with Acronis Disaster Recovery Cloud

Getting started with Acronis Disaster Recovery Cloud is very simple, just follow 8 simple steps.

  1. The right target market: Acronis Disaster Recovery Cloud is designed to protect servers and virtual machines. If your Acronis Backup Cloud clients are protecting servers or virtual machines, then they are candidates for Acronis Disaster Recovery Cloud. You can add disaster recovery to all of your clients and all of their machines, or start with just one machine for one client. You are in control of how you grow your business!
     
  2. Legal terms and conditions: Acronis Disaster Recovery Cloud comes with new terms and conditions that need to be added to your agreement. If you have not yet received your new Acronis Disaster Recovery Cloud legal language, please contact your Acronis or Cloud Reseller representative. Once this step is completed the Acronis Disaster Recovery Cloud functions will be enabled and you will be able to begin using.
     
  3. Read the user guide: You will find a disaster recovery section added to the online Acronis Backup Cloud user guide. We encourage you to review this new section to get an understanding of the disaster recovery functions that are now available to you.
     
  4. Install VPN agent: So you are ready to start using the new Acronis Disaster Recovery Cloud functionality. The first thing you need to do is download and execute the easy to use VPN agent that is available in both VMware and Hyper-V versions.

    Download VPN agent
     

    This process should take you about 15 minutes and only needs to be done once. While your data is already moved to the cloud by your existing Acronis Backup Cloud replication, this VPN connection enables you to extend your production environment to the Acronis cloud to facilitate easy failover, server access and automatic discovery of you production IP network attributes.
     

  5. Add disaster recovery to servers and virtual machines: Adding disaster recovery to machines backed up with Acronis Backup Cloud only takes seconds. All you have to do is choose the appropriate machine, select 1 of 8 standard configurations available, confirm the production and test IP addresses automatically discovered, confirm a couple of other optional features, include optional description information and hit done.

    Add Disaster Recovery to Acronis Backup Cloud
     
  6. Set up always on servers: For those who may need to house a server in the Acronis cloud to support such needs as Exchange DAGs, SQL Mirrors, virtual appliances, etc.; these always-on servers can easily be set up in seconds much the same way that you added disaster recovery to machines backed up with Acronis Backup Cloud.

    Set up always on servers
     
  7. Add backup to your cloud machines: Not only can you run machines in the Acronis cloud, but you also back them up. Whether a machine that was backed up or added as always on, every machine running in the Acronis cloud is also backed up within the Acronis cloud.

    Add backup to your cloud machines
     
  8. Failover and test failover: You are now ready to either execute a live failover of a machine in the Acronis cloud or perform non-disruptive testing of a machine failover. With just a few clicks of the mouse and a few minutes you will have machines running in the Acronis Cloud!

    Test failover
     

Additional resources to help you

Well, I hope that this has helped you understand the “why” and “how” of Acronis Disaster Recovery Cloud, but the help does not stop here. Acronis is here to help our partners in growing their business with Acronis Disaster Recovery Cloud. To find out more about the Acronis Disaster Recovery Cloud service I invite you to visit the Acronis Disaster Recovery Cloud product page to find more information and contact your Acronis or Cloud Reseller representative to get a quote or request a demo.

Look for future blogs about Acronis Disaster Recovery Cloud and growing your disaster recovery business. If you can’t wait for the next blog you can always email me at mark.jameson@acronis.com.

 








Performing a failback


A failback is a process of moving the workload from the cloud back to your premises.

During this process, the server being moved is unavailable. The length of the maintenance window is approximately equal to the duration of a backup and the subsequent recovery of the server.

To perform a failback

  1. Select the recovery server that is in the Failover state.
  2. Click Failback.

    Prepare failback

  3. Click Prepare failback.

    The recovery server will be stopped and backed up to the cloud storage. Wait for the backup to complete.

    At this time, two actions become available: Cancel failback and Confirm failback. If you click Cancel failback, the recovery server will start and the failover will continue.

  4. Recover the server from this backup to hardware or to a virtual machine on your premises.
    • When using bootable media, proceed as described in "Recovering disks by using bootable media" in the Cyber Protection User Guide. Ensure that you sign in to the cloud by using the account for which the server is registered and that you select the most recent backup.
    • If the target machine is online or is a virtual machine, you can use the service console. On the Backup storage tab, select the cloud storage. In Machine to browse from, select the target physical machine or the machine running the agent, if the target machine is virtual. The selected machine must be registered for the same account for which the server is registered. Find the most recent backup of the server, click Recover entire machine, and then set up other recovery parameters. For the detailed instructions, refer to "Recovering a machine" in the Cyber Protection User Guide.

    Ensure that the recovery is completed and the recovered machine works properly.

  5. Return to the recovery server in the service console, and then click Confirm failback.

    The recovery server and recovery points become ready for the next failover. To create new recovery points, apply a protection plan to the new local server.



Setting up connectivity



This section explains the network concepts necessary for you to understand how it all works in Cyber Disaster Recovery Cloud. You will learn how to configure different types of connectivity to the cloud site, depending on your needs. Finally, you will learn how to manage your networks in the cloud and manage the settings of the VPN appliance and VPN gateway.

In this section

Networking concepts

Initial connectivity configuration

Network management

Welcome to Cyber Disaster Recovery Cloud



Getting started




IT Consultant

www.inCOREporation.com

Featured Posts

Exchange Online Limits - Office 365 Distribution group limits

Exchange Online Limits - Office 365 Distribution group limits What are Exchange Online Limits What are Office 365 Distribution group limi...