We help IT Professionals succeed at work.
Get Started
Research Question

ola backup solutoin

marrowyung
marrowyung asked
on
100 Views
Last Modified: 2021-01-24
Hi,

Our SQL server 2016 standard edition using maintenance plan to do the FULL and T-log backup, I'd like to replace it with ola framework so that both full and t-log backup faster and size smaller.

the script I use ola to do the full backup is:
EXECUTE [dbo].[DatabaseBackup]
@Databases = 'SYSTEM_DATABASES',
@Directory = '\\xxx',
@BackupType = 'FULL',
@Compress = 'Y', 
@Verify = 'Y',
@CleanupTime = NULL,
@CheckSum = 'Y',
@LogToTable = 'Y',
@BufferCount = 50, 
@MaxTransferSize = 4194304


EXECUTE [dbo].[DatabaseBackup]
@Databases = 'USER_DATABASES',
@Directory = '\\xxx',
@BackupType = 'FULL',
@Compress = 'Y', 
@Verify = 'Y',
@CleanupTime = NULL,
@CheckSum = 'Y',
@LogToTable = 'Y',
@BufferCount = 50, 
@MaxTransferSize = 4194304


the script I use ola to do the T-log backup is: 

EXECUTE [dbo].[DatabaseBackup]
@Databases = 'USER_DATABASES',
@Directory = '\\10.0.237.20\Mobigator\DBBak\Production',
@Compress = 'Y', 
@BufferCount = 50, 
@MaxTransferSize = 4194304, 
@BackupType = 'LOG', 
@Verify = 'Y', 
@CleanupTime = NULL, 
@CheckSum = 'Y', 
@LogToTable = 'Y' 



the script should have nothing wrong, right?
and I want to have a restore test using the output from the above which is compressed.

what is the script /procedure for it on doing Full restore and t-log restore?

diff backup is not needed, right?
Comment
Watch Question
SQL Server Consultant
CERTIFIED EXPERT
Distinguished Expert 2020
Commented:
This problem has been solved!
Unlock 5 Answers and 39 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE