Community
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<jrizzo@langan.com> wrote inHello,
message
href="news:6086598@discussion.autodesk.com">news:6086598@discussion.autodesk.com...
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
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
"Ajay Choudhary (Autodesk)" <ajay dot
href="mailto:choudhary@autodesk.com">choudhary@autodesk.com> wrote in
message
href="news:6086766@discussion.autodesk.com">news:6086766@discussion.autodesk.com...
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">
<jrizzo@langan.com> wroteHello,
in message
href="news:6086598@discussion.autodesk.com">news:6086598@discussion.autodesk.com...
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
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">
"Ajay Choudhary (Autodesk)" <ajay dot
href="mailto:choudhary@autodesk.com">choudhary@autodesk.com> wrote in
message
href="news:6086766@discussion.autodesk.com">news:6086766@discussion.autodesk.com...
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">
<jrizzo@langan.com>Hello,
wrote in message
href="news:6086598@discussion.autodesk.com">news:6086598@discussion.autodesk.com...
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