Thank You Rudy for your answer.

Hi Everybody,

Thank You all for your response.

I am using the same database on Sql server on xp sql server on windows 2000, application is also the same.

I think there...

Hi Karl,

Thank you very much for your reply.

Hi,

Try this

Check the auto shrink option in the database properties option.

Hi,

You try this.

create trigger trig_delete_search

on search for delete

as

insert into deletionhistory

(select firmfile,system_user,getdate() from

deleted);

end

Hi Bill,

Thank you very much

Hi Jey,

Are you resolved ur problem or still hanging over there?

Hi Bill,

I am taking full backup on saturdays and daily incremental backups. I am restoring the db's with full backup and then differential backup through EM as i said above...

Hi Bill,

I did't try this one. I did resetstatus on suspected databases. Thank you bill i learned a new thing from you.

I got one more doubt on suspect state. I...

Hi Jey,

First restore the Full backup with option Leave database read_only and restore additional trasaction logs (check this radio button in the restore database options tab)and then restore...

Hi Andreas,

In EM i found some of the databases are in suspect mode. Then i did some sp_resetstatus and checkdb. After restarting the server, i am unable to start the...

Hi Amit,

Sorry i am unable to reply you i was busy with some other work. Finally i got the backup from my sys admin and i restored the db successfully....

Hai Amit,

Thank you friend for your explanation.

My database is not yet attached.How can i run sp_resetstatus on the database? I am newbie to sql server pls....What ever you gave the...

Hi Amit & Srinivasa Rao,

Thank you for your suggestions.

Amit I am unable to send the .mdf file because its company policy. Tell me how to do the job if...

Hi Vikas,

I moved log file to some other location and i am attaching the database with this command.

EXEC sp_attach_single_file_db @dbname = 'garage',

@physname = 'e:\mssql7\garage_data.mdf'

I am getting...