Hi Pradyothana, thanks for the reply. about the link I'll look into it. And about the CU4 (Cumulative Update), what will happen if I don't install it, is there any...

Hi Sujeet thanks again for the reply, I'll check your web link that you gave me later on. By the way I Installed upgrade advisor in my production server and...

Hi Sujeet thanks for the reply, I think my upgrade strategies will be an In-Place Upgrade, so what will happen if do that kind of strategy.

Thanks 🙂

Markus, thanks for the reply, I've checked the link you gave me, but I still don't have any confidence yet to upgrade my SQL Server 2008 to the R2, of...

Hi Markus, thanks for replying, and of course thanks for the advice I'll look into that. By the way, about ur advice to upgrade my production server sql server to...

Okay, I'll check and give it a try for it, thank you so much for the advice, this thread really help me related to this problem. Again thank you for...

Hi GilaMonster, I finally found how to shrink the log file. First I run the dbcc opentran query first to check if there's any active transaction running on my database....

GilaMonster (11/2/2010)

---

Well your log reader isn't running and, from the opentran info has never run. Hence if this is supposed to be publishing it's not set up correctly or someone...

Yes, this database is a subscriber from another server and also a publisher to...

Hi, GilaMonster I'm sorry if I missed out your word as I quoted above, really sorry,...

Hi GilaMonster, thanks for the replies. I already did the query that you gave me which is :

(DBCC SQLPERF(LogSpace))

and the result is :

Database NameLog Size (MB)Log Space Used (%)Status

-----------------------------------------------------------------

Data_All_DB ...

First of all, thanks for all the replies. For information I already use this command :

Alter Database Data_All_DB Set Recovery Simple

GO

Alter Database Data_All_DB Set Recovery Full

GO

DBCC SHRINKFILE ('Data_All_DB_log', 1)

GO

but that...

hi thanks for the reply, I guess you guys were right. I already try to change the precision and scale options in the advanced editor, but turns out to be...

hi thanks for the reply, I guess you guys were right. I already try to change the precision and scale options in the advanced editor, but turns out to be...

Hi stewartc, thanks for the reply. I already check the data type both from the oracle and sql server. They are the same, both of them are NUMERIC(38,0) but still...