when we run the dtsunui on the the nt 4.0 machine to generate the command line, we get following error:

access to packages properties requires entry of package owner password

And that 's...

Steve

i have removed the proc, and let now the full trans. logs backup working

Thanks

Steve,

i delete from the proc the option with truncate only. I run a tansactions log backup every 15mn and the proc every 3 hours, i think that must be enough...

Steve,

you are right, i only backup the transaction Logs every 15mn and run now the proc every 3 hours. And it seems to be ok. But i am waiting...

i am trying now a proc, i found at sqlservercentral, and i have created a dts which is running every 3 hours. I am watching the results. here is the...

on sql server 2K the backups are full backups, i dont want to switch to simple or differential

here is the message from the error log:

he execution of the following DTS Package failed:

Error Source: Microsoft Data Transformation Services (DTS) Package

Error Descriptionackage...

got still the same error. The error output file doesnt give good informations

thanks for all

dumale,

the problem is that to perform this action you need to be belong to windows administrators.

hello woast,

thank you, it seems to work........

Steve,

i ran the sp_fulltext_database proc, then i got following error:

Server: Msg 7610, Level 16, State 1, Procedure sp_fulltext_database, Line 61

Access is denied to 'E:\Microsoft SQL Server\MSSQL\FTDATA\SQL0001500013', or the path is...

First find out a place to backup the full DB, then make a backup from the transaction log only, then use EM menu and shrink the log file, you will...

Before rebooting the server, i would stop and restart the sqlserver  Agent.

In most of the case that helps and it takes only a fews seconds

Ok Brian, i will keep it in mind.

Thanks