We use the Database Maintenance Plans. They are VERY easy.

From Enterprise Manager, open Management, then Right Click on Database Maintenance Plan and choose to create a new one. Follow the steps.

Heather

-----Original Message-----
From: tessier.[Email Address Removed] [mailto:tessier.[Email Address Removed] Wednesday, April 28, 2004 9:46 AM
To: LazyDBA.com Discussion
Subject: Backup/restore procedures.


Hi all.
I'm considering writing backup and restore procedures. Any of you DBAs have procedures that you would be ready to share or know about resources I could look at to start with. Any help will be greatly appreciated.

Thanks

Pierre Tessier
IT Applications Specialist | Spécialiste des applications de TI
Information Management and Technology Directorate | Directorat de la gestion de l'information et de la technologie
Corporate Services Branch | Direction des services ministériels
Department of Finance and Treasury Board of Canada Secretariat | Ministère des Finances et Secrétariat du Conseil du Trésor du Canada
Ottawa, Canada K1A 0G5
613-996-8958 | Tessier.[Email Address Removed] | facsimile/télécopieur 613-995-5235





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
then respond to the confirmation email you get
For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page