compressed backups

Is there any way to automate compression of timed database backups from a
T-SQL script? I don't see any compression options for the BACKUP command in
BOL. Something analogous to the -Fc option for pg_dump in PostgreSQL.
A timed command-line batch file using a file compression program could be
set to execute after the script, but the large data file would have to be
created first.
Thanks,
David P. Lurie
David,
There's nothing inside SQL Server to do compression. You could execute a command after the backup that uses
ZIP or similar to do compression. Or use SQL Lite Speed (probably misspelled), which uses an extended stored
procedure to do backup, and this does compression.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"David P. Lurie" <abc@.def.net> wrote in message news:%23IaE$vFKEHA.3628@.TK2MSFTNGP12.phx.gbl...
> Is there any way to automate compression of timed database backups from a
> T-SQL script? I don't see any compression options for the BACKUP command in
> BOL. Something analogous to the -Fc option for pg_dump in PostgreSQL.
> A timed command-line batch file using a file compression program could be
> set to execute after the script, but the large data file would have to be
> created first.
> Thanks,
> David P. Lurie
>

Compress MSDE DB

Is there a way to run a compress using the command line?
If so what is the command?
What do you mean by compress the MSDE ? If you want to try to shrink the
logfile / the datafiles (releasing unsused space int the files to the
operating system) you could try executing the commadn to compress these
files via osql.exe
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Jon" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:175901c54f32$3e0b1540$a601280a@.phx.gbl...
> Is there a way to run a compress using the command line?
> If so what is the command?

Complete Command of given PID

Hi,
we sometimes have statements which seem to block the whole server.
now i use this to get information of running processes:
SELECT
spid,
kpid,
status,
hostname
, USER_NAME(uid)
, program_name
, DB_NAME(dbid)
, memusage,*
FROM
master.dbo.sysprocesses
WHERE
status = 'runnable'
ORDER BY
status
aSC
the cmd row only shows the single first row of the statement,
so i cant get the information where the statement really comes from.
is there a way to get it all? maybe the whole statment or
sp_ text which is running inside this pid?
thanks,
peppiAs an alternative, have you considered using the SQL Profiler?|||Yes,-)
sometimes bad processes are running on 100% cpu and i cant even start
enterprise manager. only thing i can get running is queryanalyzer, so
i need some handy stuff to get information to kill some tasks and
see where it came from first.
i found fn_get_sql migt be useful,
maybe someone has got a procedure which gets all running tasks and
shows the text in one procedure?
thanks,
mike|||This may help
http://www.sommarskog.se/sqlutil/aba_lockinfo.html|||If you have PID with you,
run =>
DBCC INPUTBUFFER(PID),
to get the query rather than getting it from sysprocess...
If you have to monitor more and need to get the full query use Profiler.
Thanks,
Sree
"markc600@.hotmail.com" wrote:

> As an alternative, have you considered using the SQL Profiler?
>