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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-07-21 : 02:39:55
|
| Dear All,i did not found sql server logshipping in 2000 environment. will it support or only 2005 supports? i've found(right clicj database...all tasks...logshipping) in 2005. but not there in 2000.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-21 : 09:13:03
|
quote:
Originally posted by sunsanvin
Dear All,i did not found sql server logshipping in 2000 environment. will it support or only 2005 supports? i've found(right clicj database...all tasks...logshipping) in 2005. but not there in 2000.ArnavEven you learn 1%, Learn it with 100% confidence.
Go to Maintenance plan wizard(Bottom right). It supports only in enterprise/Dev edition in SQL 2000. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-21 : 23:18:49
|
| Log shipping is backup log, copy log backup file to another sql server then restore it. You can write your own script for that, that's what I did it in sql7. |
|
|
|
|
|
|
logshipping sql server 2000