Backing up MS SQL?

[mark]

Hi

I'm hoping that some could point me in the right direction for "best
practice" in:

1) securely backing up a complete sql7 and 2000 server containing many
databases.

2) backing up an individual database

3) Securing the transaction on the hour as a mile stone to return to in the
event of error or system failure.

Thanks

Mark

[John Bell]

Re: Backing up MS SQL?

Hi

The first place to start is Books Online:
mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ad m
insql.chm::/ad_bkprst_9zcj. htm

John

"mark" <kardtech@on.ai bn.com> wrote in message
news:uFRIb.46$b 06.7@newsfep3-gui.server.ntli .net...[color=blue]
> Hi
>
> I'm hoping that some could point me in the right direction for "best
> practice" in:
>
> 1) securely backing up a complete sql7 and 2000 server containing many
> databases.
>
> 2) backing up an individual database
>
> 3) Securing the transaction on the hour as a mile stone to return to in[/color]
the[color=blue]
> event of error or system failure.
>
> Thanks
>
> Mark
>
>[/color]

[mark]

Re: Backing up MS SQL?

Standard Answer then. Thanks for NO help


"John Bell" <jbellnewsposts @hotmail.com> wrote in message
news:b8UIb.3645 $PB3.32098570@n ews-text.cableinet. net...[color=blue]
> Hi
>
> The first place to start is Books Online:
>[/color]
mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ad m[color=blue]
> insql.chm::/ad_bkprst_9zcj. htm
>
> John
>
> "mark" <kardtech@on.ai bn.com> wrote in message
> news:uFRIb.46$b 06.7@newsfep3-gui.server.ntli .net...[color=green]
> > Hi
> >
> > I'm hoping that some could point me in the right direction for "best
> > practice" in:
> >
> > 1) securely backing up a complete sql7 and 2000 server containing many
> > databases.
> >
> > 2) backing up an individual database
> >
> > 3) Securing the transaction on the hour as a mile stone to return to in[/color]
> the[color=green]
> > event of error or system failure.
> >
> > Thanks
> >
> > Mark
> >
> >[/color]
>
>[/color]

[Greg D. Moore \(Strider\)]

Re: Backing up MS SQL?


"mark" <kardtech@on.ai bn.com> wrote in message
news:iuUIb.85$b 06.63@newsfep3-gui.server.ntli .net...[color=blue]
> Standard Answer then. Thanks for NO help[/color]

What about the standard answer don't you like?

With more detail:

1) For backing up the actual installation, I generally find it easier to
reinstall the application if need be.

2) Backing up individual databases, look into creating a maintenance plan.
Or roll your own and use backup database as appropriate.

3) use BACKUP LOG on the required databases.

I'd also recommend getting a book on high availabilibity. The one from MS
press is quite good.

[color=blue]
>
>
> "John Bell" <jbellnewsposts @hotmail.com> wrote in message
> news:b8UIb.3645 $PB3.32098570@n ews-text.cableinet. net...[color=green]
> > Hi
> >
> > The first place to start is Books Online:
> >[/color]
>[/color]
mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ad m[color=blue][color=green]
> > insql.chm::/ad_bkprst_9zcj. htm
> >
> > John
> >
> > "mark" <kardtech@on.ai bn.com> wrote in message
> > news:uFRIb.46$b 06.7@newsfep3-gui.server.ntli .net...[color=darkred]
> > > Hi
> > >
> > > I'm hoping that some could point me in the right direction for "best
> > > practice" in:
> > >
> > > 1) securely backing up a complete sql7 and 2000 server containing many
> > > databases.
> > >
> > > 2) backing up an individual database
> > >
> > > 3) Securing the transaction on the hour as a mile stone to return to[/color][/color][/color]
in[color=blue][color=green]
> > the[color=darkred]
> > > event of error or system failure.
> > >
> > > Thanks
> > >
> > > Mark
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[mark]

Re: Backing up MS SQL?

Thankyou

"Greg D. Moore (Strider)" <mooregr@greenm s.com> wrote in message
news:7oWIb.3440 8$q55.5924@twis ter.nyroc.rr.co m...[color=blue]
>
> "mark" <kardtech@on.ai bn.com> wrote in message
> news:iuUIb.85$b 06.63@newsfep3-gui.server.ntli .net...[color=green]
> > Standard Answer then. Thanks for NO help[/color]
>
> What about the standard answer don't you like?
>
> With more detail:
>
> 1) For backing up the actual installation, I generally find it easier to
> reinstall the application if need be.
>
> 2) Backing up individual databases, look into creating a maintenance plan.
> Or roll your own and use backup database as appropriate.
>
> 3) use BACKUP LOG on the required databases.
>
> I'd also recommend getting a book on high availabilibity. The one from MS
> press is quite good.
>
>[color=green]
> >
> >
> > "John Bell" <jbellnewsposts @hotmail.com> wrote in message
> > news:b8UIb.3645 $PB3.32098570@n ews-text.cableinet. net...[color=darkred]
> > > Hi
> > >
> > > The first place to start is Books Online:
> > >[/color]
> >[/color]
>[/color]
mk:@MSITStore:C :\Program%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\ad m[color=blue][color=green][color=darkred]
> > > insql.chm::/ad_bkprst_9zcj. htm
> > >
> > > John
> > >
> > > "mark" <kardtech@on.ai bn.com> wrote in message
> > > news:uFRIb.46$b 06.7@newsfep3-gui.server.ntli .net...
> > > > Hi
> > > >
> > > > I'm hoping that some could point me in the right direction for "best
> > > > practice" in:
> > > >
> > > > 1) securely backing up a complete sql7 and 2000 server containing[/color][/color][/color]
many[color=blue][color=green][color=darkred]
> > > > databases.
> > > >
> > > > 2) backing up an individual database
> > > >
> > > > 3) Securing the transaction on the hour as a mile stone to return to[/color][/color]
> in[color=green][color=darkred]
> > > the
> > > > event of error or system failure.
> > > >
> > > > Thanks
> > > >
> > > > Mark
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[mountain man]

Re: Backing up MS SQL?

"mark" <kardtech@on.ai bn.com> wrote in message
news:uFRIb.46$b 06.7@newsfep3-gui.server.ntli .net...[color=blue]
> Hi
>
> I'm hoping that some could point me in the right direction for "best
> practice" in:
>
> 1) securely backing up a complete sql7 and 2000 server containing many
> databases.[/color]

1.1) Schedule a complete backup of all production databases and include
the system databases master, msdb, model at some appropriate
timeslot.
To do this for the first time, try using Enterprise Manager, select
the
"schedule" option and then examine the TSQL code in the scheduled
task. Modify the schedule times to suit your operations.

1.2) Take a copy of the backup files offsite.

[color=blue]
> 2) backing up an individual database[/color]


As above, so here below ... much like the
Hermetic tradition.


[color=blue]
> 3) Securing the transaction on the hour as a mile stone to return to in[/color]
the[color=blue]
> event of error or system failure.[/color]


You will need to examine the differential backup strategies available
and gauge the best approach for this method in relation to your data.

The M$ documentation is not too bad at all if you are prepared to
go and experiment and learn by practice the operations therein
documented, and I'd be surprised if step by step instructions on
all of the above are not clearly established within it.






Pete Brown
Falls Creek
OZ