Thanks guys,

Thanks for immediate reply. OK, let me explain, I want my server accessed by authorized person, like "sa" login only can...

Hi Mohd,

can you help me where can i get that "Lumigent Log Explorer". I want to try that software.

thanks in advance.

Regards,

Arnold

Hi!

Thanks for the inputs, suggestion, tips and other helpful things.

I really appreciated all those things.. Anyway I successfully restored my master db, sysdb...

Hi

I checked the the productlevel using select serverproperty, the following are the result.

machine1 - sp3 (prod)

machine2 - rtm (test machine)

I think i need to download sp3 to machine2

Hi to all,

Thanks for giving me your time....

restore is part of a monthly activity here the company that i been wooking for.. this...

Hi again,

I tried to reinstall the sql server 2000 in machine1. The following are the result of @@version

Machine1 - Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Machine2...

Hi,

I also tried that. I restored my backup file to other machine, and then I restored the specific table. It's a long way, but it works.

Hi to all!

Thanks for all the inputs and suggestions. I reviewed the SPs used by...

Hi to all,

I have the same problem too, whice i ported few days ago. please i need your help, advice suggestions and comments.

Thank you.

Regards,

Arnold

Hi to all,

Thank you for all the suggestions and supports.

Actually my database is used by ecommerce web application, and its a 24x7 production operation. currently my database has 2.5...

sir,

Im using MS SQL Server 2000 Standard Edition, and I frequently used this comman(please see below), just to clear my transaction logs, and execute full database backup and start another...