SEEMS ITS A VIRUS

-----Original Message-----
From: El Mahjoub Tarkany [mailto:el-mahjoub.[Email Address Removed] Monday, March 29, 2004 9:08 PM
To: LazyDBA.com Discussion
Subject: Réf. : Back up SQL Server



-- SAUVEGARDE DE LA BASE TOTO_DB

select getdate()
go

BACKUP DATABASE TOTO_DB
TO toto_db_dump
WITH INIT
GO

--- and to make empty the log:

BACKUP LOG toto_db WITH TRUNCATE_ONLY
GO


El Mahjoub TARKANY
DSTI/DPI/GCI
74155



"Andrews, Daryl" <[Email Address Removed]


29/03/2004 17:03



Pour : "LazyDBA.com Discussion" <[Email Address Removed]
cc : (ccc : El Mahjoub Tarkany/DPI/DSTI/CLY)
Objet : Back up SQL Server



I would like to create a backup process to weekly back up my database
and then delete the log file. Anyone have any thoughts on this?

Thanks as always for everyone's help!

Daryl





MS Sql Server LazyDBA home page