Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Off Site Backup Server

 
   Database Forums (Home) -> Replication RSS
Next:  Reporting Server - Replication Topology  
Author Message
K_Willy

External


Since: Sep 26, 2006
Posts: 1



(Msg. 1) Posted: Tue Sep 26, 2006 7:18 am
Post subject: Off Site Backup Server
Archived from groups: microsoft>public>sqlserver>replication (more info?)

We are in the process of setting up an Off Site backup Server. Our
production Server is currently Window Servers 2003 with TS, and we will be
using DFS to duplicate the data on the other Server. Both Servers will be
running GoldMine and SQL Server 2000. The queston is, will we be able to use
the same SQL Server License for replication on the other Server or would we
have to purchase a seperate License?
--
Kent Williamson
IT Specialist

 >> Stay informed about: Off Site Backup Server 
Back to top
Login to vote
Hilary Cotter3

External


Since: Aug 28, 2004
Posts: 1259



(Msg. 2) Posted: Tue Sep 26, 2006 11:16 am
Post subject: Re: Off Site Backup Server [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

No, if you are using DFS to replicate your data files to the standby server
(or Double Take or log shipping) you do not need a SQL Server license on the
standby server as long as the standby server is not actively running SQL
Server and serving clients, and both servers will not be serving clients at
the same time. If you are using SQL Server replication to do this you will.

Note that I would be careful about using DFS to replicated your live
database files.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"K_Willy" wrote in message

> We are in the process of setting up an Off Site backup Server. Our
> production Server is currently Window Servers 2003 with TS, and we will be
> using DFS to duplicate the data on the other Server. Both Servers will be
> running GoldMine and SQL Server 2000. The queston is, will we be able to
> use
> the same SQL Server License for replication on the other Server or would
> we
> have to purchase a seperate License?
> --
> Kent Williamson
> IT Specialist

 >> Stay informed about: Off Site Backup Server 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
mirroring a web site to another server - Hi All; I have a client interested in using our CMS and hosting on our servers, but also interested in mirroring their web site to another server (also from our servers) for enhanced availability. So I need the ides fromyou to consider the..

multiple site prinicples with mirroring - I have the following set up Site 1 Server1 Server2 Server3 Primary Mirror Witness Site 2 Server4 Server5 Server6 Primary Mirror Witness Both sites contain the same set up and database, what I need to do is ensure that any..

Problem in BACKUP job - Hi, I am using a job to take daily backup. BACKUP DATABASE databasenameTO DISK=N'path' WITH INIT,NOUNLOAD,NAME=N'name', NOSKIP,STATS=10,NOFORMAT and it was working fine. When I tried to restore the backup, I couldn't restore it, the backup was ..

why is the SQL backup filesize so big - Hi, We have an database which is about the file size of 730MB, this db is set configure with publisher and will always push data to our backup server database. When we backup this db, the database backup filesize is actually 85GB (full backup from SQL)...

Backup - 2000 - I've got a distibutor server, 1 publishing server and 3 subscribing servers all on SS 2000 SP4 with transactional immediate replication. What I want to know is this: 1) what is the "best practices way" to back up the distributor and 2) if ...
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]