Any Full backup won't break the log chain whether you take Commvault log backup or a native log backup.

Thanks for your reply......

I can't place it in SSIS as we don't have SSIS in all the environments . I am trying with sqlcmd which is little bit easy to...

Thanks for your response Syed..

1-Qurum

1-MSDTC

-SQL Server Drives(as you want and required)

Does these require separate drives or can we have all these on a same drive?

I have seen in many blogs...

I have gone through these blogs but unable to find the answers..Can you please answer my questions if possible.

Thanks for your responses..

Vamsy

Thanks for your reply...

We are planning to do sqlserver cluster installation. So for this We need to cluster the windows server and then perform sqlserver cluster installation on it.Right!

I have...

Hi all,

Anyone please suggest me on this..

Thanks,

Vamsy

Hi Gail,

Can you please elaborate this if you don't mind.

"The restore is done with norecovery, but if the edition is Enterprise, the DB remains online (in most cases) "

As in...

Hi,

I have gone throught several blogs on Page restores. But the process of page restore looks like this:

Restore the corrupted page from the latest full backup

Take the current...

Thanks for your suggestions Gail and Ray

Small question:

I have moved the data from the corrupted database to the new database. Will the new database get corrupted because of importing data...

Can I use page restore from full bakcup in case if am in full recovery model to recover that page which is corrupted?

Thanks,

Vamsy

Gail,

So if I turn on the checksum option while backing up databases.Will sqlserver intimate me about this error before?

I opted your suggestion. Restored full backup and incremental which is...

Gail,

Our database is in simple recovery model so no log backups. I have full backup taken on saturday and one incremental backup(valid backup) which is on sunday.

But I am able...

Thanks for your reply Gail

DBCC CheckDB(<Database name>) WITH No_INFOMSGS, ALL_ERRORMSGS

I ran this checkdb command but it failed throwing the error which I had sent before.

Thanks,

Vamsy

Grant,

Its been resolved .

I ran sp_recompile 'spname' to recompile the stored procedure when ever its been called as this is a report that will run once in a week.

By doing...

@sql_butterfly,

1. You can run sp_recompile 'spname'

This will recompile the stored procedure every time is called.

2. Other way is to recreate the SP with recompile option.

Both of these options...