best back-up method?

i have a Dedicated SQL server running 2000Adv. and a
server running 2003SBS (premium)as my DC running a 75 pc
network.wanted to do a nightly SQL DB back-up to the SBS
and was wondering how i should go about it. I was
thinking i could make it a replication server and just
replicate nightly or "on the fly", second was to make a 2
node cluser but i didnt it was ok to do that with my DC,
and if it could, how could i test to see if my machine
can hanlde the required Throughput, without crashing the
Domain, Of course. i use the DC ro rung my Intranet
website, Office Server, Firewall management module, File
Replication. and didnt know if it was safe to run all
thoes apps, simultaniousely. ok, well my thanks for any
help or guidance you could give me.
Hi
You can't cluster it. You need SQL 2000 Enterprise Edition and Windows
2000/2003 Enterprise edition to do that.
On the SQL box, you can do a database backup to the local drive and then
have a job that copies it onto the SBS box every night.
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
Specialist SQL Server Solutions and Consulting
MVP Program: http://www.microsoft.com/mvp
"Justin" <Irclover1@.hotmail.com> wrote in message
news:2a4dc01c46647$843714d0$a401280a@.phx.gbl...
> i have a Dedicated SQL server running 2000Adv. and a
> server running 2003SBS (premium)as my DC running a 75 pc
> network.wanted to do a nightly SQL DB back-up to the SBS
> and was wondering how i should go about it. I was
> thinking i could make it a replication server and just
> replicate nightly or "on the fly", second was to make a 2
> node cluser but i didnt it was ok to do that with my DC,
> and if it could, how could i test to see if my machine
> can hanlde the required Throughput, without crashing the
> Domain, Of course. i use the DC ro rung my Intranet
> website, Office Server, Firewall management module, File
> Replication. and didnt know if it was safe to run all
> thoes apps, simultaniousely. ok, well my thanks for any
> help or guidance you could give me.