Comments
Sort by recent activity
I looked at your page and I have already configured the database as suggested. It is only when I backup to multiple files using the tool that it slows down. I have done a native sql backup to a single file and multiple files. In both cases, throughput is great. I have backed up to a single file using the tool and throughput is great.
Disk speed - RAID 10 on a SAN. Database is broken up into 12 files with each file being on a separate independent LUN with no shared disks.
Database files - See bullet above.
Really use physically different disks - See first bullet
File fragmentation - Less than 5%
Transaction log - Stored on a separate independent LUN on the SAN
Backup files - Each one is stored on a different independent LUN. / comments
I looked at your page and I have already configured the database as suggested. It is only when I backup to multiple files using the tool that it slows down. I have done a native sql backup to a s...
I tried the link but it returns page not found. Where the data file is located should not make a difference since backing up to a single file goes very fast. But to provide insight on the data file, it is located on an independent LUN that does not share any disks with the backup LUNs. / comments
I tried the link but it returns page not found. Where the data file is located should not make a difference since backing up to a single file goes very fast. But to provide insight on the data fi...