Trick question.

1) Full Backup - doesn't affect the log size

2) Log Backup - truncates the log by removing the inactive data, but does not change the size of the .ldf....

Yes, you can keep them offline forever. You just won't be able to use them. Were you using Enterprise Manager to view the status? If so, EM doesn't 'refresh'...

Jey,

You can restore any differential that followed a full backup. Example:

Sunday - full backup

Monday - differential

Tuesday - differential

Wednesday - full backup

Thursday - differential

Friday - differential

Saturday - differential

You can restore the...

Rama,

This is what you said: restore additional trasaction logs (check this radio button in the restore database options tab)and then restore the differential backup.

That says you restore transaction logs and...

Again, I don't know of anything that lets you read tlogs that are already made. I believe all the available software must be installed and then tlogs made after the...

It sounds like Veritas didn't release the connection. It may have been doing some checks or just being a pain.

That's one of the reasons I don't use third-party software to...

Prakash,

This forum "Question of the Day" is only for comments about the Question of the Day. You need to post your questions in an appropriate forum area.

But to answer...

My understanding is that Auto Shrink is an 'when possible' feature. It's not 'timed' to anything. So, it will Auto Shrink during the day if that's when SQL Server...

Rama,

Sometimes when a database is suspect, just detaching it and attaching it will fix it.

-SQLBill

Where does it indicate LOADING? In Veritas or in Enterprise Manager?

Normally, LOADING indicates that the database is awaiting another file to be restored. This means that you restored a file...

Rama,

You can't restore Transaction Logs and then restore a Differential.

Jey,

Are you sure you used the WITH NO_RECOVERY option on the Full restore?

Are you sure you have the correct Differential backup?

-SQLBill

1. You need a third party software to read the transaction logs. Lumigent's LogExplorer is one.

2. In Query Analyzer, you can run the BACKUP LOG dbname WITH TRUNCATE_ONLY command to...

When you restored the full database did you use the WITH NORECOVERY option?

RESTORE DATABASE dbname

FROM.......

WITH NORECOVERY

If not, then you cannot restore any more files to that database.

-SQLBill

You say you 'assume' the server is running out of space. Have you checked? That's the first thing to do. There are several reasons to get this message.

1. There isn't...

No degradation. Everything runs faster after I've done a defrag.

-SQLBill