January 21, 2010 at 5:24 pm
just wondering if there will be any data loss in switching from simple recovery model to full recovery model? server sql 2005, production server.
January 21, 2010 at 5:38 pm
There will be no data loss but you should immediately take a full back up after you make the switch and then configure your transaction log backups.
January 21, 2010 at 5:47 pm
No downside, but you will need to get a full backup and configure t-log backups. If you don't start backing up the t-logs - they will grow and can create havoc down the road.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2010 at 5:47 pm
perfect.. thank you:)
January 21, 2010 at 5:48 pm
you're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 21, 2010 at 6:09 pm
also just to make sure there will be no downtime required as well for this changeover? this is live production server..
January 21, 2010 at 6:19 pm
No downtime required.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply