Thursday, February 16, 2012

backup

Hi
how to backup a single db on multiple files to split into smaller files .
Regards
AjayBACKUP DATABASE northwind TO
DISK = 'c:\bkp\backup_1.BAK' ,
DISK = 'c:\bkp\backup_2.BAK' ,
DISK = 'c:\bkp\backup_3.BAK'
This will stripe the backup across all these files.
However, all devices must be of the same type ex : disk,
tape etc.
- Vishal

No comments:

Post a Comment