Creating A Backup & Recovery Strategy

I need to create a backup and recovery strategy for SQL
Server 2000 but I'm not a DBA and I'm not very familiar
with SQL Server.
Here is what I would like to do.
1. I want to back up all the databases on the server at
the same time (i.e. I don't want to do each database
individually).
2. I want to schedule automatic backups.
3. I amy need to restore some or all of the databases on
the server.
4. I may need to restore all the databases to a different
server (the new server would have the same setup as the
old server).
5. It doesn't matter whether the backup is done in
Enterprise Manager or by using SQL commands.
Any advice would be appreciated.Create a Database Maintenance Plan using the wizard...set the backup
location to a drive not on your server (use UNC path). Tape is also an
option, but I never use that...too many tapes have failed on me.
You have options in the wizard for scheduling, data base integrity checks,
etc. What you choose in these options will depend on your databases and how
"recoverable" you need them to be.
I strongly recommend doing a little reading in Books Online before you get
started.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Evan" <anonymous@.discussions.microsoft.com> wrote in message
news:016901c39f19$9b7a05d0$a401280a@.phx.gbl...
> I need to create a backup and recovery strategy for SQL
> Server 2000 but I'm not a DBA and I'm not very familiar
> with SQL Server.
> Here is what I would like to do.
> 1. I want to back up all the databases on the server at
> the same time (i.e. I don't want to do each database
> individually).
> 2. I want to schedule automatic backups.
> 3. I amy need to restore some or all of the databases on
> the server.
> 4. I may need to restore all the databases to a different
> server (the new server would have the same setup as the
> old server).
> 5. It doesn't matter whether the backup is done in
> Enterprise Manager or by using SQL commands.
> Any advice would be appreciated.
>|||I'm having trouble finding detailed information on
restoring databases. I've found directions for restoring
databases in Enterprise Manager but those directions only
apply if the database is already on the server. I'm
looking for database recovery information for the
following scenario:
1. The database server, for whatever reason, is unusable.
2. I build a new database server.
3. I have to copy the database backups to the new server.
How do I restore a database in Enterprise Manager if the
database never existed on the server before?
Thanks in advance.
>--Original Message--
>Create a Database Maintenance Plan using the
wizard...set the backup
>location to a drive not on your server (use UNC path).
Tape is also an
>option, but I never use that...too many tapes have failed
on me.
>You have options in the wizard for scheduling, data base
integrity checks,
>etc. What you choose in these options will depend on
your databases and how
>"recoverable" you need them to be.
>I strongly recommend doing a little reading in Books
Online before you get
>started.
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>"Evan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:016901c39f19$9b7a05d0$a401280a@.phx.gbl...
>> I need to create a backup and recovery strategy for SQL
>> Server 2000 but I'm not a DBA and I'm not very familiar
>> with SQL Server.
>> Here is what I would like to do.
>> 1. I want to back up all the databases on the server at
>> the same time (i.e. I don't want to do each database
>> individually).
>> 2. I want to schedule automatic backups.
>> 3. I amy need to restore some or all of the databases on
>> the server.
>> 4. I may need to restore all the databases to a
different
>> server (the new server would have the same setup as the
>> old server).
>> 5. It doesn't matter whether the backup is done in
>> Enterprise Manager or by using SQL commands.
>> Any advice would be appreciated.
>
>.
>|||Right-click databases, All tasks, restore database. Type in the name you
want to restore and fill in all the other blanks.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Evan" <anonymous@.discussions.microsoft.com> wrote in message
news:027401c39f36$8ecd1080$a601280a@.phx.gbl...
> I'm having trouble finding detailed information on
> restoring databases. I've found directions for restoring
> databases in Enterprise Manager but those directions only
> apply if the database is already on the server. I'm
> looking for database recovery information for the
> following scenario:
> 1. The database server, for whatever reason, is unusable.
> 2. I build a new database server.
> 3. I have to copy the database backups to the new server.
> How do I restore a database in Enterprise Manager if the
> database never existed on the server before?
> Thanks in advance.
> >--Original Message--
> >Create a Database Maintenance Plan using the
> wizard...set the backup
> >location to a drive not on your server (use UNC path).
> Tape is also an
> >option, but I never use that...too many tapes have failed
> on me.
> >
> >You have options in the wizard for scheduling, data base
> integrity checks,
> >etc. What you choose in these options will depend on
> your databases and how
> >"recoverable" you need them to be.
> >
> >I strongly recommend doing a little reading in Books
> Online before you get
> >started.
> >
> >--
> >Kevin Hill
> >President
> >3NF Consulting
> >
> >www.3nf-inc.com/NewsGroups.htm
> >
> >"Evan" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:016901c39f19$9b7a05d0$a401280a@.phx.gbl...
> >> I need to create a backup and recovery strategy for SQL
> >> Server 2000 but I'm not a DBA and I'm not very familiar
> >> with SQL Server.
> >>
> >> Here is what I would like to do.
> >> 1. I want to back up all the databases on the server at
> >> the same time (i.e. I don't want to do each database
> >> individually).
> >> 2. I want to schedule automatic backups.
> >> 3. I amy need to restore some or all of the databases on
> >> the server.
> >> 4. I may need to restore all the databases to a
> different
> >> server (the new server would have the same setup as the
> >> old server).
> >> 5. It doesn't matter whether the backup is done in
> >> Enterprise Manager or by using SQL commands.
> >>
> >> Any advice would be appreciated.
> >>
> >
> >
> >.
> >