Friday, March 9, 2012

restoring from file group

Hello,
I would like to do a restore from file group for one of my databases. I was able to do a restore when I had the database under FULL recovery model. Is there a way to restore from file groups under the "SIMPLE " recovery model ie without performing a transaction log.
ThanksWhat was the statement used to restore?
I think there shouldn't be any issue pertaining to recovery model set on the database.|||there is a problem with tlog backups. i know that you cannot backup the tlog while the db is in simple mode.

i'm not sure however that there are any issues with recovery. i have recovered northwind many times and it is in simple mode.

No comments:

Post a Comment