March 3, 2009 at 9:09 am
Recently i changed my design with table partitions where i have data according to the year.
1. Can i hava full backup once and just backup only partition files(ndf) which are updated regularly.
2. Can i restore only those partitions when required
3. If i can backup only those partitions how could i test those backup either full resotre or verify only.
March 3, 2009 at 9:17 am
If your partitioned tables are in separate filegroups you can do filegroup backups. You should check out BOL for more information on this.
March 3, 2009 at 9:47 am
Be careful before engaging into things like this. You must ensure that your primary file group is always available, that your transaction log backups are tightly controlled and PRACTICE as much as you can your "restore" scenarios.
In addition you are trading manageability for flexibility. Know all the pros and cons first!
Just my $0.02
* Noel
March 5, 2009 at 7:16 am
Say If i have 100 secondary files (ndf), is there a way i can restore a database by looping through each file no matter how many files i have, because its really pain doing a restore " WITH MOVE " option on a different server by listing each file name. If there is any way which identifies all the files from a backup file (.BAK) and do a restore from the files listed by looping through each file, that makes life easier.
thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply