Hi All,
Interesting the different methods of backing up.
I notice that none of the options shown bother to copy the database or transaction logs
to another server after successful backup . . . .

We backup our databases each night @ 23:00, transaction logs every 30 minutes,
after each backup we copy the backed up file to a remote server.


Cheers

Jeff

-----Original Message-----
From: tessier.[Email Address Removed] [mailto:tessier.[Email Address Removed] Wednesday, 28 April 2004 9:46 PM
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