Hey guys,
I'm wondering how most people manage very very large backups. What is the best approach to breaking up the backup files if you're restricted to a drive size (450gig in my case). I unix, you can pipe the backup to gzip and split, I'm not sure how the same thing could be accomplished in windows.
Thanks,
-KilkaHave you looked into backing up filegroups or doing differential backups?|||Hey Thrasymachus,
I had a look and neither of those two would solve the problem. In order to accomplish either of the two, you do need a full backup to recover from scratch. However, after a little investigation, I found out that you can split a full backup into a set of files, I previously never knew you could do this.
Check this out:
restore database warehouse_test FROM
disk = 'X:\warehouse_test1.bak',disk = 'X:\warehouse_test2.bak'
Peace,
-Kilka
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment