Thanks Henrico.

My query is, Does SQLServer 2008 R2 Developer edition Supports the SSRS?

It's taking more time to restore Tlog backups on secondary db,hence, it's still not in synchronization.

Thanks and Regards,

Ravi.

Thanks for your reply.

Will log chain be break/logshipping get failed if we take differential backup of the primary db ?

Thanks and Regards,

Ravi.

How to execute the storedprocedure in all databases? as I want to schedulre it in sqlserver job

EX: if we want to execute SP in specific db

USE DATABASENAME

EXEC SP_STOREDPORCEDURE

I want it...

Thanks for your reply.

My query is,how we can run single query using two databases in single query window in parellel?

Thanks and Regards,

Ravi

Thanks for your advice.

Thanks Ashish.

Could you please shed more light on this?

How we create file group,move table to filegroup ,take filegroup backup ?

Your help is much appreciated.

Thanks and Regards,

Ravi.

Hi Hakuna Matata,

Thanks for your valid inputs/reply in time !!

Sure, I'll check this on testing envi and update on Production.

Best Regards,

Ravichandra.

Hi All,

Can someone please advise me on this.

Thanks and Regards,

Ravi.

Hi All,

Can someone please give me a quick heads-up on this ?

Thanks and Regards,

Ravi.

Thanks for your valid inputs.

How we can activate licence key for SQLServer2008 R2 Enterprise Evaluation Edition (trial version) ? as it will expires in another 30 days.

Does...

Thanks Gail.

In SQLServer 2005, we will take the avg_fragmentation_in_percent to check whether index needs to be reorganize ore rebuild.

Index should be rebuild when index fragmentation is great than 40%. Index...

just I want to know in general what is the max db size supports in sqlserver?

Thanks and Regards,

Ravi

Yes, I've configured and left as default..

Still I'm not able to connect....when I'm trying to conncet throwing "Invalid namespace "

Please advice.

Thanks and Regards,

Ravi

Thanks for your reply !!

Can we automate to copy backups from one server to another server by using Copy Command in Jobs ?

But when job runs next time only latest...