March 20, 2009 at 11:23 am
I have created database along with additional filegroup and backed up both primary file group and secondary file group, while restoration it is not restoring.
Please reply me anyone how to restore filegroup.
March 20, 2009 at 7:32 pm
Please post the error message.
MJ
March 21, 2009 at 6:02 am
Please also describe your backup strategy and what you did while trying to restore.
As previous poster asked, post log files.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 22, 2009 at 12:24 pm
amarnath_sk (3/20/2009)
I have created database along with additional filegroup and backed up both primary file group and secondary file group, while restoration it is not restoring.
What database backup did u perform? Backup operation always performs the total backup of the database.
Post your TSQL statements and also errors.
March 23, 2009 at 2:35 pm
In order to answer this question easily and correctly we'll need 3 things.
- The backup script that you used.
- The restore script that you used.
- The error message(s) from the retore script.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply