Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Round Robin Database tool

Author  Topic 

Maryada
Starting Member

3 Posts

Posted - 2012-05-30 : 09:17:16
Can any one help me to implement Round Robin Database in Sql Server

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2012-05-30 : 09:23:52
[code]
CREATE DATABASE RoundRobin
GO
[/code]

Seriously though. What is it you want to do exactly?

Transact Charlie
Msg 3903, Level 16, State 1, Line 1736:
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

http://nosqlsolution.blogspot.co.uk/
Go to Top of Page

Maryada
Starting Member

3 Posts

Posted - 2012-05-30 : 10:43:31
I want to implement the concept of rrd in sql server database
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2012-05-30 : 11:00:57
OK -- you miss my point.....

Why use sql server for this? there are products (free open source ones) designed to do this. (http://oss.oetiker.ch/rrdtool/ for instance)

Products that are free.

I meant:

"What are yo actually trying to do" -- As in what do you want the database to do.... Are you monitoring something? do you need roll up aggregates from the round robin samples????

Sql server doesn't come with support out of the box for this. it's a general purpose relational database and you want to do something quite different.....

Here's the result of a quick google. A pdf explaining an implementation in mysql...

http://www.fromdual.com/sites/default/files/rrd.pdf



Transact Charlie
Msg 3903, Level 16, State 1, Line 1736:
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

http://nosqlsolution.blogspot.co.uk/
Go to Top of Page

Maryada
Starting Member

3 Posts

Posted - 2012-05-30 : 12:56:23
Hi,
Thanks for replying and yes i know about the tool but I'm unable to understand how to use this tool. Can you please give an overview
Go to Top of Page
   

- Advertisement -