See BACKUP in BOL. Then tell us where you're stuck.

PS: You really don't want to delete the log file.

P

-----Original Message-----
From: Andrews, Daryl [mailto:[Email Address Removed] Monday, March 29, 2004 10:04 AM
To: LazyDBA.com Discussion
Subject: 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