HI,

check with below query.

RESTORE VERIFYONLY FROM DISK = 'C:\dbbackup.bak' with stats=1

finally (output) backup is valid means OK.other wise its wrong.

Again took the backup.

Thanks got it.

Hi Friends,

Thanks. After dropping indexes, shrinking of the database is in runnable state.

Hi Friends,

Nothing is running in the server other than shrinking, as its weekend we have stopped our applications & we have even restarted server for the activity. Eventhough it didn't...

Execution plan attached.

thanks !!

but i need more information....

please help me...

Is there any other dynamic view where I can get which user has dropped the table.

Different file groups

Am ready to purchase a material on perfmon counters. Please suggest a best materail on this.

Hi Team,

Thanks a lot. The above script is working fine...

Thanks a lot..

HI Team,

From the above query am getting the queries hitting in that DB. I need from which sql login that particular statement is running.

Thanks in advance.

When i use it, the login is created. But it is disabled.

Thanks for the reply when i tried with this command before the rar it is working.

"C:\Program Files\WinRAR\WinRAR.exe"

Is there any other way other than this?

Thanks for the reply. Its working fine.