January 18, 2007 at 8:30 pm
Hi
I have a need to automatically copy data or DB from an SQL2000 server on 'PC1' to an SQL2005 Server on 'PC2'.
The SQL2000 server collects data from a SCADA system on the same PC, The PC is pretty busy so I don't want to allow users access to query the SQL2000 DB as this could put even more stress on the PC.
So I would like to use the SQL2005 PC so clients can query the data.
I have looked at mirroring but that only works with 2005, I'm not sure if log shipping works either.
Is there no easy way to automatically copy a db from one server to another?
Cheers
Eugene
January 18, 2007 at 10:50 pm
You can use replication or custom log shipping (backup/restore)...
MohammedU
Microsoft SQL Server MVP
January 19, 2007 at 3:43 am
remember that even if u have ur log shipped database to read only mode u will not be able to read the data always. users cant access the database when the restoration of the log file is on progress as restoration is done with single user mode.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
January 21, 2007 at 12:42 pm
HI
How does Replication or Log Shipping impact on the performance?
Which one would be better?
Is there any simple examples of this as the MS help files aren't the best and I'm not that familiar with SQL!
Cheers
Eugene
January 22, 2007 at 12:22 am
Replication will have more overhead than log shipping but when you do logshipping you kill all the connections in the destination db to restore the log where as replication is online operation...
http://www.sqlteam.com/item.asp?ItemID=207
http://www.awprofessional.com/articles/article.asp?p=599700&rl=1
http://www.sqlservercentral.com/columnists/ckempster/customlogshipping.asp
MohammedU
Microsoft SQL Server MVP
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply