Thanks Jason...! Actually, I was configuring a "Database Mirroring" once, so thought to post the question to the Group! 🙂

Option of the question doesn't look correct to me..Though I made it correct!

Pradeep your response is looking very strange to me..!

I could not able to finish the installation of the SQL Server Service .... while starting the service the erro:

".....timely fashion" error...

Thanks for giving the recommendation.

However, I am using the 'SQL Server 2005 Enterprise Edtn', not Express.

Do the solution provided by you, will hold good?

Hi Bradley B,,

Not sure, whether I need to reply to your response in front of the vast majority of users, however, kindly don't type such kind of questions. This is...

Sure Gail..

Thanks Dan.

One more query, after taking the SQL Server Instance in Single user mode using -m parameter, if I need to revert it to 'multi user' what is the correct...

Guys,

If I don't want any 'data loss' and want to recover the database from Suspect mode, well, how to do it? Moreover, I don't have any 'backup' of the database...

Thnaks Gail...I will certainly look for the articles\scripts.

I requested for some better approach. Writing the code would not be very difficult, since regarding the script I can open BOL\google and...

Yes, you're correct. This is a hometask as well as an improvement plan to the existing system. While writing the script, I am unable to come up with a good...

1. To get rid of th problem the database, where the insert\import operation is bulk should have the T-log bkp should be configured to run frequently to truncate the T-log...

Any update, guys..?

Yup. Thanks Buddy..!

I've already taken 'Script out' of all the SPs thru 'Generate Script' and taken the list thru 'Export List'.

You're absolutely correct. I too believe the same. Will pass across the comments to Dev.