drop index indexname on tablename

hie monster,

can u please tell me what are the steps to check when a database is running slow?

hie,

ways to monitor logshipping

run these in msdb database

select * from log_shipping_monitor_alert

select * from log_shipping_monitor_error_detail

select * from log_shipping_history_detail

select * from log_shipping_primary_databases

select * from log_shipping_monitor_primary

select * from log_shipping_secondary_database

select * from log_shipping_primary_secondaries...

hie,

can u tell me what the exact error message was..go restore job ->view history->and copy the error..

1,check the sqlserver agent has proper permission

2,shared folders for backup and restore

3,secondary server is...

standby:database is in stand by mode means only read purpose available for selection.generally this state is kept for logshipping.DML commands doesnt work in this mode..

norecovery:the database is looking for additional...

go to job what u created let me called "myjob".so go to jobs->myjob->right click n go to view history.u can edit the job

thank u so much

thnx i learned a new information from you..my doubt is can i restore a database even it is in online mode?

number of users working on that database so kill the users who r working long time and check the long running queries and apply proper indexes ,joins and increase the...

i had a database and that is in online mode.i like to restore that database with available backups.so in that particular database lot of users are working.so is it possible...

okey gail..i will do what u said ...thank u so much..

thank u so much for sharing ur valuable time with me...

yes