Monday, March 19, 2012
Need an easy way to replicate SQL Server Database
Hello,
I'm a MCSA and administrator of a large scale company, we have two
member server (with the same hardware configuration) that both have SQL
Server.
On one of these servers we have a SQL database that it stored more than
600,000,000 characters and everyday 700,000 characters added to it.
I really don't have information about SQL Server , Databases and how to
replicate them.
Would you please guide me that how can I easily replicate this important
database in these both servers, to have a redundant databases?
Yours Sincerely,
Ahmad Reza
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Ahmad,
there are various options for redundant databases. The classical one for
your situation is not actually replication, but is log shipping. There is
plenty of information in books on line about how to set it up (quite
straightforward). To use it out of the box, you'll need enterprise edition
of sql server, but if you have standard then there are scripts on the
resource kit to do it. There are other options and in a previous post
Michael Hotek lists his selection in this order which I agree with:
1. Transactional with queued updating
2. Merge
3. Transactional
Please post up any further questions.
Regards,
Paul Ibison
|||I would suggesting looking at the information in SQL Server 2000 Books on
Line. The types of replication available in SQL Server 2000 are documented
there as well as how to set them up.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I would also add that the word "easy" doesn't come into play here. Is it
complicated? No. Is it complex? Yes. You need a good understanding of
what a SQL Server is, what it does, and how it operates before even
attempting replication. If you don't start there, it is a very quick route
to blowing up an environment. That is NOT due to replication. It is due to
the way that data reacts and is handled in a distributed environment that
introduces many added challenges that simply don't exist on a single
machine. If there is a way to accomplish what you need without using
replication, my strong recommendation is to use the other solution.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
Wednesday, March 7, 2012
Need a help
Respected sir,
I need a query to retrieve all the week ends date of any given year.
ex
if year is 2006 from jan 01 2006 to dec 31 2006
then
6/1/2006 is saturday,7/1/2006 is sunday...etc upto last weekend day of 2006
if any one can help it
please do it
thanking you
sandeep patil
You can also use a tally table or number table to achieve this. I am using query to generate the number ranges 0 to 355declare @.year int
select @.year = 2006
select dte, datename(weekday, dte)
from
(
select dateadd(day, n, dateadd(year, @.year - 1900, 0)) as dte
from
(
select (a * 100) + (b * 10) + c as n
from
(
select 0 as a union select 1 union select 2 union select 3 union select 4 --union
--select 5 union select 6 union select 7 union select 8 union select 9
) a
cross join
(
select 0 as b union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9
) b
cross join
(
select 0 as c union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9
) c
) d
where n < datediff(day, dateadd(year, @.year - 1900, 0), dateadd(year, @.year - 1900 + 1, 0))
) f
where datepart(weekday, dte) in (1, 7)
order by dte|||
Hello tan,
Thank you very much for the help.
As i am new to this field i will be asking more no of quries plz help me.
Thanking you sandeep patil