June 9, 2010 at 2:41 pm
Whether I use Database Mirroring, Log Shipping etc to get a copy of my Production database over to a Development server database, are SQL backups required on the Development side?
I'm not worried about backing up the Development database so I can restore it (I have the production copy backups for that), but are backups required simply to keep its transaction log under control and the data committed to the database.
...thanks
June 11, 2010 at 3:11 pm
Your regular back up is not going to do anything for your transaction log. The reason why you might want to take a back up of your development DB would be to make sure that you dont loose the new objects that you created while developing for your new project.
-Roy
June 11, 2010 at 3:14 pm
Thanks, Roy.
June 11, 2010 at 3:22 pm
You are welcome. I was not sure of this was your doubt or not. So I did not give much info.
The only way to manage transaction log is to take Log Back ups. Not the regular back ups.
Since this is your development environment and you are not afraid of loosing data that you created while testing or developing, You can keep the Database in Simple mode. This will keep the transaction log growth in check. Keep in mind that you will loose all data if your DB crashes with no back up and transaction log back up.
-Roy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply