| Author |
Simple Recovery vs Full Recovery
|
|
| Dodo Lurker 2006-10-24, 6:33 pm |
| I know the difference between the two.
If I take production database that's in Full Recovery and move it to a test
server, would changing
the recovery model to Simple affect any performance tests I run? The ldf
file will be on a separate disk from the mdf file.
| |
| Hilary Cotter 2006-10-24, 6:33 pm |
| The impact if anything would be minimal.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dodo Lurker" <none@noemailplease> wrote in message
news:tqidnW5QON9OKoP
YnZ2dnUVZ_vCdnZ2d@co
mcast.com...
>I know the difference between the two.
>
> If I take production database that's in Full Recovery and move it to a
> test
> server, would changing
> the recovery model to Simple affect any performance tests I run? The ldf
> file will be on a separate disk from the mdf file.
>
>
| |
| Andrew Pike 2006-10-24, 6:33 pm |
| One scenario that would affect performance could arise if you are testing
bulk loading scripts. Either Simple or Bulk Logged recovery model is one of
the prerequisites for 'minimally' logged operations. If you meet the other
criteria, the logging overhead would be reduced and bulk load operations can
run much faster.
Do you not require an indication of the transaction log overhead of your
test scripts?
Regards
Andrew Pike
--
SQL Server DBA
UBS IB
"Dodo Lurker" wrote:
> I know the difference between the two.
>
> If I take production database that's in Full Recovery and move it to a test
> server, would changing
> the recovery model to Simple affect any performance tests I run? The ldf
> file will be on a separate disk from the mdf file.
>
>
>
| |
| Hari Prasad 2006-10-24, 6:33 pm |
| Hi,
No; there will not be any performance impact. Only thing is your
transactions will be cleared from LDF file on every checkpoint
automatically.
One more thing is if you chnage the recovery model to FULL then you need to
take a full database backup to create the backup chain again.
Thanks
Hari
SQL Server MVP
"Dodo Lurker" <none@noemailplease> wrote in message
news:tqidnW5QON9OKoP
YnZ2dnUVZ_vCdnZ2d@co
mcast.com...
>I know the difference between the two.
>
> If I take production database that's in Full Recovery and move it to a
> test
> server, would changing
> the recovery model to Simple affect any performance tests I run? The ldf
> file will be on a separate disk from the mdf file.
>
>
|
|
|
|