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 |
|
getur.srikanth@gmail.com
Yak Posting Veteran
77 Posts |
 Posted - 2010-04-07 : 17:10:26
|
| I am trying to add contentDB from Prod to QA. I used below commandstsadm -o addcontentdb -url http://portalqa.spe.org -databasename WSS_Content_80_Prod -databaseserver spdbqa1\qaIt is throwing an error belowThe transaction log for database 'WSS_Content_80_Prod' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases Changed database context to 'WSS_Content_80_Prod'. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-07 : 18:14:50
|
It's telling you to run a query like this:SELECT log_reuse_wait_desc FROM sys.databasesWHERE DB_name(database_id) = 'WSS_Content_80_Prod' How often are the logs for this database backed up?There are 10 types of people in the world, those that understand binary, and those that don't. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
The transaction log for database 'WSS_Content_80_P