Clean old backup with retaindays

Hi,
i have 3 sql server, one with sql2000 and other with sql2005.
on each server i have a maintenance plan. this plan save all base to a
network share on another server.
all plans have the option retaindays at 2.
the sql2000 server clean correctly the old backup. but the sql2005 servers
don' t do it.
all the sql service are running under the same account.
i applied patch on a sql2005 at 3152, the other is always at 3042. but
nothing change.
everydays i muste clean manually the backup...retaindays don't work!
someone have an idea about this bug ?
Ty
ChristopheChristophe,
It's not a bug, it's a feature. :) I assume that you are using the
Maintenance Plans. One thing to know is that the option RETAINDAYS does not
actually delete anything, it is just marking the file to tell SQL Server not
to overwrite this file before the retain time is up.
If you are using SQL 2000 Legacy Maintenance Plans, check the Complete
Backup and Transaction Log Backup tabs and make sure that "Remove files
older than" is set.
If you are using SQL 2005 Maintenance plans, you also need to include the
Maintenance Cleanup task to specify file deletions.
RLF
"Christophe" <Christophe@.discussions.microsoft.com> wrote in message
news:C14216B5-32AA-4D94-972C-122D864DEA51@.microsoft.com...
> Hi,
> i have 3 sql server, one with sql2000 and other with sql2005.
> on each server i have a maintenance plan. this plan save all base to a
> network share on another server.
> all plans have the option retaindays at 2.
> the sql2000 server clean correctly the old backup. but the sql2005 servers
> don' t do it.
> all the sql service are running under the same account.
> i applied patch on a sql2005 at 3152, the other is always at 3042. but
> nothing change.
> everydays i muste clean manually the backup...retaindays don't work!
> someone have an idea about this bug ?
> Ty
> Christophe|||ty very much ! ;)
"Russell Fields" wrote:
> Christophe,
> It's not a bug, it's a feature. :) I assume that you are using the
> Maintenance Plans. One thing to know is that the option RETAINDAYS does not
> actually delete anything, it is just marking the file to tell SQL Server not
> to overwrite this file before the retain time is up.
> If you are using SQL 2000 Legacy Maintenance Plans, check the Complete
> Backup and Transaction Log Backup tabs and make sure that "Remove files
> older than" is set.
> If you are using SQL 2005 Maintenance plans, you also need to include the
> Maintenance Cleanup task to specify file deletions.
> RLF
>
> "Christophe" <Christophe@.discussions.microsoft.com> wrote in message
> news:C14216B5-32AA-4D94-972C-122D864DEA51@.microsoft.com...
> > Hi,
> >
> > i have 3 sql server, one with sql2000 and other with sql2005.
> > on each server i have a maintenance plan. this plan save all base to a
> > network share on another server.
> > all plans have the option retaindays at 2.
> > the sql2000 server clean correctly the old backup. but the sql2005 servers
> > don' t do it.
> > all the sql service are running under the same account.
> > i applied patch on a sql2005 at 3152, the other is always at 3042. but
> > nothing change.
> >
> > everydays i muste clean manually the backup...retaindays don't work!
> > someone have an idea about this bug ?
> >
> > Ty
> > Christophe
>
>

Choose client net lib?

I have SQL Server 7 and it has in the network config utility TCP, Named
Pipes and Multiprotocol. I want to use TCP on my clients, the only problem
is I don't know how to set them up to use this as opposed to named pipes. I
do not want to authenticate at the OS level so I'm trying to get it to use
plain old TCP. By default, all of them appear to be using named pipes. Is
there some way I can confirm or change this theory?
Thanks,
Ben"Becker" <ben@.benbecker.net> wrote in message
news:%23T0zraKdEHA.228@.TK2MSFTNGP11.phx.gbl...
> I have SQL Server 7 and it has in the network config utility TCP, Named
> Pipes and Multiprotocol. I want to use TCP on my clients, the only
problem
> is I don't know how to set them up to use this as opposed to named pipes.
I
> do not want to authenticate at the OS level so I'm trying to get it to use
> plain old TCP. By default, all of them appear to be using named pipes.
Is
> there some way I can confirm or change this theory?
If you install the SQL Server client network utility tool, you can verify
which libraries are installed and in which order that are used.
Steve

Checking existence of network file

Hi Guys,

Just wonder if anyone know how can I check the network file (whether exists or not) using TSQL or Extended Stored Procedures?

What I can find out is the xp_fileexist, but it is only meant for searching file residing locally... I have tried mapping the drive of another server to the SQL server, but it just won't do it...

Any idea?

Thanks in advance.

Regards,
TangI have used xp_cmdshell as follows:

exec @.result = xp_cmdshell ('dir \\server\share\filename.ext')

if(@.result = 0)

begin
it's there so do something
end

This has worked well so far...

checking bandwidth of network

Hi ,
how can i check if the current bandwidth that i am having is enough for
the operation ? can i use the performance monitor or the profiler(which item
to choose) ?
tks & rdgs
what operation do you have in mind? performance monitor can show you network
bandwidth consumption. Even the task manager can do it.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> Hi ,
> how can i check if the current bandwidth that i am having is enough for
> the operation ? can i use the performance monitor or the profiler(which
> item
> to choose) ?
> tks & rdgs
|||Hi ,
i am thinking of monitoring the SQL SERVER status from a client PC and the
operations i meant earlier are just some normal updates , select queries thru
a client interface
tks & rdgs
"wei xiao" wrote:

> what operation do you have in mind? performance monitor can show you network
> bandwidth consumption. Even the task manager can do it.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
>
>

checking bandwidth of network

Hi ,
how can i check if the current bandwidth that i am having is enough for
the operation ? can i use the performance monitor or the profiler(which item
to choose) ?
tks & rdgswhat operation do you have in mind? performance monitor can show you network
bandwidth consumption. Even the task manager can do it.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> Hi ,
> how can i check if the current bandwidth that i am having is enough for
> the operation ? can i use the performance monitor or the profiler(which
> item
> to choose) ?
> tks & rdgs|||Hi ,
i am thinking of monitoring the SQL SERVER status from a client PC and the
operations i meant earlier are just some normal updates , select queries thru
a client interface
tks & rdgs
"wei xiao" wrote:
> what operation do you have in mind? performance monitor can show you network
> bandwidth consumption. Even the task manager can do it.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> > Hi ,
> >
> > how can i check if the current bandwidth that i am having is enough for
> > the operation ? can i use the performance monitor or the profiler(which
> > item
> > to choose) ?
> >
> > tks & rdgs
>
>

checking bandwidth of network

Hi ,
how can i check if the current bandwidth that i am having is enough for
the operation ? can i use the performance monitor or the profiler(which item
to choose) ?
tks & rdgswhat operation do you have in mind? performance monitor can show you network
bandwidth consumption. Even the task manager can do it.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
> Hi ,
> how can i check if the current bandwidth that i am having is enough for
> the operation ? can i use the performance monitor or the profiler(which
> item
> to choose) ?
> tks & rdgs|||Hi ,
i am thinking of monitoring the SQL SERVER status from a client PC and the
operations i meant earlier are just some normal updates , select queries thr
u
a client interface
tks & rdgs
"wei xiao" wrote:

> what operation do you have in mind? performance monitor can show you netwo
rk
> bandwidth consumption. Even the task manager can do it.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://weblogs.asp.net/weix
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:FCEFEFEB-F6E0-4FB3-AB78-80C8E3DC6076@.microsoft.com...
>
>

Check Whether Or not a File is a New One

Hi,

I need to set up a package to copy a file from a network share to a server. Before the copy job, I need to check whether the file, e.g. test.txt, is created within one day, if not, then check again an hour later.

Did you search this forum? I know this question has been asked a couple times before; I just could fine this one:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=789950&SiteID=1