i havent heard of it, is the database accessible for you?

can you check the extension again?

working method like connection in sql authentication any way we have to give user and pwd credentials, windows authentication hope wont work on adminstrator access.

registered servers again will depend on...

thanks that a good catch

opc me too confused

if you launch as administrator will it make any difference in SSMS working method? i dont think so.

The error clearly says full backup is not availale.

check any log truncation or shrink happened before the backup starts.

try doing the fullbackup and then differenctial in sequence again.

what is your database size now? do you have log backup?

Have you understood completely, what Gail said? if your DB is 500GB it will try to increase by 50GB which...

Schedule a log backup immediately, else you cant go for point in time restore and may have to loose data between the previous full backup and server crash(incase).

thanks guys for the inputs.

Jeff Moden (1/13/2013)

---

There are some mitigating factors such as whether or not the database has been changed to bulk or simple recovery modes but, if no such thing has happened,...

lynn,

that exactly i want to do.

Gail,

i have asked just to clear my confusion but is there any other work around?

how frequently the DB grows with 500MB growth settings

take this into consideration while setting auto growth option.

i ddint get this..

just a doubt, why dont you try log shipping or am i missing something?

what do you mean by "after power cut.". is it connected to proper backup supplies?.

what is the sql error log and windows logs says, post that as well.

yes, i have even tried it with the sp with parameters and checked the sp which is calling this also.

i cant find any issue as most of them works fine...