Viewing 15 posts - 256 through 270 (of 319 total)
Sachin Nandanwar (6/8/2011)
rfr.ferrari (6/8/2011)
DML = Data Manipulation Language, is is how we do the data manipulation, for example: insert, update, delete ...! it's recorded in transation log!!!
Yes I understand that.
But...
June 11, 2011 at 9:15 am
Triality (6/9/2011)
Thanks for everyone's input! I am going to go ahead and switch to full recovery model and do some reading on log shipping and mirroring!
this links, contents very...
June 10, 2011 at 4:47 am
Correct me if I am wrong but I believe that LSN is generated for each record(DML action) and not for each transaction.
DML = Data Manipulation Language, is is how we...
June 8, 2011 at 1:43 pm
Steve Jones - SSC Editor (6/8/2011)
rfr.ferrari (6/8/2011)
fire or explosion was only examples!!!! but if crash my hd? if the hardware by anytime fail??
you are missing the point. Log shipping is...
June 8, 2011 at 1:30 pm
Steve Jones - SSC Editor (6/8/2011)
rfr.ferrari (6/8/2011)
but, with relation the High Availability, forget!!! if my server catch a fire or explode!!!😀
There are more disasters than a fire or explosion. This...
June 8, 2011 at 11:43 am
Sachin Nandanwar (6/6/2011)
I am reading one book on SQL Server internals.When explaining the checkpoint process it states that
"....If the LSN of the dirty page is greater than the LSN...
June 8, 2011 at 10:01 am
WayneS (6/6/2011)
The other available options:
1. Shipping the transaction log: requires Bulk Logged for Full recovery models.
2. Mirroring: requires Full recovery model.
It's a lot easier to...
June 8, 2011 at 9:24 am
in your domain, the dns server is running?
June 8, 2011 at 9:20 am
forsqlserver (6/8/2011)
Why what is the problem with different instance?Can SSRS doesnt work with another db of another instance?
and have SSRS on same instance of DB???
that's right! kepping reporting database...
June 8, 2011 at 7:58 am
forsqlserver (6/8/2011)
But u can use the secondary database as reporting database.
and have SSRS on same instance of DB???
June 8, 2011 at 7:19 am
but, with relation the High Availability, forget!!! if my server catch a fire or explode!!!
😀
June 8, 2011 at 7:01 am
forsqlserver
i'm sorry, but you are correct!!! i finished the test for log shipping!!! it's really works in same instance with differents databases!
Thanks!! it's a very good question!!!!!
June 8, 2011 at 6:57 am
Viewing 15 posts - 256 through 270 (of 319 total)