Community
Vault Forum
Welcome to Autodesk’s Vault Forums. Share your knowledge, ask questions, and explore popular Vault topics.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Error shrinking database

3 REPLIES 3
Back to Vault Category
Back to Topic Listing
Reply
Message 1 of 4
jprizzo
Contributor
481 Views, 3 Replies
‎12-09-2008 08:58 AM
‎12-09-2008 08:58 AM

Error shrinking database

Hello,

In our backup script, I am using the sql statement recommended on this
newsgroup for shrinking a database:

osql -E -S ".\AutodeskVault" -Q "USE Vault DBCC SHRINKDATABASE(Vault, 10)"

In reviewing our backup logs, I noticed the following error message:

Cannot shrink log file 2 (Vault_log) because all logical log files are in
use.

As a result, we have log files that have grown to be much larger than the
databases themselves. I googled this error message & it seems that I need
to backup the log, but I am hesitant to perform any kind of backup
independent of the ADMS backup utility. Does anybody have a recommendation
of how to get around this error message and safely shrink a database in my
backup script?

Jon
Report
0 Likes
Reply
3 REPLIES 3
Message 2 of 4
Anonymous
in reply to: jprizzo
‎12-09-2008 12:45 PM
‎12-09-2008 12:45 PM


Is the Vault database is in "Simple" recovery mode?
If not set the recovery mode to Simple. You can do this through the SQL Server
Management Studio. Select the Vault database and right click select properties.
In the database properties go to Options and then  set recovery model to
simple.


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
Hello,
In our backup script, I am using the sql statement recommended on this
newsgroup for shrinking a database: osql -E -S ".\AutodeskVault" -Q "USE Vault
DBCC SHRINKDATABASE(Vault, 10)" In reviewing our backup logs, I noticed the
following error message: Cannot shrink log file 2 (Vault_log) because all
logical log files are in use. As a result, we have log files that have grown
to be much larger than the databases themselves. I googled this error message
& it seems that I need to backup the log, but I am hesitant to perform any
kind of backup independent of the ADMS backup utility. Does anybody have a
recommendation of how to get around this error message and safely shrink a
database in my backup script? Jon
Report
0 Likes
Reply
Message 3 of 4
Anonymous
in reply to: jprizzo
‎12-10-2008 05:39 AM
‎12-10-2008 05:39 AM


It was set to the way Vault created them -
Full.  I set them to simple & I will have to wait until tomorrow to see
if the shrink is successful during tonight's backup.  I have to ask,
though.  Why doesn't Vault create it's databases this way
automatically?

 


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">


Is the Vault database is in "Simple" recovery
mode? If not set the recovery mode to Simple. You can do this through the SQL
Server Management Studio. Select the Vault database and right click select
properties. In the database properties go to Options and then  set
recovery model to simple.


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
Hello,
In our backup script, I am using the sql statement recommended on this
newsgroup for shrinking a database: osql -E -S ".\AutodeskVault" -Q "USE
Vault DBCC SHRINKDATABASE(Vault, 10)" In reviewing our backup logs, I
noticed the following error message: Cannot shrink log file 2 (Vault_log)
because all logical log files are in use. As a result, we have log files
that have grown to be much larger than the databases themselves. I googled
this error message & it seems that I need to backup the log, but I am
hesitant to perform any kind of backup independent of the ADMS backup
utility. Does anybody have a recommendation of how to get around this error
message and safely shrink a database in my backup script?
Jon
Report
0 Likes
Reply
Message 4 of 4
Anonymous
in reply to: jprizzo
‎12-10-2008 02:21 PM
‎12-10-2008 02:21 PM


From Vault 2009 onwards when you create a new Vault
the database will be in simple recovery mode. Any database that is migrating
from previous release to Vault 2009 will also have the recovery model set to
simple.

 

Which version of Vault are you using?


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
"Jon Rizzo" <jrizzo at langan dot com> wrote in message
href="news:6087114@discussion.autodesk.com">news:6087114@discussion.autodesk.com...


It was set to the way Vault created them -
Full.  I set them to simple & I will have to wait until tomorrow to
see if the shrink is successful during tonight's backup.  I have to ask,
though.  Why doesn't Vault create it's databases this way
automatically?

 


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">


Is the Vault database is in "Simple" recovery
mode? If not set the recovery mode to Simple. You can do this through the
SQL Server Management Studio. Select the Vault database and right click
select properties. In the database properties go to Options and then 
set recovery model to simple.


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
Hello,
In our backup script, I am using the sql statement recommended on this
newsgroup for shrinking a database: osql -E -S ".\AutodeskVault" -Q "USE
Vault DBCC SHRINKDATABASE(Vault, 10)" In reviewing our backup logs, I
noticed the following error message: Cannot shrink log file 2 (Vault_log)
because all logical log files are in use. As a result, we have log files
that have grown to be much larger than the databases themselves. I googled
this error message & it seems that I need to backup the log, but I am
hesitant to perform any kind of backup independent of the ADMS backup
utility. Does anybody have a recommendation of how to get around this
error message and safely shrink a database in my backup script?
Jon
Report
0 Likes
Reply
Reply

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

Report a website issue