Because i want atleast one value for c3 and c4, and it could be either the oldest value user inserted or the most recent value user inserted.

Thanks Mark, i m...

Thanks alot man

Thanks guys,

dmc can you please share that .net application code?

I am getting the same error........can someone plz guide us...............

My dimensions are processed succussfully, but i m getting this error while processing the cube.

One thing that i figured out is...

Although i m not very much convinced in not shrinking the log file (may be because of lack of exposure to the practicle problems of shrinking)......but just in case....what should...

if i have scheduled the T Log backups on regular basis (after every 1 hour) do i still need to shrink the log files after every backup??or sql server will...

i have seen that, but its not working. SQL Server agent is running under my network user. and i have the access to the other server. But its not working.

"I'm not following you here. No transaction log backup will ever do either of the operations you mentioned (remove virtual log files, or shrink the size of the transaction...

Thanks alot Ray, you have been a great help and btw the solution that you gave me for getting space available after shrinking worked for me, i tried it last...

There you go....now you are successful in satisfying me:)

Now the next logical question is ....ASSUMING THAT SQL SERVER ALSO STORES THE CONNECTION INFO OF EACH TRANSACION IN THE LOG FILE...........when...

"If your database is running in full or [bulk-logged[/b] recovery models, the space is released only after a transaction log backup is made."

Ok this comment is confusing me.

Suppose a user...

But what about the transaction log?

suppose i

--start backup of TLog at 6:00 PM

--New transactions occur at 6:01, 6:02, 6:03 PM (as you said that database will continue as normal)

--backup...

I have used this technique as well, and yes you are right it always worked for me as well. But i ll try Ray's technique tonite. Ray one thing i...

Thanks alot all, specially Ray, hope this will solve the problem. I ll try this tonight can't take the backup right now coz of production environment.

Thanks,

usman

Excellent information on Ray Mond's link. I guess he has pointed to the problem very precisely. But one thing that i couldnt understand in that article is "active log record...