RE: Transaction log backups
From: Peter Yang [MSFT] (petery_at_online.microsoft.com)
Date: 07/17/03
- Next message: Dan Guzman: "Re: sa not starting in master-db"
- Previous message: Richard: "Migrating to Active Directory"
- In reply to: steven: "Transaction log backups"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 17 Jul 2003 03:43:57 GMT
Hello Steven,
Thank you for your posting. As per your question, after you have
successfully created the plan, in the SQL Server Enterprise Manager
Management folder for the monitor server, the Log Shipping Monitor appears.
I suggest that you refer to the following article for details of log
shipping setup:
SQL Server 2000 How To Setup Log Shipping
http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=7395
ec1b-199f-42bc-a31b-2056adf73f94
Also, I have included the following article for more related information:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn
ol/sql/deploy/prodspecs/logship1.asp
If you have further questions on the issue, please feel free to post back.
Thanks & Regards,
Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support
Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "steven" <steven@woodwyn.com>
| Sender: "steven" <steven@woodwyn.com>
| Subject: Transaction log backups
| Date: Tue, 15 Jul 2003 14:38:08 -0700
| Lines: 11
| Message-ID: <048801c34b19$61fa3900$a301280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcNLGWH6V8e2C6bhTemaVTDSk6mNXA==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.security:14539
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| I want to implement log shipping for a customer. The
| first step seems to be to set up hourly transaction log
| backups on the primary server. This currently is set to
| occur, via a maintenence plan, daily at midnight. Can I
| just go in to the maintenence plans properties and set
| this to occur on an hourly basis and expect to have these
| transaction log backup files available for the "Copy Job"
| on the secondary server? Or do I need to set up the
| transaction logs in some other fashion?
|
| Thanks
|
- Next message: Dan Guzman: "Re: sa not starting in master-db"
- Previous message: Richard: "Migrating to Active Directory"
- In reply to: steven: "Transaction log backups"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
