Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2010-06-18 : 12:45:53
|
| Hi,i'm trying to take the log backup of the database.even right click properties also not working.error:Msg 9002, Level 17, State 2, Line 1The transaction log for database 'mydb'is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databasesArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-06-21 : 16:28:37
|
| What about through the query client as opposed to EM or SSMS? It almost sounds like the disk partition is full, and if you do not have any other disk space available, you may have to truncate the log on backup and shrink the file. (see BOL for details). If you have ample free space, then my guess is you have limitations set on the database that the log cannot grow above a set amount perhaps? More details will allow for more accurate suggestions for resolution. What is your backup strategy?Terry-- A word to the wise ain't necessary - it's the stupid ones that need the advice. -- Bill Cosby |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-06-22 : 00:33:17
|
| Solution for this:we need to create a login and make it as dbo to the database. then it will accept to take a log backup, and everything like shrinking. later change the owner to sa, and drop the login. you will be all set.Reason: the dbo of the database got dropped.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
property owner is not available