Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
richieasir
Starting Member
13 Posts |
 Posted - 2010-01-27 : 02:09:01
|
| Hi All,Greetings from Richards. Will Database Mirroring works only with Full Recovery model, If so why?Will it fail on other Recovery model( Simple and Bulk)?RegardsRichards |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-27 : 03:17:40
|
| By Database Mirroring do you mean Log Shipping?That's only possible if the database is "saving" its transaction. In Simple Recover Model as soon as a transaction is completed it is marked for reuse. In Full Recovery Model all transactions are kept until a backup (of the TLog file) is taken. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-01-27 : 08:01:07
|
quote:
Originally posted by richieasir
Hi All,Greetings from Richards. Will Database Mirroring works only with Full Recovery model, If so why?Will it fail on other Recovery model( Simple and Bulk)?RegardsRichards
Yes. Kristen has already explained. |
|
|
|
|
|
|
Reg Database Mirroring.