tempdbtempdevN:\Tempdb\tempdb.mdf446.50719.19 10%272.69

tempdbtemplogN:\Tempdb\templog.ldf294.38294.38 50%0.00

can this data is proper ???

Only one thin Alert notifier=> response =>Excute job which job is selected...

1) full backup- option with replace with existing database and recovery with norecovery:-

RESTORE DATABASE [diff_test] FILE = N'diff_test' FROM DISK = N'G:\dinesh\diff_test_full.bak' WITH FILE = 1, NORECOVERY,...

before restoring backup check following...

restore verifyonly from disk ='E:\bk_full_datacenter\test1.bak' --The backup set on file 1 is valid.

restore labelonly from disk ='E:\bk_full_datacenter\test1.bak'-- media related information

restore filelistonly from disk ='E:\bk_full_datacenter\test1.bak'--list filegroups in...

Restoring state is still hang then go right click and Delete option there.You can option with close with connection..select as per your requirement..

How to cancel restoring state of database ??

Which is hanging state in mssql server instance..

I had tried but it showing in restoring state...

But we want use in view .is that possible ??