Re: sql server 2000 backup and restore
- From: "Hank Arnold" <rasilon@xxxxxxx>
- Date: Thu, 8 Dec 2005 05:08:41 -0500
Our database is set up as follows:
1) SQL Server Agent service is set to automatic and started
2) Enterprise Manager has 2 scheduled jobs:
- A full backup is done nightly at 10PM. Previous backup file is copied to
an archive folder first.
- log files are copied to the backup file hourly
3) Both current and archived backup files are backed up to tape every
morning at 3AM.
If you want, I can send or post the SQL code that is used. I confess that
this was created automatically by our vendor's software.
I use Enterprise Manager to restore a backup manually.
--
Regards,
Hank Arnold
"Wendy Elizabeth" <WendyElizabeth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:02130457-0BC0-45C2-BFED-50AE041F9E4A@xxxxxxxxxxxxxxxx
> For a small company, I need to come up with backup and restore procedures
> for
> a sql server 2000 database. This company will not consider using sql
> server
> 2005 until the end of 2006.
> Thus I am wondering if you can give me a script and/or point to me to a
> url that that I can use as an example to setup backup and restore
> procedures
> for a sql server 2000 database?
>
> Thanks!
.
- Prev by Date: RE: sql2k Collation problems.
- Next by Date: Re: Performance Issues
- Previous by thread: Re: sql server 2000 backup and restore
- Next by thread: Re: sql server 2000 backup and restore
- Index(es):
Relevant Pages
|
