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

LUN attachment and moving temp db

F:\ is a RAID 0 LUN attached to the server (it's on a SAN)
After running
ALTER DATABASE tempdb
MODIFY FILE (name=tempprod, filename='f:\tempdb\tempdb_data.mdf')
I get the error
Server: Msg 5184, Level 16, State 1, Line 1
Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered server. Only
formatted files on which the cluster resource of the server has a
dependency can be used.
What do i need to change in my configuration? Seems I can only see a
g:\ drive who is also on the san.Apparently, the F drive is from your locally attach
drives, not those shared by the cluster nodes. You cannot
create a database file on a non-shared drive if your SQL
instance runs in a cluster.
Create the tempdb file on the G drive.
Linchi
>--Original Message--
>F:\ is a RAID 0 LUN attached to the server (it's on a
SAN)
>After running
>ALTER DATABASE tempdb
> MODIFY FILE (name=tempprod,
filename='f:\tempdb\tempdb_data.mdf')
>I get the error
>
>Server: Msg 5184, Level 16, State 1, Line 1
>Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered
server. Only
>formatted files on which the cluster resource of the
server has a
>dependency can be used.
>What do i need to change in my configuration? Seems I
can only see a
>g:\ drive who is also on the san.
>.
>|||Ahh the F:\ drive needed to be a dependancy of the sql cluster service.
I was able to create temp on that drive after it was added.
Linchi Shea wrote:
> Apparently, the F drive is from your locally attach
> drives, not those shared by the cluster nodes. You cannot
> create a database file on a non-shared drive if your SQL
> instance runs in a cluster.
> Create the tempdb file on the G drive.
> Linchi
>
>>--Original Message--
>>F:\ is a RAID 0 LUN attached to the server (it's on a
> SAN)
>>After running
>>ALTER DATABASE tempdb
>> MODIFY FILE (name=tempprod,
> filename='f:\tempdb\tempdb_data.mdf')
>>I get the error
>>
>>Server: Msg 5184, Level 16, State 1, Line 1
>>Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered
> server. Only
>>formatted files on which the cluster resource of the
> server has a
>>dependency can be used.
>>What do i need to change in my configuration? Seems I
> can only see a
>>g:\ drive who is also on the san.
>>.