i have configured a transaction replication between sql 2k5 databases which are located in two different cities. this replication is very slow to...
Sometimes something strange happens. I try log restoration once again, after checking retore headeronly, and it works fine. I was able to restore...
When i try i get error about LSN "the log in ths backup set begins at lsn xxx which is too late (early if i try for older bckp file) ..log backup...
Thanks, can you explain further as i am unable to get it completly. quote:Originally posted by MohammedU Yes, you can restore tlog on top of...
i have full backup through veritas exe and log backup through sql server itself. unfortunately i lost full backup taken through sql server and i dont...
Is there anyway we cant adjust the replication speed according to network capacity, like speedy replication with big data packets for fast networks...
below is one set of queries having an issue. SELECT DISTINCT SM.SM_CODE,SM.SM_NAME FROM SalesMan_Master SM JOIN CDTNOTE_HEADER CH ON...
to find out the problem, i put both the database on my test machine for testing, so the hardware should not be issue. its IBM x236 with 2 GB ram and...
the result of one of the query is SQL Server parse and compile time: CPU time = 32 ms, elapsed time = 50 ms. SQL Server Execution Times: CPU...
to further investigate the reason, i restore both the database in my test machine, still the situation is same. one is performing normally while...
i have two identical database at two different branches. their sizes differ by about 20% and server machine are also identical. but the performance...
i too face severe performance issue with a similar stupid vendor application. the worse thing is, that vendor is not give any support for long and we...
Can i be due to stopping of log reader agent. suppose if my log reader agent is stopped due to any reason, what will happen to transactions that...
that means i cant find out why this happen, so that i prepare for the future. this is very rare so i just cant put profiler to check it. Important:...
recently i find out that some of the records are missing during the transactional replication. only thing that happen is that user stop the...
I have transactional replication between head office and branches located in different cities. network connection can go down sometimes and hence...
as per my knowledge, the log file size should be reduced after log backup, but its not happening in my system. once the log file size is increased...
i have an identity column which is NOT part of primary key. i have multiple publisher one susbcriber transactional replication (all invoices from...
Thanks god and thanks everybody. finally, i could make my db back to normal. how ??? i just drop existing indexes and create them back. its funny,...
is there anything like database corrupting or sql server corrupting. because almost all my results are fine and there is nothing significant happen...
Separate names with a comma.
