I have seen this "bug" many times personally, but cannot seem to find any posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT include licence for Enterprize Manager (EM)... but any technician who does have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access Licence) does have Enterprize Manag
er and can connect and manage MSDE and SQL engines/servers equally well.
Consider http://support.microsoft.com/default...22&Product=sql Here we see substantiation that one "can" use EM and Maintenance Plans on MSDE, albeit that you had better be the latest Service Pack since the sqlmaint feature was over
looked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for Database Backup, Transaction Backup (and Log text files). This is important because unless you can also choose to do so, one will end up filling the hard disk with far too many SQL
dumps.
If connected to an SQL server... the option works fine. If connected to an MSDE, the option fails to provie the drop-down for days/weeks and the resulting job created has bugs in the command line options of the job step which one must then go and manuall
y tweak to be correct (never report a bug without a workaround eh? ;-P)
John,
As far as im aware this happens because the maintenance wizard
(sqlmaint.exe) is looking for a backupdirectory string valuein the MSDE
instance registry location.
(I would maybe do this on a test machine first if possible or make sure you
have backups)
So firstly make sure the following backup folder path exists , if not create
it :
c:\program files\microsoft sql server\<MSDE instance>\Backup.
Then in regedit:
HKLM\Software\Microsoft\Microsoft SQL Server\<MSDE instance>\MSSQLserver
there should be a BackupDirectory string value , the value data should be
the physical path to the backup folder in our case c:\program
files\microsoft sql server\<MSDE instance>\Backup.
HTH
Dylan
"John D. Sullivan" <John D. Sullivan@.discussions.microsoft.com> wrote in
message news:835E25B5-6EE5-4533-A1D5-43D3873BC0B1@.microsoft.com...
> I have seen this "bug" many times personally, but cannot seem to find any
posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
> Consider
http://support.microsoft.com/default...22&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
|||Thanks for the thought. No that's not what I mean (see my additional post
in next thread). About the backup folder here is what I did discover the
hard way..
When creating the Maintenance Plan...if one chooses "use the default backup
directory" then it seems to work, and the (first) backup will create the
folder path even if it did not yet exist. However if you specify a "use
this directory" to backup to... then I have found that folder you specify
had better exist already because the backup job will fail rather than create
it. So there's a little idiosyncracy for ya. (I have not experienced the
issue you mention, but perhaps that is an issue if the SQL is installed as a
"named" instance of SQL instead of the default/single instance of SQL? in
which case thank you for the additional tweaks)
John D. Sullivan
ABELSoft Corporation
"Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
news:OQXmdsjaEHA.3596@.tk2msftngp13.phx.gbl...
> John,
> As far as im aware this happens because the maintenance wizard
> (sqlmaint.exe) is looking for a backupdirectory string valuein the MSDE
> instance registry location.
> (I would maybe do this on a test machine first if possible or make sure
you
> have backups)
> So firstly make sure the following backup folder path exists , if not
create[vbcol=seagreen]
> it :
> c:\program files\microsoft sql server\<MSDE instance>\Backup.
> Then in regedit:
> HKLM\Software\Microsoft\Microsoft SQL Server\<MSDE instance>\MSSQLserver
> there should be a BackupDirectory string value , the value data should be
> the physical path to the backup folder in our case c:\program
> files\microsoft sql server\<MSDE instance>\Backup.
> HTH
> Dylan
>
>
> "John D. Sullivan" <John D. Sullivan@.discussions.microsoft.com> wrote in
> message news:835E25B5-6EE5-4533-A1D5-43D3873BC0B1@.microsoft.com...
any[vbcol=seagreen]
> posting on the Internet about it. I have many customers using MSDE
Enterprise[vbcol=seagreen]
> Manager when connecting to MSDE.
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> http://support.microsoft.com/default...22&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> an MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
>
Showing posts with label customers. Show all posts
Showing posts with label customers. Show all posts
Thursday, March 8, 2012
Bug in Ent Mgr Maintenance Plan Wizard if MSDE vs SQL
I have seen this "bug" many times personally, but cannot seem to find any posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT include licence for Enterprize Manager (EM)... but any technician who does have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access Licence) does have Enterprize Manag
er and can connect and manage MSDE and SQL engines/servers equally well.
Consider http://support.microsoft.com/default...22&Product=sql Here we see substantiation that one "can" use EM and Maintenance Plans on MSDE, albeit that you had better be the latest Service Pack since the sqlmaint feature was over
looked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for Database Backup, Transaction Backup (and Log text files). This is important because unless you can also choose to do so, one will end up filling the hard disk with far too many SQL
dumps.
If connected to an SQL server... the option works fine. If connected to an MSDE, the option fails to provie the drop-down for days/weeks and the resulting job created has bugs in the command line options of the job step which one must then go and manuall
y tweak to be correct (never report a bug without a workaround eh? ;-P)
John,
As far as im aware this happens because the maintenance wizard
(sqlmaint.exe) is looking for a backupdirectory string valuein the MSDE
instance registry location.
(I would maybe do this on a test machine first if possible or make sure you
have backups)
So firstly make sure the following backup folder path exists , if not create
it :
c:\program files\microsoft sql server\<MSDE instance>\Backup.
Then in regedit:
HKLM\Software\Microsoft\Microsoft SQL Server\<MSDE instance>\MSSQLserver
there should be a BackupDirectory string value , the value data should be
the physical path to the backup folder in our case c:\program
files\microsoft sql server\<MSDE instance>\Backup.
HTH
Dylan
"John D. Sullivan" <John D. Sullivan@.discussions.microsoft.com> wrote in
message news:835E25B5-6EE5-4533-A1D5-43D3873BC0B1@.microsoft.com...
> I have seen this "bug" many times personally, but cannot seem to find any
posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
> Consider
http://support.microsoft.com/default...22&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
|||Thanks for the thought. No that's not what I mean (see my additional post
in next thread). About the backup folder here is what I did discover the
hard way..
When creating the Maintenance Plan...if one chooses "use the default backup
directory" then it seems to work, and the (first) backup will create the
folder path even if it did not yet exist. However if you specify a "use
this directory" to backup to... then I have found that folder you specify
had better exist already because the backup job will fail rather than create
it. So there's a little idiosyncracy for ya. (I have not experienced the
issue you mention, but perhaps that is an issue if the SQL is installed as a
"named" instance of SQL instead of the default/single instance of SQL? in
which case thank you for the additional tweaks)
John D. Sullivan
ABELSoft Corporation
"Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
news:OQXmdsjaEHA.3596@.tk2msftngp13.phx.gbl...
> John,
> As far as im aware this happens because the maintenance wizard
> (sqlmaint.exe) is looking for a backupdirectory string valuein the MSDE
> instance registry location.
> (I would maybe do this on a test machine first if possible or make sure
you
> have backups)
> So firstly make sure the following backup folder path exists , if not
create[vbcol=seagreen]
> it :
> c:\program files\microsoft sql server\<MSDE instance>\Backup.
> Then in regedit:
> HKLM\Software\Microsoft\Microsoft SQL Server\<MSDE instance>\MSSQLserver
> there should be a BackupDirectory string value , the value data should be
> the physical path to the backup folder in our case c:\program
> files\microsoft sql server\<MSDE instance>\Backup.
> HTH
> Dylan
>
>
> "John D. Sullivan" <John D. Sullivan@.discussions.microsoft.com> wrote in
> message news:835E25B5-6EE5-4533-A1D5-43D3873BC0B1@.microsoft.com...
any[vbcol=seagreen]
> posting on the Internet about it. I have many customers using MSDE
Enterprise[vbcol=seagreen]
> Manager when connecting to MSDE.
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> http://support.microsoft.com/default...22&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> an MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
>
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT include licence for Enterprize Manager (EM)... but any technician who does have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access Licence) does have Enterprize Manag
er and can connect and manage MSDE and SQL engines/servers equally well.
Consider http://support.microsoft.com/default...22&Product=sql Here we see substantiation that one "can" use EM and Maintenance Plans on MSDE, albeit that you had better be the latest Service Pack since the sqlmaint feature was over
looked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for Database Backup, Transaction Backup (and Log text files). This is important because unless you can also choose to do so, one will end up filling the hard disk with far too many SQL
dumps.
If connected to an SQL server... the option works fine. If connected to an MSDE, the option fails to provie the drop-down for days/weeks and the resulting job created has bugs in the command line options of the job step which one must then go and manuall
y tweak to be correct (never report a bug without a workaround eh? ;-P)
John,
As far as im aware this happens because the maintenance wizard
(sqlmaint.exe) is looking for a backupdirectory string valuein the MSDE
instance registry location.
(I would maybe do this on a test machine first if possible or make sure you
have backups)
So firstly make sure the following backup folder path exists , if not create
it :
c:\program files\microsoft sql server\<MSDE instance>\Backup.
Then in regedit:
HKLM\Software\Microsoft\Microsoft SQL Server\<MSDE instance>\MSSQLserver
there should be a BackupDirectory string value , the value data should be
the physical path to the backup folder in our case c:\program
files\microsoft sql server\<MSDE instance>\Backup.
HTH
Dylan
"John D. Sullivan" <John D. Sullivan@.discussions.microsoft.com> wrote in
message news:835E25B5-6EE5-4533-A1D5-43D3873BC0B1@.microsoft.com...
> I have seen this "bug" many times personally, but cannot seem to find any
posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
> Consider
http://support.microsoft.com/default...22&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
|||Thanks for the thought. No that's not what I mean (see my additional post
in next thread). About the backup folder here is what I did discover the
hard way..
When creating the Maintenance Plan...if one chooses "use the default backup
directory" then it seems to work, and the (first) backup will create the
folder path even if it did not yet exist. However if you specify a "use
this directory" to backup to... then I have found that folder you specify
had better exist already because the backup job will fail rather than create
it. So there's a little idiosyncracy for ya. (I have not experienced the
issue you mention, but perhaps that is an issue if the SQL is installed as a
"named" instance of SQL instead of the default/single instance of SQL? in
which case thank you for the additional tweaks)
John D. Sullivan
ABELSoft Corporation
"Dylan Kruger" <carmellobear1@.hotmail.com> wrote in message
news:OQXmdsjaEHA.3596@.tk2msftngp13.phx.gbl...
> John,
> As far as im aware this happens because the maintenance wizard
> (sqlmaint.exe) is looking for a backupdirectory string valuein the MSDE
> instance registry location.
> (I would maybe do this on a test machine first if possible or make sure
you
> have backups)
> So firstly make sure the following backup folder path exists , if not
create[vbcol=seagreen]
> it :
> c:\program files\microsoft sql server\<MSDE instance>\Backup.
> Then in regedit:
> HKLM\Software\Microsoft\Microsoft SQL Server\<MSDE instance>\MSSQLserver
> there should be a BackupDirectory string value , the value data should be
> the physical path to the backup folder in our case c:\program
> files\microsoft sql server\<MSDE instance>\Backup.
> HTH
> Dylan
>
>
> "John D. Sullivan" <John D. Sullivan@.discussions.microsoft.com> wrote in
> message news:835E25B5-6EE5-4533-A1D5-43D3873BC0B1@.microsoft.com...
any[vbcol=seagreen]
> posting on the Internet about it. I have many customers using MSDE
Enterprise[vbcol=seagreen]
> Manager when connecting to MSDE.
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> http://support.microsoft.com/default...22&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> an MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
>
Wednesday, March 7, 2012
Bug in Database Maintenance Plans Enterprise Manager and MSDE v SQL
I have seen this "bug" many times personally, but cannot seem to find any
posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
Consider
http://support.microsoft.com/default...22&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
If connected to an SQL server... the option works fine. If connected to an
MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
John D. Sullivan
ABELSoft Corporation
(email address munged)
This is not just an MSDE problem. We have had problems with out Enterprise
version not deleting backups. Never resolved it. Wrote scripts to delete
files.
Bob
SuccessWare Software
"John D. Sullivan" <noone@.nothing.com> wrote in message
news:uGWJDreaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/default...22&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>
|||Excellent information that is very relevant. Thank you Mark. It is very
useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
platform. While it is true that SQL 7 has no Database Maintenance Plan
branch under Management in the Enterprise Manager and therefore connecting
to an SQL 2k it is not possible to edit or delete a "plan" but only the
Job/steps... the problem I am citing is a bit different.
What I mean to say is that when creating a new Database Maintenance Plan
using the GUI Enterprise Manager (2000) that takes one through a multi-step
"wizard", it is possible to "check box" that you wish to "Remove files older
than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
service packs) is the engine/server the GUI of the Maintenance Plan Wizard
shows blanks for the qty/units of days/weeks to remove old files.
Workaround: if you go ahead and checkbox to remove old files, manually fill
in a number for qty (you cannot fill in units) and continue through the
wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
xp_sqlmaint (notice this is the extended stored procedure equivalent of
command prompt sqlmaint.exe) will have slight syntax errors in the argument
list. The resulting Job fails to execute. Obviously the -DelBkUps switch
will not have the correct <time value> after it... if you filled in 77 it
will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
job step and manually tweak the command line arguments until they are
correct, then it will work.
By the way, I find viewing the results of job and job steps pretty much
useless. You might see an error number you can lookup. One ends up copying
the entire command and pasting and running it as a query to find out exactly
where/why it is failing. Instead, I find it very useful to check the option
in the Maintenance Plan to write report to a text file..because the error
message(s) in there are far more detailed and useful.
John D. Sullivan
ABELSoft Corporation
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> John,
> Yep, this is a bug. Have a look at these articles:
> BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
> ME Computers
> http://support.microsoft.com/?id=278667
> BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
> http://support.microsoft.com/?id=247879
> FIX: SQLMaint.exe Sets Database Status Incorrectly
> http://support.microsoft.com/?id=276234
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> John D. Sullivan wrote:
any[vbcol=seagreen]
Enterprise[vbcol=seagreen]
does[vbcol=seagreen]
Access[vbcol=seagreen]
and[vbcol=seagreen]
http://support.microsoft.com/default...22&Product=sql[vbcol=seagreen]
on[vbcol=seagreen]
for[vbcol=seagreen]
important[vbcol=seagreen]
an[vbcol=seagreen]
step[vbcol=seagreen]
bug[vbcol=seagreen]
posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
Consider
http://support.microsoft.com/default...22&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
If connected to an SQL server... the option works fine. If connected to an
MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
John D. Sullivan
ABELSoft Corporation
(email address munged)
This is not just an MSDE problem. We have had problems with out Enterprise
version not deleting backups. Never resolved it. Wrote scripts to delete
files.
Bob
SuccessWare Software
"John D. Sullivan" <noone@.nothing.com> wrote in message
news:uGWJDreaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/default...22&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>
|||Excellent information that is very relevant. Thank you Mark. It is very
useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
platform. While it is true that SQL 7 has no Database Maintenance Plan
branch under Management in the Enterprise Manager and therefore connecting
to an SQL 2k it is not possible to edit or delete a "plan" but only the
Job/steps... the problem I am citing is a bit different.
What I mean to say is that when creating a new Database Maintenance Plan
using the GUI Enterprise Manager (2000) that takes one through a multi-step
"wizard", it is possible to "check box" that you wish to "Remove files older
than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
service packs) is the engine/server the GUI of the Maintenance Plan Wizard
shows blanks for the qty/units of days/weeks to remove old files.
Workaround: if you go ahead and checkbox to remove old files, manually fill
in a number for qty (you cannot fill in units) and continue through the
wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
xp_sqlmaint (notice this is the extended stored procedure equivalent of
command prompt sqlmaint.exe) will have slight syntax errors in the argument
list. The resulting Job fails to execute. Obviously the -DelBkUps switch
will not have the correct <time value> after it... if you filled in 77 it
will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
job step and manually tweak the command line arguments until they are
correct, then it will work.
By the way, I find viewing the results of job and job steps pretty much
useless. You might see an error number you can lookup. One ends up copying
the entire command and pasting and running it as a query to find out exactly
where/why it is failing. Instead, I find it very useful to check the option
in the Maintenance Plan to write report to a text file..because the error
message(s) in there are far more detailed and useful.
John D. Sullivan
ABELSoft Corporation
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> John,
> Yep, this is a bug. Have a look at these articles:
> BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
> ME Computers
> http://support.microsoft.com/?id=278667
> BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
> http://support.microsoft.com/?id=247879
> FIX: SQLMaint.exe Sets Database Status Incorrectly
> http://support.microsoft.com/?id=276234
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> John D. Sullivan wrote:
any[vbcol=seagreen]
Enterprise[vbcol=seagreen]
does[vbcol=seagreen]
Access[vbcol=seagreen]
and[vbcol=seagreen]
http://support.microsoft.com/default...22&Product=sql[vbcol=seagreen]
on[vbcol=seagreen]
for[vbcol=seagreen]
important[vbcol=seagreen]
an[vbcol=seagreen]
step[vbcol=seagreen]
bug[vbcol=seagreen]
Bug in Database Maintenance Plans Enterprise Manager and MSDE v SQL
I have seen this "bug" many times personally, but cannot seem to find any
posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
Consider
http://support.microsoft.com/default.aspx?scid=kb;en-us;295022&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
If connected to an SQL server... the option works fine. If connected to an
MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
John D. Sullivan
ABELSoft Corporation
(email address munged)This is not just an MSDE problem. We have had problems with out Enterprise
version not deleting backups. Never resolved it. Wrote scripts to delete
files.
Bob
SuccessWare Software
"John D. Sullivan" <noone@.nothing.com> wrote in message
news:uGWJDreaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/default.aspx?scid=kb;en-us;295022&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>|||John,
Yep, this is a bug. Have a look at these articles:
BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
ME Computers
http://support.microsoft.com/?id=278667
BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
http://support.microsoft.com/?id=247879
FIX: SQLMaint.exe Sets Database Status Incorrectly
http://support.microsoft.com/?id=276234
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
John D. Sullivan wrote:
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/default.aspx?scid=kb;en-us;295022&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>|||Excellent information that is very relevant. Thank you Mark. It is very
useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
platform. While it is true that SQL 7 has no Database Maintenance Plan
branch under Management in the Enterprise Manager and therefore connecting
to an SQL 2k it is not possible to edit or delete a "plan" but only the
Job/steps... the problem I am citing is a bit different.
What I mean to say is that when creating a new Database Maintenance Plan
using the GUI Enterprise Manager (2000) that takes one through a multi-step
"wizard", it is possible to "check box" that you wish to "Remove files older
than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
service packs) is the engine/server the GUI of the Maintenance Plan Wizard
shows blanks for the qty/units of days/weeks to remove old files.
Workaround: if you go ahead and checkbox to remove old files, manually fill
in a number for qty (you cannot fill in units) and continue through the
wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
xp_sqlmaint (notice this is the extended stored procedure equivalent of
command prompt sqlmaint.exe) will have slight syntax errors in the argument
list. The resulting Job fails to execute. Obviously the -DelBkUps switch
will not have the correct <time value> after it... if you filled in 77 it
will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
job step and manually tweak the command line arguments until they are
correct, then it will work.
By the way, I find viewing the results of job and job steps pretty much
useless. You might see an error number you can lookup. One ends up copying
the entire command and pasting and running it as a query to find out exactly
where/why it is failing. Instead, I find it very useful to check the option
in the Maintenance Plan to write report to a text file..because the error
message(s) in there are far more detailed and useful.
John D. Sullivan
ABELSoft Corporation
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...
> John,
> Yep, this is a bug. Have a look at these articles:
> BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
> ME Computers
> http://support.microsoft.com/?id=278667
> BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
> http://support.microsoft.com/?id=247879
> FIX: SQLMaint.exe Sets Database Status Incorrectly
> http://support.microsoft.com/?id=276234
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> John D. Sullivan wrote:
> > I have seen this "bug" many times personally, but cannot seem to find
any
> > posting on the Internet about it. I have many customers using MSDE
> >
> > The bug is with the Database Maintenance Plans of Microsoft SQL
Enterprise
> > Manager when connecting to MSDE.
> >
> > Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> > include licence for Enterprize Manager (EM)... but any technician who
does
> > have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client
Access
> > Licence) does have Enterprize Manager and can connect and manage MSDE
and
> > SQL engines/servers equally well.
> >
> > Consider
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;295022&Product=sql
> > Here we see substantiation that one "can" use EM and Maintenance Plans
on
> > MSDE, albeit that you had better be the latest Service Pack since the
> > sqlmaint feature was overlooked in the original release to market.
> >
> > The bug I am reporting is with the "Remove after X Weeks/Days" option
for
> > Database Backup, Transaction Backup (and Log text files). This is
important
> > because unless you can also choose to do so, one will end up filling the
> > hard disk with far too many SQL dumps.
> >
> > If connected to an SQL server... the option works fine. If connected to
an
> > MSDE, the option fails to provie the drop-down for days/weeks and the
> > resulting job created has bugs in the command line options of the job
step
> > which one must then go and manually tweak to be correct (never report a
bug
> > without a workaround eh? ;-P)
> >
> > John D. Sullivan
> > ABELSoft Corporation
> > (email address munged)
> >
> >|||John,
Yep it's annoying. I try not to use maintenance plans for my routine
tasks as I like to have the flexibility of creating my own maintenance
jobs. This may be a workaround you might wish to consider.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
John D. Sullivan wrote:
> Excellent information that is very relevant. Thank you Mark. It is very
> useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
> platform. While it is true that SQL 7 has no Database Maintenance Plan
> branch under Management in the Enterprise Manager and therefore connecting
> to an SQL 2k it is not possible to edit or delete a "plan" but only the
> Job/steps... the problem I am citing is a bit different.
> What I mean to say is that when creating a new Database Maintenance Plan
> using the GUI Enterprise Manager (2000) that takes one through a multi-step
> "wizard", it is possible to "check box" that you wish to "Remove files older
> than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
> manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
> service packs) is the engine/server the GUI of the Maintenance Plan Wizard
> shows blanks for the qty/units of days/weeks to remove old files.
> Workaround: if you go ahead and checkbox to remove old files, manually fill
> in a number for qty (you cannot fill in units) and continue through the
> wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
> xp_sqlmaint (notice this is the extended stored procedure equivalent of
> command prompt sqlmaint.exe) will have slight syntax errors in the argument
> list. The resulting Job fails to execute. Obviously the -DelBkUps switch
> will not have the correct <time value> after it... if you filled in 77 it
> will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
> job step and manually tweak the command line arguments until they are
> correct, then it will work.
> By the way, I find viewing the results of job and job steps pretty much
> useless. You might see an error number you can lookup. One ends up copying
> the entire command and pasting and running it as a query to find out exactly
> where/why it is failing. Instead, I find it very useful to check the option
> in the Maintenance Plan to write report to a text file..because the error
> message(s) in there are far more detailed and useful.
> John D. Sullivan
> ABELSoft Corporation
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...
>>John,
>>Yep, this is a bug. Have a look at these articles:
>>BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
>>ME Computers
>>http://support.microsoft.com/?id=278667
>>BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
>>http://support.microsoft.com/?id=247879
>>FIX: SQLMaint.exe Sets Database Status Incorrectly
>>http://support.microsoft.com/?id=276234
>>
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>John D. Sullivan wrote:
>>I have seen this "bug" many times personally, but cannot seem to find
> any
>>posting on the Internet about it. I have many customers using MSDE
>>The bug is with the Database Maintenance Plans of Microsoft SQL
> Enterprise
>>Manager when connecting to MSDE.
>>Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
>>include licence for Enterprize Manager (EM)... but any technician who
> does
>>have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client
> Access
>>Licence) does have Enterprize Manager and can connect and manage MSDE
> and
>>SQL engines/servers equally well.
>>Consider
> http://support.microsoft.com/default.aspx?scid=kb;en-us;295022&Product=sql
>>Here we see substantiation that one "can" use EM and Maintenance Plans
> on
>>MSDE, albeit that you had better be the latest Service Pack since the
>>sqlmaint feature was overlooked in the original release to market.
>>The bug I am reporting is with the "Remove after X Weeks/Days" option
> for
>>Database Backup, Transaction Backup (and Log text files). This is
> important
>>because unless you can also choose to do so, one will end up filling the
>>hard disk with far too many SQL dumps.
>>If connected to an SQL server... the option works fine. If connected to
> an
>>MSDE, the option fails to provie the drop-down for days/weeks and the
>>resulting job created has bugs in the command line options of the job
> step
>>which one must then go and manually tweak to be correct (never report a
> bug
>>without a workaround eh? ;-P)
>>John D. Sullivan
>>ABELSoft Corporation
>>(email address munged)
>>
>
>
>
posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
Consider
http://support.microsoft.com/default.aspx?scid=kb;en-us;295022&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
If connected to an SQL server... the option works fine. If connected to an
MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
John D. Sullivan
ABELSoft Corporation
(email address munged)This is not just an MSDE problem. We have had problems with out Enterprise
version not deleting backups. Never resolved it. Wrote scripts to delete
files.
Bob
SuccessWare Software
"John D. Sullivan" <noone@.nothing.com> wrote in message
news:uGWJDreaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/default.aspx?scid=kb;en-us;295022&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>|||John,
Yep, this is a bug. Have a look at these articles:
BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
ME Computers
http://support.microsoft.com/?id=278667
BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
http://support.microsoft.com/?id=247879
FIX: SQLMaint.exe Sets Database Status Incorrectly
http://support.microsoft.com/?id=276234
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
John D. Sullivan wrote:
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/default.aspx?scid=kb;en-us;295022&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>|||Excellent information that is very relevant. Thank you Mark. It is very
useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
platform. While it is true that SQL 7 has no Database Maintenance Plan
branch under Management in the Enterprise Manager and therefore connecting
to an SQL 2k it is not possible to edit or delete a "plan" but only the
Job/steps... the problem I am citing is a bit different.
What I mean to say is that when creating a new Database Maintenance Plan
using the GUI Enterprise Manager (2000) that takes one through a multi-step
"wizard", it is possible to "check box" that you wish to "Remove files older
than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
service packs) is the engine/server the GUI of the Maintenance Plan Wizard
shows blanks for the qty/units of days/weeks to remove old files.
Workaround: if you go ahead and checkbox to remove old files, manually fill
in a number for qty (you cannot fill in units) and continue through the
wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
xp_sqlmaint (notice this is the extended stored procedure equivalent of
command prompt sqlmaint.exe) will have slight syntax errors in the argument
list. The resulting Job fails to execute. Obviously the -DelBkUps switch
will not have the correct <time value> after it... if you filled in 77 it
will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
job step and manually tweak the command line arguments until they are
correct, then it will work.
By the way, I find viewing the results of job and job steps pretty much
useless. You might see an error number you can lookup. One ends up copying
the entire command and pasting and running it as a query to find out exactly
where/why it is failing. Instead, I find it very useful to check the option
in the Maintenance Plan to write report to a text file..because the error
message(s) in there are far more detailed and useful.
John D. Sullivan
ABELSoft Corporation
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...
> John,
> Yep, this is a bug. Have a look at these articles:
> BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
> ME Computers
> http://support.microsoft.com/?id=278667
> BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
> http://support.microsoft.com/?id=247879
> FIX: SQLMaint.exe Sets Database Status Incorrectly
> http://support.microsoft.com/?id=276234
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> John D. Sullivan wrote:
> > I have seen this "bug" many times personally, but cannot seem to find
any
> > posting on the Internet about it. I have many customers using MSDE
> >
> > The bug is with the Database Maintenance Plans of Microsoft SQL
Enterprise
> > Manager when connecting to MSDE.
> >
> > Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> > include licence for Enterprize Manager (EM)... but any technician who
does
> > have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client
Access
> > Licence) does have Enterprize Manager and can connect and manage MSDE
and
> > SQL engines/servers equally well.
> >
> > Consider
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;295022&Product=sql
> > Here we see substantiation that one "can" use EM and Maintenance Plans
on
> > MSDE, albeit that you had better be the latest Service Pack since the
> > sqlmaint feature was overlooked in the original release to market.
> >
> > The bug I am reporting is with the "Remove after X Weeks/Days" option
for
> > Database Backup, Transaction Backup (and Log text files). This is
important
> > because unless you can also choose to do so, one will end up filling the
> > hard disk with far too many SQL dumps.
> >
> > If connected to an SQL server... the option works fine. If connected to
an
> > MSDE, the option fails to provie the drop-down for days/weeks and the
> > resulting job created has bugs in the command line options of the job
step
> > which one must then go and manually tweak to be correct (never report a
bug
> > without a workaround eh? ;-P)
> >
> > John D. Sullivan
> > ABELSoft Corporation
> > (email address munged)
> >
> >|||John,
Yep it's annoying. I try not to use maintenance plans for my routine
tasks as I like to have the flexibility of creating my own maintenance
jobs. This may be a workaround you might wish to consider.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
John D. Sullivan wrote:
> Excellent information that is very relevant. Thank you Mark. It is very
> useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
> platform. While it is true that SQL 7 has no Database Maintenance Plan
> branch under Management in the Enterprise Manager and therefore connecting
> to an SQL 2k it is not possible to edit or delete a "plan" but only the
> Job/steps... the problem I am citing is a bit different.
> What I mean to say is that when creating a new Database Maintenance Plan
> using the GUI Enterprise Manager (2000) that takes one through a multi-step
> "wizard", it is possible to "check box" that you wish to "Remove files older
> than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
> manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
> service packs) is the engine/server the GUI of the Maintenance Plan Wizard
> shows blanks for the qty/units of days/weeks to remove old files.
> Workaround: if you go ahead and checkbox to remove old files, manually fill
> in a number for qty (you cannot fill in units) and continue through the
> wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
> xp_sqlmaint (notice this is the extended stored procedure equivalent of
> command prompt sqlmaint.exe) will have slight syntax errors in the argument
> list. The resulting Job fails to execute. Obviously the -DelBkUps switch
> will not have the correct <time value> after it... if you filled in 77 it
> will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
> job step and manually tweak the command line arguments until they are
> correct, then it will work.
> By the way, I find viewing the results of job and job steps pretty much
> useless. You might see an error number you can lookup. One ends up copying
> the entire command and pasting and running it as a query to find out exactly
> where/why it is failing. Instead, I find it very useful to check the option
> in the Maintenance Plan to write report to a text file..because the error
> message(s) in there are far more detailed and useful.
> John D. Sullivan
> ABELSoft Corporation
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...
>>John,
>>Yep, this is a bug. Have a look at these articles:
>>BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
>>ME Computers
>>http://support.microsoft.com/?id=278667
>>BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
>>http://support.microsoft.com/?id=247879
>>FIX: SQLMaint.exe Sets Database Status Incorrectly
>>http://support.microsoft.com/?id=276234
>>
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>John D. Sullivan wrote:
>>I have seen this "bug" many times personally, but cannot seem to find
> any
>>posting on the Internet about it. I have many customers using MSDE
>>The bug is with the Database Maintenance Plans of Microsoft SQL
> Enterprise
>>Manager when connecting to MSDE.
>>Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
>>include licence for Enterprize Manager (EM)... but any technician who
> does
>>have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client
> Access
>>Licence) does have Enterprize Manager and can connect and manage MSDE
> and
>>SQL engines/servers equally well.
>>Consider
> http://support.microsoft.com/default.aspx?scid=kb;en-us;295022&Product=sql
>>Here we see substantiation that one "can" use EM and Maintenance Plans
> on
>>MSDE, albeit that you had better be the latest Service Pack since the
>>sqlmaint feature was overlooked in the original release to market.
>>The bug I am reporting is with the "Remove after X Weeks/Days" option
> for
>>Database Backup, Transaction Backup (and Log text files). This is
> important
>>because unless you can also choose to do so, one will end up filling the
>>hard disk with far too many SQL dumps.
>>If connected to an SQL server... the option works fine. If connected to
> an
>>MSDE, the option fails to provie the drop-down for days/weeks and the
>>resulting job created has bugs in the command line options of the job
> step
>>which one must then go and manually tweak to be correct (never report a
> bug
>>without a workaround eh? ;-P)
>>John D. Sullivan
>>ABELSoft Corporation
>>(email address munged)
>>
>
>
>
Bug in Database Maintenance Plans Enterprise Manager and MSDE v SQL
I have seen this "bug" many times personally, but cannot seem to find any
posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
Consider
http://support.microsoft.com/default...22&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
If connected to an SQL server... the option works fine. If connected to an
MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
John D. Sullivan
ABELSoft Corporation
(email address munged)
This is not just an MSDE problem. We have had problems with out Enterprise
version not deleting backups. Never resolved it. Wrote scripts to delete
files.
Bob
SuccessWare Software
"John D. Sullivan" <noone@.nothing.com> wrote in message
news:uGWJDreaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/default...22&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>
|||Excellent information that is very relevant. Thank you Mark. It is very
useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
platform. While it is true that SQL 7 has no Database Maintenance Plan
branch under Management in the Enterprise Manager and therefore connecting
to an SQL 2k it is not possible to edit or delete a "plan" but only the
Job/steps... the problem I am citing is a bit different.
What I mean to say is that when creating a new Database Maintenance Plan
using the GUI Enterprise Manager (2000) that takes one through a multi-step
"wizard", it is possible to "check box" that you wish to "Remove files older
than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
service packs) is the engine/server the GUI of the Maintenance Plan Wizard
shows blanks for the qty/units of days/weeks to remove old files.
Workaround: if you go ahead and checkbox to remove old files, manually fill
in a number for qty (you cannot fill in units) and continue through the
wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
xp_sqlmaint (notice this is the extended stored procedure equivalent of
command prompt sqlmaint.exe) will have slight syntax errors in the argument
list. The resulting Job fails to execute. Obviously the -DelBkUps switch
will not have the correct <time value> after it... if you filled in 77 it
will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
job step and manually tweak the command line arguments until they are
correct, then it will work.
By the way, I find viewing the results of job and job steps pretty much
useless. You might see an error number you can lookup. One ends up copying
the entire command and pasting and running it as a query to find out exactly
where/why it is failing. Instead, I find it very useful to check the option
in the Maintenance Plan to write report to a text file..because the error
message(s) in there are far more detailed and useful.
John D. Sullivan
ABELSoft Corporation
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> John,
> Yep, this is a bug. Have a look at these articles:
> BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
> ME Computers
> http://support.microsoft.com/?id=278667
> BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
> http://support.microsoft.com/?id=247879
> FIX: SQLMaint.exe Sets Database Status Incorrectly
> http://support.microsoft.com/?id=276234
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> John D. Sullivan wrote:
any[vbcol=seagreen]
Enterprise[vbcol=seagreen]
does[vbcol=seagreen]
Access[vbcol=seagreen]
and[vbcol=seagreen]
http://support.microsoft.com/default...22&Product=sql[vbcol=seagreen]
on[vbcol=seagreen]
for[vbcol=seagreen]
important[vbcol=seagreen]
an[vbcol=seagreen]
step[vbcol=seagreen]
bug[vbcol=seagreen]
posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
Consider
http://support.microsoft.com/default...22&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
If connected to an SQL server... the option works fine. If connected to an
MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
John D. Sullivan
ABELSoft Corporation
(email address munged)
This is not just an MSDE problem. We have had problems with out Enterprise
version not deleting backups. Never resolved it. Wrote scripts to delete
files.
Bob
SuccessWare Software
"John D. Sullivan" <noone@.nothing.com> wrote in message
news:uGWJDreaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/default...22&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>
|||Excellent information that is very relevant. Thank you Mark. It is very
useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
platform. While it is true that SQL 7 has no Database Maintenance Plan
branch under Management in the Enterprise Manager and therefore connecting
to an SQL 2k it is not possible to edit or delete a "plan" but only the
Job/steps... the problem I am citing is a bit different.
What I mean to say is that when creating a new Database Maintenance Plan
using the GUI Enterprise Manager (2000) that takes one through a multi-step
"wizard", it is possible to "check box" that you wish to "Remove files older
than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
service packs) is the engine/server the GUI of the Maintenance Plan Wizard
shows blanks for the qty/units of days/weeks to remove old files.
Workaround: if you go ahead and checkbox to remove old files, manually fill
in a number for qty (you cannot fill in units) and continue through the
wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
xp_sqlmaint (notice this is the extended stored procedure equivalent of
command prompt sqlmaint.exe) will have slight syntax errors in the argument
list. The resulting Job fails to execute. Obviously the -DelBkUps switch
will not have the correct <time value> after it... if you filled in 77 it
will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
job step and manually tweak the command line arguments until they are
correct, then it will work.
By the way, I find viewing the results of job and job steps pretty much
useless. You might see an error number you can lookup. One ends up copying
the entire command and pasting and running it as a query to find out exactly
where/why it is failing. Instead, I find it very useful to check the option
in the Maintenance Plan to write report to a text file..because the error
message(s) in there are far more detailed and useful.
John D. Sullivan
ABELSoft Corporation
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> John,
> Yep, this is a bug. Have a look at these articles:
> BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
> ME Computers
> http://support.microsoft.com/?id=278667
> BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
> http://support.microsoft.com/?id=247879
> FIX: SQLMaint.exe Sets Database Status Incorrectly
> http://support.microsoft.com/?id=276234
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> John D. Sullivan wrote:
any[vbcol=seagreen]
Enterprise[vbcol=seagreen]
does[vbcol=seagreen]
Access[vbcol=seagreen]
and[vbcol=seagreen]
http://support.microsoft.com/default...22&Product=sql[vbcol=seagreen]
on[vbcol=seagreen]
for[vbcol=seagreen]
important[vbcol=seagreen]
an[vbcol=seagreen]
step[vbcol=seagreen]
bug[vbcol=seagreen]
Bug in Database Maintenance Plans Enterprise Manager and MSDE v SQL
I have seen this "bug" many times personally, but cannot seem to find any
posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
Consider
http://support.microsoft.com/default...22&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
If connected to an SQL server... the option works fine. If connected to an
MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
John D. Sullivan
ABELSoft Corporation
(email address munged)
This is not just an MSDE problem. We have had problems with out Enterprise
version not deleting backups. Never resolved it. Wrote scripts to delete
files.
Bob
SuccessWare Software
"John D. Sullivan" <noone@.nothing.com> wrote in message
news:uGWJDreaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/default...22&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>
|||Excellent information that is very relevant. Thank you Mark. It is very
useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
platform. While it is true that SQL 7 has no Database Maintenance Plan
branch under Management in the Enterprise Manager and therefore connecting
to an SQL 2k it is not possible to edit or delete a "plan" but only the
Job/steps... the problem I am citing is a bit different.
What I mean to say is that when creating a new Database Maintenance Plan
using the GUI Enterprise Manager (2000) that takes one through a multi-step
"wizard", it is possible to "check box" that you wish to "Remove files older
than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
service packs) is the engine/server the GUI of the Maintenance Plan Wizard
shows blanks for the qty/units of days/weeks to remove old files.
Workaround: if you go ahead and checkbox to remove old files, manually fill
in a number for qty (you cannot fill in units) and continue through the
wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
xp_sqlmaint (notice this is the extended stored procedure equivalent of
command prompt sqlmaint.exe) will have slight syntax errors in the argument
list. The resulting Job fails to execute. Obviously the -DelBkUps switch
will not have the correct <time value> after it... if you filled in 77 it
will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
job step and manually tweak the command line arguments until they are
correct, then it will work.
By the way, I find viewing the results of job and job steps pretty much
useless. You might see an error number you can lookup. One ends up copying
the entire command and pasting and running it as a query to find out exactly
where/why it is failing. Instead, I find it very useful to check the option
in the Maintenance Plan to write report to a text file..because the error
message(s) in there are far more detailed and useful.
John D. Sullivan
ABELSoft Corporation
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> John,
> Yep, this is a bug. Have a look at these articles:
> BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
> ME Computers
> http://support.microsoft.com/?id=278667
> BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
> http://support.microsoft.com/?id=247879
> FIX: SQLMaint.exe Sets Database Status Incorrectly
> http://support.microsoft.com/?id=276234
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> John D. Sullivan wrote:
any[vbcol=seagreen]
Enterprise[vbcol=seagreen]
does[vbcol=seagreen]
Access[vbcol=seagreen]
and[vbcol=seagreen]
http://support.microsoft.com/default...22&Product=sql[vbcol=seagreen]
on[vbcol=seagreen]
for[vbcol=seagreen]
important[vbcol=seagreen]
an[vbcol=seagreen]
step[vbcol=seagreen]
bug[vbcol=seagreen]
posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
Consider
http://support.microsoft.com/default...22&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
If connected to an SQL server... the option works fine. If connected to an
MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
John D. Sullivan
ABELSoft Corporation
(email address munged)
This is not just an MSDE problem. We have had problems with out Enterprise
version not deleting backups. Never resolved it. Wrote scripts to delete
files.
Bob
SuccessWare Software
"John D. Sullivan" <noone@.nothing.com> wrote in message
news:uGWJDreaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/default...22&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>
|||Excellent information that is very relevant. Thank you Mark. It is very
useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
platform. While it is true that SQL 7 has no Database Maintenance Plan
branch under Management in the Enterprise Manager and therefore connecting
to an SQL 2k it is not possible to edit or delete a "plan" but only the
Job/steps... the problem I am citing is a bit different.
What I mean to say is that when creating a new Database Maintenance Plan
using the GUI Enterprise Manager (2000) that takes one through a multi-step
"wizard", it is possible to "check box" that you wish to "Remove files older
than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
service packs) is the engine/server the GUI of the Maintenance Plan Wizard
shows blanks for the qty/units of days/weeks to remove old files.
Workaround: if you go ahead and checkbox to remove old files, manually fill
in a number for qty (you cannot fill in units) and continue through the
wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
xp_sqlmaint (notice this is the extended stored procedure equivalent of
command prompt sqlmaint.exe) will have slight syntax errors in the argument
list. The resulting Job fails to execute. Obviously the -DelBkUps switch
will not have the correct <time value> after it... if you filled in 77 it
will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
job step and manually tweak the command line arguments until they are
correct, then it will work.
By the way, I find viewing the results of job and job steps pretty much
useless. You might see an error number you can lookup. One ends up copying
the entire command and pasting and running it as a query to find out exactly
where/why it is failing. Instead, I find it very useful to check the option
in the Maintenance Plan to write report to a text file..because the error
message(s) in there are far more detailed and useful.
John D. Sullivan
ABELSoft Corporation
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> John,
> Yep, this is a bug. Have a look at these articles:
> BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
> ME Computers
> http://support.microsoft.com/?id=278667
> BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
> http://support.microsoft.com/?id=247879
> FIX: SQLMaint.exe Sets Database Status Incorrectly
> http://support.microsoft.com/?id=276234
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> John D. Sullivan wrote:
any[vbcol=seagreen]
Enterprise[vbcol=seagreen]
does[vbcol=seagreen]
Access[vbcol=seagreen]
and[vbcol=seagreen]
http://support.microsoft.com/default...22&Product=sql[vbcol=seagreen]
on[vbcol=seagreen]
for[vbcol=seagreen]
important[vbcol=seagreen]
an[vbcol=seagreen]
step[vbcol=seagreen]
bug[vbcol=seagreen]
Bug in Database Maintenance Plans Enterprise Manager and MSDE v SQL
I have seen this "bug" many times personally, but cannot seem to find any
posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
Consider
http://support.microsoft.com/defaul...022&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
If connected to an SQL server... the option works fine. If connected to an
MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
John D. Sullivan
ABELSoft Corporation
(email address munged)This is not just an MSDE problem. We have had problems with out Enterprise
version not deleting backups. Never resolved it. Wrote scripts to delete
files.
Bob
SuccessWare Software
"John D. Sullivan" <noone@.nothing.com> wrote in message
news:uGWJDreaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/defaul...022&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>|||Excellent information that is very relevant. Thank you Mark. It is very
useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
platform. While it is true that SQL 7 has no Database Maintenance Plan
branch under Management in the Enterprise Manager and therefore connecting
to an SQL 2k it is not possible to edit or delete a "plan" but only the
Job/steps... the problem I am citing is a bit different.
What I mean to say is that when creating a new Database Maintenance Plan
using the GUI Enterprise Manager (2000) that takes one through a multi-step
"wizard", it is possible to "check box" that you wish to "Remove files older
than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
service packs) is the engine/server the GUI of the Maintenance Plan Wizard
shows blanks for the qty/units of days/weeks to remove old files.
Workaround: if you go ahead and checkbox to remove old files, manually fill
in a number for qty (you cannot fill in units) and continue through the
wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
xp_sqlmaint (notice this is the extended stored procedure equivalent of
command prompt sqlmaint.exe) will have slight syntax errors in the argument
list. The resulting Job fails to execute. Obviously the -DelBkUps switch
will not have the correct <time value> after it... if you filled in 77 it
will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
job step and manually tweak the command line arguments until they are
correct, then it will work.
By the way, I find viewing the results of job and job steps pretty much
useless. You might see an error number you can lookup. One ends up copying
the entire command and pasting and running it as a query to find out exactly
where/why it is failing. Instead, I find it very useful to check the option
in the Maintenance Plan to write report to a text file..because the error
message(s) in there are far more detailed and useful.
John D. Sullivan
ABELSoft Corporation
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> John,
> Yep, this is a bug. Have a look at these articles:
> BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
> ME Computers
> http://support.microsoft.com/?id=278667
> BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
> http://support.microsoft.com/?id=247879
> FIX: SQLMaint.exe Sets Database Status Incorrectly
> http://support.microsoft.com/?id=276234
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> John D. Sullivan wrote:
any[vbcol=seagreen]
Enterprise[vbcol=seagreen]
does[vbcol=seagreen]
Access[vbcol=seagreen]
and[vbcol=seagreen]
http://support.microsoft.com/defaul...022&Product=sql[vbcol=seagreen]
on[vbcol=seagreen]
for[vbcol=seagreen]
important[vbcol=seagreen]
an[vbcol=seagreen]
step[vbcol=seagreen]
bug[vbcol=seagreen]
posting on the Internet about it. I have many customers using MSDE
The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
Manager when connecting to MSDE.
Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
include licence for Enterprize Manager (EM)... but any technician who does
have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
Licence) does have Enterprize Manager and can connect and manage MSDE and
SQL engines/servers equally well.
Consider
http://support.microsoft.com/defaul...022&Product=sql
Here we see substantiation that one "can" use EM and Maintenance Plans on
MSDE, albeit that you had better be the latest Service Pack since the
sqlmaint feature was overlooked in the original release to market.
The bug I am reporting is with the "Remove after X Weeks/Days" option for
Database Backup, Transaction Backup (and Log text files). This is important
because unless you can also choose to do so, one will end up filling the
hard disk with far too many SQL dumps.
If connected to an SQL server... the option works fine. If connected to an
MSDE, the option fails to provie the drop-down for days/weeks and the
resulting job created has bugs in the command line options of the job step
which one must then go and manually tweak to be correct (never report a bug
without a workaround eh? ;-P)
John D. Sullivan
ABELSoft Corporation
(email address munged)This is not just an MSDE problem. We have had problems with out Enterprise
version not deleting backups. Never resolved it. Wrote scripts to delete
files.
Bob
SuccessWare Software
"John D. Sullivan" <noone@.nothing.com> wrote in message
news:uGWJDreaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> I have seen this "bug" many times personally, but cannot seem to find any
> posting on the Internet about it. I have many customers using MSDE
> The bug is with the Database Maintenance Plans of Microsoft SQL Enterprise
> Manager when connecting to MSDE.
> Yes, yes, I realize that MSDE (Microsoft SQL Desktop Edition) does NOT
> include licence for Enterprize Manager (EM)... but any technician who does
> have a licenced copy of SQL (Standard, Enterprize etc) CAL (Client Access
> Licence) does have Enterprize Manager and can connect and manage MSDE and
> SQL engines/servers equally well.
> Consider
> http://support.microsoft.com/defaul...022&Product=sql
> Here we see substantiation that one "can" use EM and Maintenance Plans on
> MSDE, albeit that you had better be the latest Service Pack since the
> sqlmaint feature was overlooked in the original release to market.
> The bug I am reporting is with the "Remove after X Weeks/Days" option for
> Database Backup, Transaction Backup (and Log text files). This is
important
> because unless you can also choose to do so, one will end up filling the
> hard disk with far too many SQL dumps.
> If connected to an SQL server... the option works fine. If connected to
an
> MSDE, the option fails to provie the drop-down for days/weeks and the
> resulting job created has bugs in the command line options of the job step
> which one must then go and manually tweak to be correct (never report a
bug
> without a workaround eh? ;-P)
> John D. Sullivan
> ABELSoft Corporation
> (email address munged)
>|||Excellent information that is very relevant. Thank you Mark. It is very
useful to know that the sqlmaint.exe tool fails to delete the backups on 9x
platform. While it is true that SQL 7 has no Database Maintenance Plan
branch under Management in the Enterprise Manager and therefore connecting
to an SQL 2k it is not possible to edit or delete a "plan" but only the
Job/steps... the problem I am citing is a bit different.
What I mean to say is that when creating a new Database Maintenance Plan
using the GUI Enterprise Manager (2000) that takes one through a multi-step
"wizard", it is possible to "check box" that you wish to "Remove files older
than" but the boxes for quantity and units (e.g. 4, Weeks) are fine if
manageing an SQL 2000 edition other than MSDE but when MSDE 2000 (all
service packs) is the engine/server the GUI of the Maintenance Plan Wizard
shows blanks for the qty/units of days/weeks to remove old files.
Workaround: if you go ahead and checkbox to remove old files, manually fill
in a number for qty (you cannot fill in units) and continue through the
wizard it WILL create the Job/step(s)... however the job step that EXECUTEs
xp_sqlmaint (notice this is the extended stored procedure equivalent of
command prompt sqlmaint.exe) will have slight syntax errors in the argument
list. The resulting Job fails to execute. Obviously the -DelBkUps switch
will not have the correct <time value> after it... if you filled in 77 it
will say 77 but has no WEEKS or DAYS or what have you. One has to edit the
job step and manually tweak the command line arguments until they are
correct, then it will work.
By the way, I find viewing the results of job and job steps pretty much
useless. You might see an error number you can lookup. One ends up copying
the entire command and pasting and running it as a query to find out exactly
where/why it is failing. Instead, I find it very useful to check the option
in the Maintenance Plan to write report to a text file..because the error
message(s) in there are far more detailed and useful.
John D. Sullivan
ABELSoft Corporation
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OAZ539laEHA.2908@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> John,
> Yep, this is a bug. Have a look at these articles:
> BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or
> ME Computers
> http://support.microsoft.com/?id=278667
> BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation
> http://support.microsoft.com/?id=247879
> FIX: SQLMaint.exe Sets Database Status Incorrectly
> http://support.microsoft.com/?id=276234
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> John D. Sullivan wrote:
any[vbcol=seagreen]
Enterprise[vbcol=seagreen]
does[vbcol=seagreen]
Access[vbcol=seagreen]
and[vbcol=seagreen]
http://support.microsoft.com/defaul...022&Product=sql[vbcol=seagreen]
on[vbcol=seagreen]
for[vbcol=seagreen]
important[vbcol=seagreen]
an[vbcol=seagreen]
step[vbcol=seagreen]
bug[vbcol=seagreen]
Sunday, February 19, 2012
Broken link in e-mail subscription
I have scheduled the first report at this customers site to send out e-mails
of reports. It is sending out the report just fine and including the PDF
file that I requested however I also checked the Include Link box in the
schedule because of the requirements of the users wanting to hide details in
the e-mailed report and wanting to link to the report and then drill down to
see the details only when necessary.
When the e-mail is sent it doesn't formulate the URL correctly and says the
following:
The report is accessible at the following address:
http://localhost/reports?%2fAccounting%.........
The closest thing I've found online to resolve this was this link:
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad125641/ReadmeSQL2005.htm
-- See "Incomplete Report Server Configuration on an SSL-Protected Server
Causes Broken Report Links in Report Server E-Mail Notifications" section.
Unfortunately, an examination of the suggestion revealed that we are not
using SSL and when I checked the <UrlRoot> in the RSReportServer.config file
it was set correctly to the server name that I'd want used in replacing
localhost in the URL.
Does anyone know how to fix this?You'll actually need to modify the rswebapplication.config file for that
setting.
The section should look like the following to get your issue resolved:
<ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> I have scheduled the first report at this customers site to send out
e-mails
> of reports. It is sending out the report just fine and including the PDF
> file that I requested however I also checked the Include Link box in the
> schedule because of the requirements of the users wanting to hide details
in
> the e-mailed report and wanting to link to the report and then drill down
to
> see the details only when necessary.
> When the e-mail is sent it doesn't formulate the URL correctly and says
the
> following:
> The report is accessible at the following address:
> http://localhost/reports?%2fAccounting%.........
> The closest thing I've found online to resolve this was this link:
>
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
25641/ReadmeSQL2005.htm
> -- See "Incomplete Report Server Configuration on an SSL-Protected
Server
> Causes Broken Report Links in Report Server E-Mail Notifications" section.
> Unfortunately, an examination of the suggestion revealed that we are not
> using SSL and when I checked the <UrlRoot> in the RSReportServer.config
file
> it was set correctly to the server name that I'd want used in replacing
> localhost in the URL.
> Does anyone know how to fix this?
>|||Thanks for the quick reply!
That didn't work; the e-mailed report still says localhost. Does it require
a reboot of the server or the service?
I changed two files named rswebapplication.config located here on the server:
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager
and
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager
Any ideas?
Thanks,
Keith
"Chris Alton [MSFT]" wrote:
> You'll actually need to modify the rswebapplication.config file for that
> setting.
> The section should look like the following to get your issue resolved:
> <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Broken link in e-mail subscription
> >
> > I have scheduled the first report at this customers site to send out
> e-mails
> > of reports. It is sending out the report just fine and including the PDF
> > file that I requested however I also checked the Include Link box in the
> > schedule because of the requirements of the users wanting to hide details
> in
> > the e-mailed report and wanting to link to the report and then drill down
> to
> > see the details only when necessary.
> >
> > When the e-mail is sent it doesn't formulate the URL correctly and says
> the
> > following:
> >
> > The report is accessible at the following address:
> > http://localhost/reports?%2fAccounting%.........
> >
> > The closest thing I've found online to resolve this was this link:
> >
> http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> 25641/ReadmeSQL2005.htm
> > -- See "Incomplete Report Server Configuration on an SSL-Protected
> Server
> > Causes Broken Report Links in Report Server E-Mail Notifications" section.
> >
> > Unfortunately, an examination of the suggestion revealed that we are not
> > using SSL and when I checked the <UrlRoot> in the RSReportServer.config
> file
> > it was set correctly to the server name that I'd want used in replacing
> > localhost in the URL.
> >
> > Does anyone know how to fix this?
> >
> >
>|||If you have two instances of Reporting Services installed then you need to
figure out which instance you are connecting to and modify the correct
configuration files. Also, if you modified the rsreportserver.config file
for the wrong instance then that could have caused it as well.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> X-WBNR-Posting-Host: 64.4.185.178
> From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtnsun@.discussions.microsoft.com>
> References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
<8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Broken link in e-mail subscription
> Thanks for the quick reply!
> That didn't work; the e-mailed report still says localhost. Does it
require
> a reboot of the server or the service?
> I changed two files named rswebapplication.config located here on the
server:
> C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportManager
> and
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager
> Any ideas?
> Thanks,
> Keith
>
> "Chris Alton [MSFT]" wrote:
> > You'll actually need to modify the rswebapplication.config file for
that
> > setting.
> >
> > The section should look like the following to get your issue resolved:
> > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Broken link in e-mail subscription
> > >
> > > I have scheduled the first report at this customers site to send out
> > e-mails
> > > of reports. It is sending out the report just fine and including the
PDF
> > > file that I requested however I also checked the Include Link box in
the
> > > schedule because of the requirements of the users wanting to hide
details
> > in
> > > the e-mailed report and wanting to link to the report and then drill
down
> > to
> > > see the details only when necessary.
> > >
> > > When the e-mail is sent it doesn't formulate the URL correctly and
says
> > the
> > > following:
> > >
> > > The report is accessible at the following address:
> > > http://localhost/reports?%2fAccounting%.........
> > >
> > > The closest thing I've found online to resolve this was this link:
> > >
> >
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > 25641/ReadmeSQL2005.htm
> > > -- See "Incomplete Report Server Configuration on an SSL-Protected
> > Server
> > > Causes Broken Report Links in Report Server E-Mail Notifications"
section.
> > >
> > > Unfortunately, an examination of the suggestion revealed that we are
not
> > > using SSL and when I checked the <UrlRoot> in the
RSReportServer.config
> > file
> > > it was set correctly to the server name that I'd want used in
replacing
> > > localhost in the URL.
> > >
> > > Does anyone know how to fix this?
> > >
> > >
> >
> >
>|||Welp, I didn't know I had a second instance, but you were right! I have it
fixed.
One thing though, I couldn't google a fix to this problem. Perhaps there is
something that could be added to BOL? Or did I miss it?
"Chris Alton [MSFT]" wrote:
> If you have two instances of Reporting Services installed then you need to
> figure out which instance you are connecting to and modify the correct
> configuration files. Also, if you modified the rsreportserver.config file
> for the wrong instance then that could have caused it as well.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Broken link in e-mail subscription
> > thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> > X-WBNR-Posting-Host: 64.4.185.178
> > From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtnsun@.discussions.microsoft.com>
> > References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
> <8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> > Subject: RE: Broken link in e-mail subscription
> >
> > Thanks for the quick reply!
> >
> > That didn't work; the e-mailed report still says localhost. Does it
> require
> > a reboot of the server or the service?
> >
> > I changed two files named rswebapplication.config located here on the
> server:
> > C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportManager
> > and
> > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportManager
> >
> > Any ideas?
> >
> > Thanks,
> > Keith
> >
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > You'll actually need to modify the rswebapplication.config file for
> that
> > > setting.
> > >
> > > The section should look like the following to get your issue resolved:
> > > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > Thread-Topic: Broken link in e-mail subscription
> > > >
> > > > I have scheduled the first report at this customers site to send out
> > > e-mails
> > > > of reports. It is sending out the report just fine and including the
> PDF
> > > > file that I requested however I also checked the Include Link box in
> the
> > > > schedule because of the requirements of the users wanting to hide
> details
> > > in
> > > > the e-mailed report and wanting to link to the report and then drill
> down
> > > to
> > > > see the details only when necessary.
> > > >
> > > > When the e-mail is sent it doesn't formulate the URL correctly and
> says
> > > the
> > > > following:
> > > >
> > > > The report is accessible at the following address:
> > > > http://localhost/reports?%2fAccounting%.........
> > > >
> > > > The closest thing I've found online to resolve this was this link:
> > > >
> > >
> http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > > 25641/ReadmeSQL2005.htm
> > > > -- See "Incomplete Report Server Configuration on an SSL-Protected
> > > Server
> > > > Causes Broken Report Links in Report Server E-Mail Notifications"
> section.
> > > >
> > > > Unfortunately, an examination of the suggestion revealed that we are
> not
> > > > using SSL and when I checked the <UrlRoot> in the
> RSReportServer.config
> > > file
> > > > it was set correctly to the server name that I'd want used in
> replacing
> > > > localhost in the URL.
> > > >
> > > > Does anyone know how to fix this?
> > > >
> > > >
> > >
> > >
> >
>|||I'm sure its in Books Online somewhere. It has to get the link for the
report from somewhere and if it is configured as localhost in all the
configuration files then its going to use localhost.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> Welp, I didn't know I had a second instance, but you were right! I have
it
> fixed.
> One thing though, I couldn't google a fix to this problem. Perhaps there
is
> something that could be added to BOL? Or did I miss it?
> "Chris Alton [MSFT]" wrote:
> > If you have two instances of Reporting Services installed then you need
to
> > figure out which instance you are connecting to and modify the correct
> > configuration files. Also, if you modified the rsreportserver.config
file
> > for the wrong instance then that could have caused it as well.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Broken link in e-mail subscription
> > > thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> > > X-WBNR-Posting-Host: 64.4.185.178
> > > From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?=<greenmtnsun@.discussions.microsoft.com>
> > > References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
> > <8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> > > Subject: RE: Broken link in e-mail subscription
> > >
> > > Thanks for the quick reply!
> > >
> > > That didn't work; the e-mailed report still says localhost. Does it
> > require
> > > a reboot of the server or the service?
> > >
> > > I changed two files named rswebapplication.config located here on the
> > server:
> > > C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> > Services\ReportManager
> > > and
> > > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> > Services\ReportManager
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > > Keith
> > >
> > >
> > > "Chris Alton [MSFT]" wrote:
> > >
> > > > You'll actually need to modify the rswebapplication.config file for
> > that
> > > > setting.
> > > >
> > > > The section should look like the following to get your issue
resolved:
> > > > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > > > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> > > > > Thread-Topic: Broken link in e-mail subscription
> > > > >
> > > > > I have scheduled the first report at this customers site to send
out
> > > > e-mails
> > > > > of reports. It is sending out the report just fine and including
the
> > PDF
> > > > > file that I requested however I also checked the Include Link box
in
> > the
> > > > > schedule because of the requirements of the users wanting to hide
> > details
> > > > in
> > > > > the e-mailed report and wanting to link to the report and then
drill
> > down
> > > > to
> > > > > see the details only when necessary.
> > > > >
> > > > > When the e-mail is sent it doesn't formulate the URL correctly
and
> > says
> > > > the
> > > > > following:
> > > > >
> > > > > The report is accessible at the following address:
> > > > > http://localhost/reports?%2fAccounting%.........
> > > > >
> > > > > The closest thing I've found online to resolve this was this link:
> > > > >
> > > >
> >
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > > > 25641/ReadmeSQL2005.htm
> > > > > -- See "Incomplete Report Server Configuration on an
SSL-Protected
> > > > Server
> > > > > Causes Broken Report Links in Report Server E-Mail Notifications"
> > section.
> > > > >
> > > > > Unfortunately, an examination of the suggestion revealed that we
are
> > not
> > > > > using SSL and when I checked the <UrlRoot> in the
> > RSReportServer.config
> > > > file
> > > > > it was set correctly to the server name that I'd want used in
> > replacing
> > > > > localhost in the URL.
> > > > >
> > > > > Does anyone know how to fix this?
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
of reports. It is sending out the report just fine and including the PDF
file that I requested however I also checked the Include Link box in the
schedule because of the requirements of the users wanting to hide details in
the e-mailed report and wanting to link to the report and then drill down to
see the details only when necessary.
When the e-mail is sent it doesn't formulate the URL correctly and says the
following:
The report is accessible at the following address:
http://localhost/reports?%2fAccounting%.........
The closest thing I've found online to resolve this was this link:
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad125641/ReadmeSQL2005.htm
-- See "Incomplete Report Server Configuration on an SSL-Protected Server
Causes Broken Report Links in Report Server E-Mail Notifications" section.
Unfortunately, an examination of the suggestion revealed that we are not
using SSL and when I checked the <UrlRoot> in the RSReportServer.config file
it was set correctly to the server name that I'd want used in replacing
localhost in the URL.
Does anyone know how to fix this?You'll actually need to modify the rswebapplication.config file for that
setting.
The section should look like the following to get your issue resolved:
<ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> I have scheduled the first report at this customers site to send out
e-mails
> of reports. It is sending out the report just fine and including the PDF
> file that I requested however I also checked the Include Link box in the
> schedule because of the requirements of the users wanting to hide details
in
> the e-mailed report and wanting to link to the report and then drill down
to
> see the details only when necessary.
> When the e-mail is sent it doesn't formulate the URL correctly and says
the
> following:
> The report is accessible at the following address:
> http://localhost/reports?%2fAccounting%.........
> The closest thing I've found online to resolve this was this link:
>
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
25641/ReadmeSQL2005.htm
> -- See "Incomplete Report Server Configuration on an SSL-Protected
Server
> Causes Broken Report Links in Report Server E-Mail Notifications" section.
> Unfortunately, an examination of the suggestion revealed that we are not
> using SSL and when I checked the <UrlRoot> in the RSReportServer.config
file
> it was set correctly to the server name that I'd want used in replacing
> localhost in the URL.
> Does anyone know how to fix this?
>|||Thanks for the quick reply!
That didn't work; the e-mailed report still says localhost. Does it require
a reboot of the server or the service?
I changed two files named rswebapplication.config located here on the server:
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager
and
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager
Any ideas?
Thanks,
Keith
"Chris Alton [MSFT]" wrote:
> You'll actually need to modify the rswebapplication.config file for that
> setting.
> The section should look like the following to get your issue resolved:
> <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Broken link in e-mail subscription
> >
> > I have scheduled the first report at this customers site to send out
> e-mails
> > of reports. It is sending out the report just fine and including the PDF
> > file that I requested however I also checked the Include Link box in the
> > schedule because of the requirements of the users wanting to hide details
> in
> > the e-mailed report and wanting to link to the report and then drill down
> to
> > see the details only when necessary.
> >
> > When the e-mail is sent it doesn't formulate the URL correctly and says
> the
> > following:
> >
> > The report is accessible at the following address:
> > http://localhost/reports?%2fAccounting%.........
> >
> > The closest thing I've found online to resolve this was this link:
> >
> http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> 25641/ReadmeSQL2005.htm
> > -- See "Incomplete Report Server Configuration on an SSL-Protected
> Server
> > Causes Broken Report Links in Report Server E-Mail Notifications" section.
> >
> > Unfortunately, an examination of the suggestion revealed that we are not
> > using SSL and when I checked the <UrlRoot> in the RSReportServer.config
> file
> > it was set correctly to the server name that I'd want used in replacing
> > localhost in the URL.
> >
> > Does anyone know how to fix this?
> >
> >
>|||If you have two instances of Reporting Services installed then you need to
figure out which instance you are connecting to and modify the correct
configuration files. Also, if you modified the rsreportserver.config file
for the wrong instance then that could have caused it as well.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> X-WBNR-Posting-Host: 64.4.185.178
> From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtnsun@.discussions.microsoft.com>
> References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
<8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Broken link in e-mail subscription
> Thanks for the quick reply!
> That didn't work; the e-mailed report still says localhost. Does it
require
> a reboot of the server or the service?
> I changed two files named rswebapplication.config located here on the
server:
> C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportManager
> and
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager
> Any ideas?
> Thanks,
> Keith
>
> "Chris Alton [MSFT]" wrote:
> > You'll actually need to modify the rswebapplication.config file for
that
> > setting.
> >
> > The section should look like the following to get your issue resolved:
> > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Broken link in e-mail subscription
> > >
> > > I have scheduled the first report at this customers site to send out
> > e-mails
> > > of reports. It is sending out the report just fine and including the
> > > file that I requested however I also checked the Include Link box in
the
> > > schedule because of the requirements of the users wanting to hide
details
> > in
> > > the e-mailed report and wanting to link to the report and then drill
down
> > to
> > > see the details only when necessary.
> > >
> > > When the e-mail is sent it doesn't formulate the URL correctly and
says
> > the
> > > following:
> > >
> > > The report is accessible at the following address:
> > > http://localhost/reports?%2fAccounting%.........
> > >
> > > The closest thing I've found online to resolve this was this link:
> > >
> >
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > 25641/ReadmeSQL2005.htm
> > > -- See "Incomplete Report Server Configuration on an SSL-Protected
> > Server
> > > Causes Broken Report Links in Report Server E-Mail Notifications"
section.
> > >
> > > Unfortunately, an examination of the suggestion revealed that we are
not
> > > using SSL and when I checked the <UrlRoot> in the
RSReportServer.config
> > file
> > > it was set correctly to the server name that I'd want used in
replacing
> > > localhost in the URL.
> > >
> > > Does anyone know how to fix this?
> > >
> > >
> >
> >
>|||Welp, I didn't know I had a second instance, but you were right! I have it
fixed.
One thing though, I couldn't google a fix to this problem. Perhaps there is
something that could be added to BOL? Or did I miss it?
"Chris Alton [MSFT]" wrote:
> If you have two instances of Reporting Services installed then you need to
> figure out which instance you are connecting to and modify the correct
> configuration files. Also, if you modified the rsreportserver.config file
> for the wrong instance then that could have caused it as well.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Broken link in e-mail subscription
> > thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> > X-WBNR-Posting-Host: 64.4.185.178
> > From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtnsun@.discussions.microsoft.com>
> > References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
> <8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> > Subject: RE: Broken link in e-mail subscription
> >
> > Thanks for the quick reply!
> >
> > That didn't work; the e-mailed report still says localhost. Does it
> require
> > a reboot of the server or the service?
> >
> > I changed two files named rswebapplication.config located here on the
> server:
> > C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportManager
> > and
> > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportManager
> >
> > Any ideas?
> >
> > Thanks,
> > Keith
> >
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > You'll actually need to modify the rswebapplication.config file for
> that
> > > setting.
> > >
> > > The section should look like the following to get your issue resolved:
> > > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > Thread-Topic: Broken link in e-mail subscription
> > > >
> > > > I have scheduled the first report at this customers site to send out
> > > e-mails
> > > > of reports. It is sending out the report just fine and including the
> > > > file that I requested however I also checked the Include Link box in
> the
> > > > schedule because of the requirements of the users wanting to hide
> details
> > > in
> > > > the e-mailed report and wanting to link to the report and then drill
> down
> > > to
> > > > see the details only when necessary.
> > > >
> > > > When the e-mail is sent it doesn't formulate the URL correctly and
> says
> > > the
> > > > following:
> > > >
> > > > The report is accessible at the following address:
> > > > http://localhost/reports?%2fAccounting%.........
> > > >
> > > > The closest thing I've found online to resolve this was this link:
> > > >
> > >
> http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > > 25641/ReadmeSQL2005.htm
> > > > -- See "Incomplete Report Server Configuration on an SSL-Protected
> > > Server
> > > > Causes Broken Report Links in Report Server E-Mail Notifications"
> section.
> > > >
> > > > Unfortunately, an examination of the suggestion revealed that we are
> not
> > > > using SSL and when I checked the <UrlRoot> in the
> RSReportServer.config
> > > file
> > > > it was set correctly to the server name that I'd want used in
> replacing
> > > > localhost in the URL.
> > > >
> > > > Does anyone know how to fix this?
> > > >
> > > >
> > >
> > >
> >
>|||I'm sure its in Books Online somewhere. It has to get the link for the
report from somewhere and if it is configured as localhost in all the
configuration files then its going to use localhost.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> Welp, I didn't know I had a second instance, but you were right! I have
it
> fixed.
> One thing though, I couldn't google a fix to this problem. Perhaps there
is
> something that could be added to BOL? Or did I miss it?
> "Chris Alton [MSFT]" wrote:
> > If you have two instances of Reporting Services installed then you need
to
> > figure out which instance you are connecting to and modify the correct
> > configuration files. Also, if you modified the rsreportserver.config
file
> > for the wrong instance then that could have caused it as well.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Broken link in e-mail subscription
> > > thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> > > X-WBNR-Posting-Host: 64.4.185.178
> > > From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?=<greenmtnsun@.discussions.microsoft.com>
> > > References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
> > <8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> > > Subject: RE: Broken link in e-mail subscription
> > >
> > > Thanks for the quick reply!
> > >
> > > That didn't work; the e-mailed report still says localhost. Does it
> > require
> > > a reboot of the server or the service?
> > >
> > > I changed two files named rswebapplication.config located here on the
> > server:
> > > C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> > Services\ReportManager
> > > and
> > > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> > Services\ReportManager
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > > Keith
> > >
> > >
> > > "Chris Alton [MSFT]" wrote:
> > >
> > > > You'll actually need to modify the rswebapplication.config file for
> > that
> > > > setting.
> > > >
> > > > The section should look like the following to get your issue
resolved:
> > > > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > > > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> > > > > Thread-Topic: Broken link in e-mail subscription
> > > > >
> > > > > I have scheduled the first report at this customers site to send
out
> > > > e-mails
> > > > > of reports. It is sending out the report just fine and including
the
> > > > > file that I requested however I also checked the Include Link box
in
> > the
> > > > > schedule because of the requirements of the users wanting to hide
> > details
> > > > in
> > > > > the e-mailed report and wanting to link to the report and then
drill
> > down
> > > > to
> > > > > see the details only when necessary.
> > > > >
> > > > > When the e-mail is sent it doesn't formulate the URL correctly
and
> > says
> > > > the
> > > > > following:
> > > > >
> > > > > The report is accessible at the following address:
> > > > > http://localhost/reports?%2fAccounting%.........
> > > > >
> > > > > The closest thing I've found online to resolve this was this link:
> > > > >
> > > >
> >
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > > > 25641/ReadmeSQL2005.htm
> > > > > -- See "Incomplete Report Server Configuration on an
SSL-Protected
> > > > Server
> > > > > Causes Broken Report Links in Report Server E-Mail Notifications"
> > section.
> > > > >
> > > > > Unfortunately, an examination of the suggestion revealed that we
are
> > not
> > > > > using SSL and when I checked the <UrlRoot> in the
> > RSReportServer.config
> > > > file
> > > > > it was set correctly to the server name that I'd want used in
> > replacing
> > > > > localhost in the URL.
> > > > >
> > > > > Does anyone know how to fix this?
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
Subscribe to:
Posts (Atom)