Hi there,

I currently manage 3 SQL Server Database ... one of which is on a web
server.

I need to backup these databases and am not sure the best way of doing
this. Can someone please point me in the right direction of backing up
and also restoring

M3ckon

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

"m3ckon" <anonymous@devdex.com> wrote in message
news:40c9c5ab$0$7877$c397aba@news.newsgroups.ws...
>
> Hi there,
>
> I currently manage 3 SQL Server Database ... one of which is on a web
> server.
>
> I need to backup these databases and am not sure the best way of doing
> this. Can someone please point me in the right direction of backing up
> and also restoring
>
> M3ckon
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!

See BACKUP and RESTORE in Books Online. You should also check out "recovery
models", as that will affect your choice of backup strategy. If you want a
quick way to put something in place, then you can use Enterprise Manager to
generate a maintenance plan which will do backups for you.

Simon