mmasthanreddy (10/30/2009)

do the following steps to know the full details of the error

1.open computer management from administration tools

2. open the system tools tree

3.open...

GilaMonster (10/15/2009)

No you can't. Until a full backup is taken, the log is auto-truncated on...

Why do a full backup first? Doing a full backup fixed my problem with the same error. I guess you can't backup a log without having at least one full...

I think it's all figured out. I hadn't given the user browser rights to the root folder. Once that was done it all worked.

Thanks for the syntax. That will be very useful.

Thank you for taking the time to respond. I'll have the user check to see if the server is in the trusted security group. His machine is on the network...

I solved my hung database with brute force. I deleted it. Because this is all a testing process before the real move, it doesn't matter what happens to the new...

Thanks, Carl. i have a DBStatus of ONLINE and the mode is SIMPLE. I guess that explains why I can't back up the log.

Things are finally starting to maek sense....

Now i've done it!

I ran this before I found out I didn't need to load the log file.

RESTORE DATABASE FRS

 FROM DISK = '<path to...

Thanks Steve and Lynn.

If I don't need the log file for a restore, I'll skip it for now. But I would like to find out why I can't back up...