Hi,
If I take a backup of a database which is in FULL recovery mode, and then I do a restore with it somewhere else, do I have to take a full backup of this db in order to be able to recover from this point, or this backup can be consider the first full backup in the recovery plan?
Another thing, what happens if the original backup is done with the option COPY_ONLY does it affect the recovery model in any way?
Actually you will have to take a full backup otherwise you can not get started with log backups right away.
You don't have to take another backup, however, if you have moved it to another location, probably changing database names, and file locations, it would be useful to have a backup that can be restored without the added complication of restoring over.
COPY_ONLY is used so that you don't affect the backup and recovery procedure of the original database. It won't have any effect on the restored database. I presume you meant the recovery model of the restored database in your question?
Steinar has a good point - I hadn't read the question that way.....
