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.
| Author |
Topic |
|
debug
Starting Member
29 Posts |
 Posted - 2003-09-14 : 09:19:26
|
| hi,Just wanted to know is Log Shipping possible in SQL 7.0 Standard Edition. If Yes how ?Regards,DebugDU |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-14 : 17:14:03
|
| Log shipping is just backing up the transaction log, copy the file to another server and restore it on a standby version of the database.This is easy to implement by creating a couple of jobs - one on the source server to backup the log and another on the destination to poll for log files, copy them across and apply them.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-15 : 11:59:23
|
| Log shipping is not available in SQL Server 7.0. It is available in SQL Server 2000 Enterprise Edition.Tara |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-09-15 : 16:43:18
|
| There are some instructions and stored procs included with the 7.0 Resource kit that help you set up Log Shipping for 7.0.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
debug
Starting Member
29 Posts |
Posted - 2003-09-27 : 13:10:11
|
| Hi Chad,Can u please tell me some resources through which I can implement Log Shipping in SQL 7.0 platforms....any clue where I can find the resources.REgards,DU |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-09-27 : 14:07:09
|
| How about searching SQLTeam to find [url]http://www.sqlteam.com/Item.asp?ItemID=133[/url] or Googling it------------------------------------------------------The more you know, the more you know you don't know. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-28 : 01:34:27
|
| You can download the resource kit from MS' web site.Tara |
|
|
|
|
|
|
LOG SHIPPING