Log SHipping Restore - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Log SHipping Restore

Author

Topic

UddinF
Starting Member

5 Posts

Posted - 2004-11-30 : 01:49:49

Log shipping does not seem to be working. I have copied .TRN file in my Primary Server schedule. But it is not copied and restored in my Secondary Server. How I restore my transaction log file (.trn) in my secondary server?
Please help me. If you have any document where I will get how to Ship the log in secondary server and restore then send it to me.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-11-30 : 13:34:36

The documentation would be SQL Server Books Online.

But I can help you out with log shipping. Did you setup a share on the secondary server where the tlogs are copied to?

Also, please provide the error from the copy and restore jobs.

Tara

mfemenel
Professor Frink

1421 Posts

Posted - 2004-11-30 : 15:59:47

Here are 3 great links I used back in September. If you are still stuck after reading these, let us know.
329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync"
Errors
http://support.microsoft.com/?id=329133

323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White Paper)
http://support.microsoft.com/?id=323135

314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
http://support.microsoft.com/?id=314515

Mike
"oh, that monkey is going to pay"

UddinF
Starting Member

5 Posts

Posted - 2004-11-30 : 22:45:28

quote:
Originally posted by tduggan

The documentation would be SQL Server Books Online.

But I can help you out with log shipping. Did you setup a share on the secondary server where the tlogs are copied to?

Also, please provide the error from the copy and restore jobs.

Tara

UddinF
Starting Member

5 Posts

Posted - 2004-11-30 : 22:51:32

Tara
I have created share in my Secondary SQL Server, but did not copy trn file from Primary Server. How I will copy the TRN files in to secondary server.
To check Log shipping functionality, I delete, add data and created view in my Primary server but secondary server is not updated as per the change.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-12-01 : 13:11:27

Have you check the copy and restore jobs that are created on the secondary server? What is the job status of those? Any errors in job history?

Tara

UddinF
Starting Member

5 Posts

Posted - 2004-12-01 : 22:27:19

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 02/12/04
Time: 9:19:21 AM
User: NESTLEBD01\NBLAdministrator
Computer: DHKBDC01
Description:
3041 :
BACKUP failed to complete the command BACKUP LOG [ISCustSurvey] TO DISK = N'\\159.12.248.8
\sqllogship$\ISCustSurvey_tlog_200412020919.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

UddinF
Data:
0000: e1 0b 00 00 10 00 00 00 á.......
0008: 09 00 00 00 44 00 48 00 ....D.H.
0010: 4b 00 42 00 44 00 43 00 K.B.D.C.
0018: 30 00 31 00 00 00 07 00 0.1.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...

I recived error from Seocndary Server's Log Shipping copy Job.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-12-02 : 12:31:04

Well your backup job is failing, so copy and restore are useless as they don't have a file to work with. Backup job will be on primary server.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources