Thanks Jack Corbett.

Yes, Now, I want to know how I can find the duration of that query ? i.e start time and end time.

Is there any script or query or...

Thanks a lot Ashish.

Regards,

Ravichandra.

Thanks, you are correct, it will be useful;but Just I want to know how to change it back to norecovery mode.

Thanks and Regards,

Ravichandra.

Thanks very much.

One more doubt !!

Is it same method have to use when changing from standby mode to norecovery? please

Thanks and Regards,

Ravichandra.

I have restored the secondary database with norecovery mode.

Now,I want to change it to standby mode for reporting purpose( read-only mode ) i.e, to run select queries.

Thanks and Regards,

Ravichandra.

Thanks Ashish.

Actually my query is how to change the recovery status from standby mode to norecovery mode.

I have configured logshipping in SQLServer2005 with sencondary database in Standby mode.

Now,I want to...

Hi Gail Shaw,

Thanks. I read the below information from one article.

"In SQL Server 2000 you won't be able to take full backup of log shipped database, because this will break...

Hi Gail Shaw,

Sure, thanks for the help and valuable suggestions.

I will investigate further and get back to you If I face any queries.

Regards,

Ravichandra.

Ok, So, Stored procedure is not causing this issue.

You have suggested one option that splitting files..means is it adding one more ndf file ? or Splitting mdf file? If this...

Thanks Gail Shaw.

I have googled many times but I couldn't find the right solution as I can see it's needs to investigate from scratch level and also Iam new to...

Thanks Gail Shaw.

It would be grateful if you give the clear solution on this please.

Regards,

Ravichandra.