Hi,

Jeff is right, As per my knowledge if the auto shrink option is also uncheck in your scenerio, then auto shrink of the log file cannot be done automatically.

The possible...

Hi Lester,

Can you let us know a bit more about the issue ?

1) From when u have noticed about this issue ?

2) How do u confirm that the Transaction logs...

Hi,

You can recover to a point in time by recovering only the transactions that occurred before a specific point in time within a transaction log backup, rather than the entire...

Hi Shiv,

Kindly look into the below MS KB, where you can find a more info.

http://support.microsoft.com/kb/907511

For your reference read the below

http://msdn2.microsoft.com/en-us/library/ms189493.aspx

If you have any issue after following these steps,...

Hi,

Did you checked out the Eventlog and the SQL error log?  If you find any entities in the App log, do post it.

It would be helpful to narrow down the...

Karthick,

I seems that you are using the enterprise manager to restore the database.

Here it goes to perform in EM.

1) First restore the Full back- While performing the full back select...

Hi,

kindly check the Microsoft KB Article ID : 834112.

http://support.microsoft.com/kb/834112/en-us

You can add the following command before the CHECKDB

SET ARITHABORT ON

SET QUOTED_IDENTIFIER ON

Dasha,

Thank you for the reference...

Thanks you so much.. I will look into it...

Best Regards

Hi Steve,

Thank you for your response

We have a production server, SQL Server 2000 with SP4, in which the maintaince activities was not running...

Hi John,

As I am new to the DBA Administration, Kindly share the valuable information, that you would take, so that I can also make note of it.

If any situation araises,...

Sandeep,

check out with this Query.

Insert into Table3 (Name)

Select Name from Table1

Insert into Table3 (Name)

Select Name from Table2

Best Regards

Senthil Kumar

Thank you to all for providing a valuable information. Let me check it out and get back to you...

Best Regards

Senthil Kumar.R

Hi Vincent,

Thank you for the details mail. As I am new in the SQL DBA Environment, I see that we need to assign some...