Maintenance Plan Configuration

Hi,
I've just started using SQL Server 2005 Standard and I'm moving database
across from SQL Server 2000.
I have setup a maintenance plan to backup my databases in the new
maintenance plan tool / SSIS but I cannot find any option to delete old
database backup files like I have in SQL Server 2000.
I found the Clean-up History task, but this does not appear to be related to
deleting database backup files.
Can someone please point me in the right direction for configuring this
option so I do not need to write my own job to delete old backup files.John
add a "Maintenance Clean Up" task to your Maintenance plan. This will
give you the option to delete old backfiles or logfiles.
Markus

Maintenance Plan Configuration

Hi,
I've just started using SQL Server 2005 Standard and I'm moving database
across from SQL Server 2000.
I have setup a maintenance plan to backup my databases in the new
maintenance plan tool / SSIS but I cannot find any option to delete old
database backup files like I have in SQL Server 2000.
I found the Clean-up History task, but this does not appear to be related to
deleting database backup files.
Can someone please point me in the right direction for configuring this
option so I do not need to write my own job to delete old backup files.
John
add a "Maintenance Clean Up" task to your Maintenance plan. This will
give you the option to delete old backfiles or logfiles.
Markus

Maintenance Plan Configuration

Hi,
I've just started using SQL Server 2005 Standard and I'm moving database
across from SQL Server 2000.
I have setup a maintenance plan to backup my databases in the new
maintenance plan tool / SSIS but I cannot find any option to delete old
database backup files like I have in SQL Server 2000.
I found the Clean-up History task, but this does not appear to be related to
deleting database backup files.
Can someone please point me in the right direction for configuring this
option so I do not need to write my own job to delete old backup files.John
add a "Maintenance Clean Up" task to your Maintenance plan. This will
give you the option to delete old backfiles or logfiles.
Markussql

Mail Configuration question

I have created a subscription to send a mail...and I get a link for the
report as below...
http://ServerName/reportserver?%.....
But the name is not getting resolved and my Admin says I need to use the
full qualified domain name(fqdn), Please let me know where I have to make
change in reporting services so the email link I get will have the fqdn of
the server like below instead of just the servername...
http://ServerName.xyz.com/reportserver?%.....
Thanks.What message do you get when you click the link? Are you passing
parameters? When you access the report server... do you use fqdn or
servername/reports
Ranga wrote:
> I have created a subscription to send a mail...and I get a link for the
> report as below...
> http://ServerName/reportserver?%.....
> But the name is not getting resolved and my Admin says I need to use the
> full qualified domain name(fqdn), Please let me know where I have to make
> change in reporting services so the email link I get will have the fqdn of
> the server like below instead of just the servername...
> http://ServerName.xyz.com/reportserver?%.....
> Thanks.|||I have choosen the parametere in the subscription properties, so I do not
pass any paraneters..
here is the message I get...
Bad Gateway
The following error occurred:
[code=DNS_HOST_NOT_FOUND] The host name was not found during the DNS lookup.
Contact your system administrator if the problem is not found by retrying the
URL.
If I change the link to use the fqdn it works .
Thanks.
"zomer" wrote:
> What message do you get when you click the link? Are you passing
> parameters? When you access the report server... do you use fqdn or
> servername/reports
>
> Ranga wrote:
> > I have created a subscription to send a mail...and I get a link for the
> > report as below...
> > http://ServerName/reportserver?%.....
> >
> > But the name is not getting resolved and my Admin says I need to use the
> > full qualified domain name(fqdn), Please let me know where I have to make
> > change in reporting services so the email link I get will have the fqdn of
> > the server like below instead of just the servername...
> >
> > http://ServerName.xyz.com/reportserver?%.....
> >
> > Thanks.
>