Load Balancing and Fail Over for SQL Server.

Hi!
Currently we only have one SQL Server database in our production system. I would like to add one more SQL server 2000 database. I would like to configure them so that both server share the load and Failover. I did some research and I found that I can do this by installing the OS (Windows 2000 Server Enterprise Edition) and SQL 2000 Enterprise Edition on both machines using the windows clustering. I want both servers to be active. They both have a copy of the production data. What I don't know is that, if it is possible to synchronize the data on both databases using SQL Server Replication utitlites. From what I know one SQL Server must be Publisher and one Subscriber. Can one sql server be both? Because I want both sql server to be identical. Can I set up replication between more than 2 servers? We just need to add one server for now but I would like it to be expandable. In the future we may need more.
So Please provide me some ideas and answers about the following.
1- Can two SQL Server cross replicate (both update each other in order to be identical)?
2 -Does replication work beyond 2 servers.?
3- If you were to set up a production database; what do you recommend considering the load balancing and Failover using Windows 2000 Server Enterprise Edition and SQL Sever 20000 Enterprise Edition?

Thanks,
MichaelTry this link for a tutorial but get his book a chapter will walk you through the SQL Server setup with the hardware. The only thing he did not cover was the Fiber Channels in detail. Hope this helps.
http://www.windowsnetworking.com/articles_tutorials/Deploy-Windows-Server-2003-Planning-Network-Bandwidth.html|||

I did not answer the second part to your question about replication it is SQL Server Agent dependent. So you must install SQL Server Agent with a service account, most of the service packs we have been getting are fixes to the replication system why I cannot tell you because I have not use it for a long time it uses a lot of system resources and you could do the same with DTS on scheduled Jobs. You can test it because in SQL Server 2000 you can setup replication within one server. Hope this helps.

|||

Thank you guys for your time. I did find an open source solution. It is cross platform and can do merge replication between different databases. The name of the product is daffodil.

Thanks again.

Programmer 420

List the folder contents using SQL

Hi all,
I have built a Disaster Recovery Site for my DB.on periodic basis, trn files from production server reach DR server and DR setup will apply them locally.

If the flow is smooth then no issues, if one of the file does not reach DR
the entire setup will halt for the want of the file and I dn't have any means to
know which file is missing.

Both my production and DR site located remotely behind firewalls, i.e i can't
physically access the servers or remotely login to the server.

Can anyone tell me how to see the contents in a folder in the server using
SQL query .

Any help is highly appreciated

Thanks and Regards
Srinivas VaranasiI'd use xp_cmdshell (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp).

-PatP|||use

master..xp_cmdshell 'dir c:\'|||Thanks Pat.|||Harshal, sorry to find "STUPID" as Ur Signature

List of Procedures used in RDL on Production site

Is there a way to search all of the RDL's that have been deployed out to a
Reporting Services site? I am looking for what stored procedures are being
used on our production reporting site.
Any help would be appreciated.All the deployed reports are stored in a table called "catalog" you can get a
list by querying the table.
Amarnath
"LostinSpace" wrote:
> Is there a way to search all of the RDL's that have been deployed out to a
> Reporting Services site? I am looking for what stored procedures are being
> used on our production reporting site.
> Any help would be appreciated.|||I appreciate the response, but this is not what I am looking for.
I need to search the content inside every single rdl to see what stored
procedures are being used. If there isn't a way to do this in RS, is there a
way to do this from vss?
"Amarnath" wrote:
> All the deployed reports are stored in a table called "catalog" you can get a
> list by querying the table.
> Amarnath
> "LostinSpace" wrote:
> > Is there a way to search all of the RDL's that have been deployed out to a
> > Reporting Services site? I am looking for what stored procedures are being
> > used on our production reporting site.
> > Any help would be appreciated.|||OK You said "deployed" so I gave that answer...
You can search for "<CommandType>StoredProcedure</CommandType>" and the next
line will be the stored procedure name. and select look in "Current project"
from the find dialog box.
Hey this looks very basic, is this what you want ?
Amarnath
"LostinSpace" wrote:
> I appreciate the response, but this is not what I am looking for.
> I need to search the content inside every single rdl to see what stored
> procedures are being used. If there isn't a way to do this in RS, is there a
> way to do this from vss?
> "Amarnath" wrote:
> > All the deployed reports are stored in a table called "catalog" you can get a
> > list by querying the table.
> >
> > Amarnath
> >
> > "LostinSpace" wrote:
> >
> > > Is there a way to search all of the RDL's that have been deployed out to a
> > > Reporting Services site? I am looking for what stored procedures are being
> > > used on our production reporting site.
> > > Any help would be appreciated.|||Deployed is correct. I need to search every single rdl deployed to our RS site.
I need to find what stored procedures are used in each rdl. I do not seem to
be able to
do this from the ReportServer database. I know how to do this from the rdl
when in working with the rdl on its own in Visual Studio, but I have over 500
reports in RS. I need a quick and painless way to search all of the rdlâ's at
the same time to see their stored procedures.
I do appreciate the response, I just have a feeling this can not be done...
"Amarnath" wrote:
> OK You said "deployed" so I gave that answer...
> You can search for "<CommandType>StoredProcedure</CommandType>" and the next
> line will be the stored procedure name. and select look in "Current project"
> from the find dialog box.
> Hey this looks very basic, is this what you want ?
> Amarnath
>
> "LostinSpace" wrote:
> > I appreciate the response, but this is not what I am looking for.
> > I need to search the content inside every single rdl to see what stored
> > procedures are being used. If there isn't a way to do this in RS, is there a
> > way to do this from vss?
> >
> > "Amarnath" wrote:
> >
> > > All the deployed reports are stored in a table called "catalog" you can get a
> > > list by querying the table.
> > >
> > > Amarnath
> > >
> > > "LostinSpace" wrote:
> > >
> > > > Is there a way to search all of the RDL's that have been deployed out to a
> > > > Reporting Services site? I am looking for what stored procedures are being
> > > > used on our production reporting site.
> > > > Any help would be appreciated.