Sample Header Ad - 728x90

Split Backup of MSSQL VS Stripe Backup of Sybase ASE

0 votes
1 answer
261 views
I recently came to know about concept of split backup in MSSQL Server whereas I have been working on stripe backup in Sybase ASE. Stripe backup in Sybase ASE is faster than normal backup and if we use three stripes then Sybase will use 3 cores of CPU(Depends on number of cores) as it will be split into that many threads, are performed in parallel irrespective of storage location. I wanted to understand if same is the case with MSSQL split backup, I read that if we use different locations for split backup then the backup will be performed in parallel and will be faster: Split Backup however if storage location is same( In the same drive and folder), no extra IO involved and hence not much impact on performance.
Asked by Learning_DBAdmin (3924 rep)
Mar 11, 2019, 12:16 PM
Last activity: Mar 11, 2019, 01:18 PM