Log Shipping over T1

I have no experience with log shipping, but we are considering setting this
up between two locations connected by a T1. There is other traffic over the
T1, and we don't want to impact performance for these other services (intern
et, intranet, etc.).
There are approximately 75 users making entries and changes all day long, so
I'm not sure how heavily the log shipping process will use the T1, can anyo
ne give me any advice or pointers?
Thanks for your help.
Also, where can I find pricing for upgrading a SQL 2000 standard (dual proce
ssor license) to Enterprise?The cost will be the cost of copying the transaction logs across the T1
line... Check the current size of your log backups ...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"TomT" <tomt@.tomt.com> wrote in message
news:B8C40AA5-DC9F-4DD7-80A4-318C40F5D277@.microsoft.com...
> I have no experience with log shipping, but we are considering setting
this up between two locations connected by a T1. There is other traffic over
the T1, and we don't want to impact performance for these other services
(internet, intranet, etc.).
> There are approximately 75 users making entries and changes all day long,
so I'm not sure how heavily the log shipping process will use the T1, can
anyone give me any advice or pointers?
> Thanks for your help.
> Also, where can I find pricing for upgrading a SQL 2000 standard (dual
processor license) to Enterprise?|||Hi Tom,
Thanks to Wayne's information. As for your question of the pricing of
upgrade, from what I can tell this question is a non-technical issue and
would probable be best answered from someone from the sales and marketing
department of the SQL Server. For more information, please visit the
following link:
http://www.microsoft.com/sql/howtobuy/default.asp
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Wayne,
Thanks for your assistance on this. I assume that the more frequently the lo
g back ups are done, the smaller the files are that will be copied...
Tom|||Baisong,
Thanks for your help. Would you be able to tell me what the process is to ac
tually upgrade the standard version to enterprise? Would I be able to use th
e existing installation, or would I have to re-install?
Thanks|||Yes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"TomT" <tomt@.tomt.com> wrote in message news:4C45DBAF-B1FB-4FCF-962D-BD64AAAFF087@.microsoft
.com...
> Wayne,
> Thanks for your assistance on this. I assume that the more frequently the log back
ups are done, the smaller
the files are that will be copied...
> Tom|||Pop in the EE CD and select "upgrade".
Note that you don't have to use EE in order to do log shipping. The built in
log shipping requires EE, but a
lot of people use their home-grown log shipping code (search (google etc) an
d you will find), and we also
included log shipping in Db Maint.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"TomT" <tomt@.tomt.com> wrote in message news:3BC9E30A-50FB-496A-BA9A-FEB33024B530@.microsoft
.com...
> Baisong,
> Thanks for your help. Would you be able to tell me what the process is to actually
upgrade the standard
version to enterprise? Would I be able to use the existing installation, or would I have to
re-install?
> Thanks|||Thanks very much for your help. I understand there's a utility in the sql sv
r resource kit for log shipping. Have you tried that?|||Hi Tom,
I'm not a DBA but I am the producer for the SQL Server website. You'll find information
on upgrading from SQL Server Standard to Enterprise edition in the SQL Server Books On
line (BOL) found on the MSDN website at [url]http://msdn.microsoft.com/library/default[
/url]
.asp?url=/library/en-us/startsql/portal_7ap1.asp.
Also on MSDN, you'll find the technical article "Upgrading an Existing Insta
llation of SQL Server"
http://msdn.microsoft.com/library/d.../>
ew_2xtf.asp
I also found the following article on the Microsoft Product Support Site whi
ch looks to be applicable
BUG: Log Shipping Elements are Missing After You Upgrade from Standard to En
terprise Edition
http://support.microsoft.com/defaul...kb;en-us;295306
If you continue to have issues, please feel free to email me and I'll see wh
at I can find out at this end.|||Hi, Tom
It is very convenient for you to establish the log shipping using the
maintenance plan wizard to establish the log shipping. The following are
some good links for you to esteblish them step by step. I hope they are
helpful for your :
HOW TO SET UP LOG SHIPPING BETWEEN SQL SERVER 2000 SERVERS
http://support.microsoft.com/defaul...ql%2fcontent%2f
2000papers%2fLogShippingFinal.asp#howtoset
Also, the following articles have good infomation for your reference:
FAQ of Log Shipping
http://support.microsoft.com/?id=314515
Log Shipping in SQL Server 2000 - Part 1
http://www.microsoft.com/technet/pr...n/logship1.mspx
Log Shipping in SQL Server 2000 - Part 2
http://www.microsoft.com/technet/pr...n/logship2.mspx
Hope this helps.Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.