June 12, 2006 at 12:08 pm
I am having trouble finding the answer in the BOL, but I was wondering:
I have a DB that has a recovery model of FULL, and a backup is created per the schedule
I have a second server that is used by developers to test certain things here and there, and the developers will take the backup from the server and restore to the second server.
On the second server, currently the recovery model is set to FULL, but since there are no backups, the logs just keep growing. I want to set the recovery model to SIMPLE, thus eliminating the need to make any sort of backup for the development (test, their code is actually elsewhere) machine.
The Question:
When a developer restores the DB from Server1’s Full backup, will that also change the recovery model on server2 when the restore completes?
-- Cory
June 13, 2006 at 7:18 am
The recovery model of the restored database will be that of the backed up database.If the recovery model while taking a backup is 'full' then on restoration of the database the recovery model will also be 'full'.If u need to change the model u will have to change after restoration is complete.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply