in this kind of situation,

there are lot of things to be considered, the main thing is what is there in the disk drive????????????

is it DB related only then all...

Hi Balbir,

by just disabling the restore job for some time this issue will not get solved, but i doubt it might land up u in much more trouble as...

for this if your primary objective is restore should happen only after 2 weeks, for this you can directly create backup copy and restore manually and schedule it accordingly without...

If you want to list out all the Logins with permissions then you can use sysXlogins table in master DB , similarly in a database you can query out from...

Applying Hotfix on test and DEV enviorment is always the best practice, but while applying patches plz keep in mind to stop sql services , bcoz it mostly aviods rebooting...

Thanks All, All your replys were very helpful to me,

Can you see the database listed in the enterprise manager, if so is there anything written in the braces such as offline or some thing, check with the properties and...

its sql server 2000

yes, i am sorry it was by mistake speled as tables, its DB's

yes i am able to see the system tables