marrowyung
asked on
The enhancement of litespeed SQL backup.
Dear all,
I have the following existing script using litespeed backup
Declare @filenumber int
exec master.dbo.xp_backup_datab ase @database = N'iXCore_Port',
@GUID = N'7565C182-6AC1-4E5F-82B9- 6136A3BAA7 82',
@filename = N'\\REPO\Litespeed\Batch02 \iXCore_Po rt20090319 1122LiteSp eed_Full.B KP',
@backupname = N'Repository Daily iXCore_Port Full Backup',
@desc = N'Repository Daily iXCore_Port Full Backup',
@jobp = N'FlTb+IlqB9p9+MB4HPgZQg== ', @cryptlevel = 6,
@compressionlevel = 11, @comment = '', @with = N'SKIP', @with = N'STATS = 10',
@filenumber = @filenumber output
exec master.dbo.xp_restore_veri fyonly
@filename = N'\\REPO\Litespeed\Batch02 \iXCore_Po rt20090319 1122LiteSp eed_Full.B KP',
@jobp = N'FlTb+IlqB9p9+MB4HPgZQg== ', @filenumber = @filenumber
I have tried to add "@threads =16," and change compressionLevel to 11, but the total time doesn't change much.
Any suggestion on how to optimize that?
Also any link show me how to implemetn full backup + differential backup + retentation period using litespeed?
any way to improve the speed and size ,etc will be good !
DBA100.
I have the following existing script using litespeed backup
Declare @filenumber int
exec master.dbo.xp_backup_datab
@GUID = N'7565C182-6AC1-4E5F-82B9-
@filename = N'\\REPO\Litespeed\Batch02
@backupname = N'Repository Daily iXCore_Port Full Backup',
@desc = N'Repository Daily iXCore_Port Full Backup',
@jobp = N'FlTb+IlqB9p9+MB4HPgZQg==
@compressionlevel = 11, @comment = '', @with = N'SKIP', @with = N'STATS = 10',
@filenumber = @filenumber output
exec master.dbo.xp_restore_veri
@filename = N'\\REPO\Litespeed\Batch02
@jobp = N'FlTb+IlqB9p9+MB4HPgZQg==
I have tried to add "@threads =16," and change compressionLevel to 11, but the total time doesn't change much.
Any suggestion on how to optimize that?
Also any link show me how to implemetn full backup + differential backup + retentation period using litespeed?
any way to improve the speed and size ,etc will be good !
DBA100.
You could try backing up to multiple files? I have seen large performance increases when doing this, especially when writing out to separate file systems too.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ashilo,
Compresslevel=6 is the best ?
"@threads =2*your cpu count"
I tried that before but I don't see much increase! probably the backup verification still spend a lot of time.
Any thing to improve the verification speed ?
EvilPostIt,
Yes, but the litespeed do not have this option for me, am I miss anything. Redgat toolbelt can do this ? how can I do this in litespeed and after that I can still easily restore the MULTI backup files?
Compresslevel=6 is the best ?
"@threads =2*your cpu count"
I tried that before but I don't see much increase! probably the backup verification still spend a lot of time.
Any thing to improve the verification speed ?
EvilPostIt,
Yes, but the litespeed do not have this option for me, am I miss anything. Redgat toolbelt can do this ? how can I do this in litespeed and after that I can still easily restore the MULTI backup files?
Which version of LiteSpeed are you using?
ASKER
Any upgrade documentation for the litespeed ? I think I need to ugprade too
ashilo,
any doc detail say the best vaule of all parameter?
how to verify the backup file is good to store other than really try to restore?
ashilo,
any doc detail say the best vaule of all parameter?
how to verify the backup file is good to store other than really try to restore?
everything you need here http://www.quest.com/litespeed-for-sql-server/
ASKER
EvilPostIt,
the version of Litespeed we are using are 4.8.3.00025. What is the highest version we can directly upgrade from ?
DBA100.
the version of Litespeed we are using are 4.8.3.00025. What is the highest version we can directly upgrade from ?
DBA100.