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.

Be sure to use the Report Server URL, not the Report Manager URL.

Hello, a

Where can I find, or how can I get the Report Server URL, not the Report Manager URL.

I an running MS, SB Server 2003 R2, Premium edition. I have install SQL 2005, and SP2.

Hi ESQ-99999,

If your Report Manager virtual directory named ReportManager_VirtualDirectory lives on a web site working on the port number port on the machine named machine (which could be the computer name in your network or a fully qualified domain-name if the computer is accesible on Internet), then your Report Manager url looks like this:

http://<machine>:<port>/<ReportManager_VirtualDirectory>

The default name for the Report Manager virtual directory is Reports.

If you are trying to access this url from your local machine, where Report Server and Report Manager are installed, you can use localhost instead of the machine name:

http://<localhost>:<port>/<ReportManager_VirtualDirectory>

If the web site is SSL and your security level (set using the config tool) is at least 1, then the Report Manager url looks like this:

https://<machine>:<port>/<ReportManager_VirtualDirectory>

https://<localhost>:<port>/<ReportManager_VirtualDirectory>

If your web site is working on the default port (80 for not SSL and 443 for SSL), you can ignore the argument <port> in the previous urls:

http://<machine>/<ReportManager_VirtualDirectory>

https://<machine>/<ReportManager_VirtualDirectory>

This topic provides more information regarding your question:

http://msdn2.microsoft.com/en-us/library/ms159261.aspx

Mihaela

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi ESQ-99999,

My mistake reading your question. I was under the impression you were asking about the Report Manager url.

The Report Server url follows the same rules as the Report Manager url, except the name of the virtual directory, which should be the name of the Report Server virtual directory.

http://<machine>:<port>/<ReportServer_VirtualDirectory> or

http://<localhost>:<port>/<ReportServer_VirtualDirectory

If the web site hosting the Report Server url is SSL, the url starts with https intstead of http.

If the port number is the default (80 for not SSL or 443 for SSL), then you can ignore the argument <port> in the previous urls.

You can find the Report Server url in the Report Server configuration file in the node <UrlRoot> for all the security levels (0-3), or in the Report Manager configuration file in the node <ReportServerUrl> for the security levels 1-3.

The Report Server and Report Manager configuration files are located here:

%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportServer\RSReportServer.config

%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportManager\RSWebApplication.config

Mihaela

This posting is provided "AS IS" with no warranties, and confers no rights.