Is there anything like that in Oracle.? Anyone aware.?

Just curious....comparing both..

When I told some of my friends that now I have become an SQL Server DBA (certified as well), they...

Had not even heard about it...damn did some googling and got the points...I just dint want to lose 7 points !!...hehe.

Thanks for teaching something new...!!

Will 'transparent data encryption' in SQL-20008 help i this case..?

Please guide

Thanks.

About a year ago we hired a DBA with over 10 years of experience. About total of 10 people inteviewed him - all of them he passed (and the questions...

I agree with you...But still it's better to...

"REPAIR_ALLOW_DATA_LOSS" - I don't think this is first solution for the situation..... Perhaps it might be the last one.....

This reply is for whom ?

So what you did after identifying the issue.? how you brought the server back to online.?

select * from sys.syslogins

or

sp_helplogins

Thank you somuch. I am very much clearon it now.

So it's better not to shrink the log unless it's too large.

So that SQL server can use the same space in log and it doesn't have to expand it everytime....

There can be possibilities if some of the following are true. (there may be more reasons.. but the ones i have been through)

When you move a database across servers (test...

Hello,

Can you please mail me the pdf.

My email ids - nairsanthu1977@yahoo.com, nairsanthu1977@gmail.com.

Thanks in advance.

Just one more doubt,

Suppose we truncate the log but we dont shrink it.

What will happen in that case ? Will SQL Server reuse the space in log or it will...

Returned to what ? That sapce will not be used further.?