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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2010-03-11 : 02:36:18
|
| Hi All,i'm trying to configure mirroring on the same server on two different instances without witness. at the end of configuration, i'm getting the error insufficient transaction logs. error nnumber 1478.i read in a forum that need to take the log backup and restore that too. is it necessary? i've configured around 100 times successfully, never ever i restored with a log backup. but now i'm getting this kind of error.Note : i'm testing on a new database, which has not even had a single table.thanks in advanceArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-03-11 : 04:17:16
|
| Maybe your full backup is too old...? That the translog has been truncated after your last full backup? The mirroring agent reads from the transaction logs..not the database itself.- LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-03-12 : 01:19:02
|
| the database is a new one, and just created. as i mentioned, that database is not even had a single table.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Mirroring error 1478