Vault General

Reply
Contributor
jprizzo
Posts: 11
Registered: ‎11-13-2006
Message 1 of 4 (258 Views)

Error shrinking database

258 Views, 3 Replies
12-09-2008 08:58 AM
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
*Ajay Choudhary \(Autodesk\)
Message 2 of 4 (258 Views)

Re: Error shrinking database

12-09-2008 12:45 PM in reply to: jprizzo

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
*Jon Rizzo
Message 3 of 4 (258 Views)

Re: Error shrinking database

12-10-2008 05:39 AM in reply to: jprizzo

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
*Ajay Choudhary \(Autodesk\)
Message 4 of 4 (258 Views)

Re: Error shrinking database

12-10-2008 02:21 PM in reply to: jprizzo

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

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
New button for Platinum & Gold Subscription customers
Gold & Platinum Subscription customers can alert Autodesk if they require assistance with their forum post

Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community