Recovery from a Snapshot and applying Differential and Transaction Logs on top of it????

Hi friends

I'm using Oracle, asp.net, vb.net & EL 4.1

Could anybody please tell that

How to write Logs into text file if the Oracle DB is not available using MS EL 4.1

I am developing logging application with asp.net & vb.net & Oracle

At present I'm using this mechanism to write logs

Method1 Connect (
Try{
Conn.open ()
Flag=True}
Catch{
Flag=False}
Finally{
Close () & Dispose ()
 
Method2 WriteLogs (
Call Connect ()
If flag=True
                Write logs into Oracle Database
Else
                Write logs into Text File

 
The problem with above procedure is, I'm using "Method2 WriteLogs" more than 2000 locations in my program. So each time it's opening & closing the DB connections. It's slows the system.
 
I want to use Method2 without using the Method1

is there any solution in MS Enterprise Library to write logs without opening & closing the DB connections, so many times?

Please advice me

Hi, I created a free trial of a BPOS account. In the SharePoint Site, when I apply the "Simple" theme, navigation to any page fires a securty warning dialog box asking "Do you want to view only the webpage content that was delivered securely?".

If I click yes, or if I click no, the site looks the same to me, with the simple theme applied. I haven´t found what is the content (an image I guess) causing the problem.

If I apply the "Liquen", "Default", "Classic" theme, I do not receive any error. I guess this is server side problem. Can I open a support ticket with my free account?

---

Vielka - Comunidad SharePoint Costa Rica - https://ug.culminis.com/sites/CRC-SPS/default.aspx

How can I change the date format in the ULS logs (in C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS)?

We have four WSS 3 farms (three at SP1, one at SP2) and they all write dates in US format in the first column of the ULS logs. For example from today (8th December 2010):

12/08/2010 12:32:19.42  OWSTIMER.EXE (0x0A88)                    0x0358 Windows SharePoint Services    E-Mail                         6871 Information The Incoming E-Mail service has completed a batch.  The elapsed time was 00:00:00.  The service processed 0 message(s) in total. 

The web servers are all running Server 2003 SP2 with the Engligh (United Kingdom) locale (all dates in Windows Explorer etc appear in UK format). In all four farms the SPTrace service runs as the local system account.

I have been searching the web for ages on this and have found no leads.

Any help gratefully received.

Thanks,

SPV

Hi all,

I have just taken over management of an existing SP2010 server and am currently reviewing the event and ULS logs and chasing down any issues. Just recently I have noticed "Upgrade" category entries appearing which seem to suggest an upgrade has been started from a timer job. The first couple are listed here.

 12/15/2010 00:52:23.49  OWSTIMER.EXE (0x06B4)                    0x1748 SharePoint Foundation          Upgrade                        fbv7 Medium   [OWSTIMER] [SPHierarchyManager] [DEBUG] [12/15/2010 12:52:23 AM]: [SPTree Value=SPFarm Name=SharePoint_ConfigDB] added to dependency cache by lookup
12/15/2010 00:52:23.49  OWSTIMER.EXE (0x06B4)                    0x1748 SharePoint Foundation          Upgrade                        fbv7 Medium   [OWSTIMER] [SPFarmSequence] [DEBUG] [12/15/2010 12:52:23 AM]: UpgradableBuildBypassInternal = 0
12/15/2010 00:52:23.49  OWSTIMER.EXE (0x06B4)                    0x1748 SharePoint Foundation          Upgrade                        fbv7 Medium   [OWSTIMER] [SPFarmSequence] [DEBUG] [12/15/2010 12:52:23 AM]: UpgradableBuildBypass = 0
12/15/2010 00:52:23.49  OWSTIMER.EXE (0x06B4)                    0x1748 SharePoint Foundation          Upgrade                        fbv7 Medium   [OWSTIMER] [SPUpgradeSession] [DEBUG] [12/15/2010 12:52:23 AM]: CanUpgrade [SPFarm Name=SharePoint_ConfigDB] returned: True.

What would cause this and is it of concern?

Cheers

Dave 

We are using WCF services for a windows application. For inserting multiple objects contained in a single object into database, we are using Transactions using Transaction Scope class.

We are encountering a strange scenario where even after closing the database connections after insertions and calling TransactionScope.Complete, the connection remains inactive for hours on the Oracle database. Could anyone suggest if this is due to the usage of .NET TransactionScope class?

We are facing this problem only in production environment and not in development environment.

I need to refresh a test server every month so that users can use production data. Will snapshot replication work in such a situation. The test server database will be used and updated with dummy records, how can this be achieved? Will read-only setting pose a problem? Please help. Thanks.

The context is a SQL Native client that inserts data into two tables "TableA" and "TableC" in database "DB1". The operation must be atomic : This is done by using a transaction. So far so good.

On "TableA" in "DB1", I have a CLR INSERT trigger that should also update data in "TableB" stored in another database, "DB2" on the same server. I would like to use the same transaction as the DML that fired the trigger, so that if insert on TableC fails, modifications on TableB are rolled back.

If database DB2 is located on another server, MSDTC automatically promotes the ambiant transaction to a distributed one, and everything works fine.

Is it possible to use a loopback connection string that specify "enlist=false" and write code that manually promotes the transaction ?

Any help appreciated.

TIA.

I recently noticed while setting up transactional replication when i run the snapshot agent on 2 different tables TableA (Size-7GB) and TableB (Size-800MB), the BCP files created by the snapshot agent were different.

It created one 7GB bcp file for TableA and a lot of small (55MB) bcp files for TableB. Can someone explain why the snapshot agent is behaving differently? Why did it not create several small bcp files for TableA?

Thanks in advance! 

Hi

I have been reading on this topic including various blogs by some SQL Server heavy weights, I would like to confirm if my understanding is true.

Here is my understanding, when a transaction happens, the TSQL statement, along with the data page's before any after image is copied to the transaction log ldf file. Is this true?

If so, the second part of the question would be why do we need to have a before image of the data page. Is this used during crash recovery to facilitate fast recovery? Is the after image used for transaction log restores?

I also have some confusion when reading Kalen's book when she talked about the bulk-logged transaction log backup will be larger. If the BCM marks the extent only and not actually write the data pages to the ldf file, then we should have a smaller ldf file in the bulklog mode. During my testing, this had not been the case. I simply created a table and bulk inserted 100,000 rows from a server side trace(a flat file I bcp’ed from a tracetable), and for all three recovery models, I recorded almost same duration and for the transaction log backup of bulk-loggged an full recovery being the same size. Maybe my example is too simple here. Can anyone give me a working example to demonstrate bulk operation is actually faster in the bulk-log mode?

 

Best regards