Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-sqlserver > #1786

Error message from backup of ReportServerTempDB database

X-Received by 10.182.66.234 with SMTP id i10mr18706141obt.12.1407670224324; Sun, 10 Aug 2014 04:30:24 -0700 (PDT)
X-Received by 10.140.25.162 with SMTP id 31mr730qgt.9.1407670224296; Sun, 10 Aug 2014 04:30:24 -0700 (PDT)
Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!h18no11073022igc.0!news-out.google.com!b3ni24360qac.1!nntp.google.com!j15no5987634qaq.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups comp.databases.ms-sqlserver
Date Sun, 10 Aug 2014 04:30:24 -0700 (PDT)
Complaints-To groups-abuse@google.com
Injection-Info glegroupsg2000goo.googlegroups.com; posting-host=199.203.172.65; posting-account=MXILnAoAAABzRt24fUo__quxlU_o2uKO
NNTP-Posting-Host 199.203.172.65
User-Agent G2/1.0
MIME-Version 1.0
Message-ID <05ec6b01-d17d-45f8-8849-ffb0108c8b44@googlegroups.com> (permalink)
Subject Error message from backup of ReportServerTempDB database
From DavidGr <tanyadavidg@gmail.com>
Injection-Date Sun, 10 Aug 2014 11:30:24 +0000
Content-Type text/plain; charset=ISO-8859-1
Xref csiph.com comp.databases.ms-sqlserver:1786

Show key headers only | View raw


I created a subplan of a maintenance plan to backup the ReportServerTempDB database.
I run the backup as a step in an Sql Server job.
The run of the database backup subplan fails with the error:
"DTExec: Could not set \Package\ReportServerTempDB full backup.Disable value to False." 
and the step does not run.

The command line I use in the step is:
"/SQL "Maintenance Plans\BCK - Weekly Backup" /SERVER "GVIA-SQL"  /CHECKPOINTING OFF /SET "\Package\ReportServerTempDB full backup.Disable";False /REPORTING E"

which I copied from commands I copied form other databases I set up.

Does anyone know how I could change the command lime in order to backup the database ?

Thanks
David

Back to comp.databases.ms-sqlserver | Previous | Next | Find similar


Thread

Error message from backup of ReportServerTempDB database DavidGr <tanyadavidg@gmail.com> - 2014-08-10 04:30 -0700

csiph-web