|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
12/06/2008, 07h33
|
#1 |
Messages: n/a
Hébergeur: |
Restoring TRN files from Log Shippping on SQL Server 2000
We've got a Primary and Secondary Server (as a standby currently in Read
Only mode ) on a Log Shipping set up. For the last week the TRN files have been backed up and moved across to the Secondary Server - but I've discovered they haven't been restoring. In other words , I have a bunch of TRN files sitting in a folder and that need to be restored. 1)Is it possible to catch up , while the servers remain in their existing modes? -- Jack Vamvas ___________________________________ Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
12/06/2008, 09h51
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Restoring TRN files from Log Shippping on SQL Server 2000
Is it SQL Server 2005? How do you set up Log Shipping?
Don't you have a job that does restore on the Standay Server? "Jack Vamvas" <DEL_TO_REPLY@del.com> wrote in message news:39qdnXv62qirKM3V4p2dnAA@bt.com... > We've got a Primary and Secondary Server (as a standby currently in Read > Only mode ) on a Log Shipping set up. > For the last week the TRN files have been backed up and moved across to > the > Secondary Server - but I've discovered they haven't been restoring. > > In other words , I have a bunch of TRN files sitting in a folder and that > need to be restored. > 1)Is it possible to catch up , while the servers remain in their existing > modes? > > -- > > Jack Vamvas > ___________________________________ > Search IT jobs from multiple sources- http://www.ITjobfeed.com > > > > > |
|
|
|
13/06/2008, 07h17
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: Restoring TRN files from Log Shippping on SQL Server 2000
Hi
It's SQL2000 . There is a job that Restores but constantly breaks- the issue I've got is it hasn't restored to the Standy By Server for a week. The TRN files have been copied , but not restored. -- Jack Vamvas ___________________________________ Search IT jobs from multiple sources- http://www.ITjobfeed.com "Uri Dimant" <urid@iscar.co.il> wrote in message news:eulB%23EGzIHA.2340@TK2MSFTNGP04.phx.gbl... > Is it SQL Server 2005? How do you set up Log Shipping? > Don't you have a job that does restore on the Standay Server? > > > > "Jack Vamvas" <DEL_TO_REPLY@del.com> wrote in message > news:39qdnXv62qirKM3V4p2dnAA@bt.com... >> We've got a Primary and Secondary Server (as a standby currently in Read >> Only mode ) on a Log Shipping set up. >> For the last week the TRN files have been backed up and moved across to >> the >> Secondary Server - but I've discovered they haven't been restoring. >> >> In other words , I have a bunch of TRN files sitting in a folder and >> that need to be restored. >> 1)Is it possible to catch up , while the servers remain in their existing >> modes? >> >> -- >> >> Jack Vamvas >> ___________________________________ >> Search IT jobs from multiple sources- http://www.ITjobfeed.com >> >> >> >> >> > > |
|
|
|
15/06/2008, 06h40
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: Restoring TRN files from Log Shippping on SQL Server 2000
James
What is the error? Have you specified an Output file for the job? What does it say? "Jack Vamvas" <DEL_TO_REPLY@del.com> wrote in message news:XvqdnaCA5Kl_n8_VnZ2dnUVZ8qrinZ2d@bt.com... > Hi > > It's SQL2000 . There is a job that Restores but constantly breaks- the > issue I've got is it hasn't restored to the Standy By Server for a week. > The TRN files have been copied , but not restored. > > -- > > Jack Vamvas > ___________________________________ > Search IT jobs from multiple sources- http://www.ITjobfeed.com > > > > > "Uri Dimant" <urid@iscar.co.il> wrote in message > news:eulB%23EGzIHA.2340@TK2MSFTNGP04.phx.gbl... >> Is it SQL Server 2005? How do you set up Log Shipping? >> Don't you have a job that does restore on the Standay Server? >> >> >> >> "Jack Vamvas" <DEL_TO_REPLY@del.com> wrote in message >> news:39qdnXv62qirKM3V4p2dnAA@bt.com... >>> We've got a Primary and Secondary Server (as a standby currently in Read >>> Only mode ) on a Log Shipping set up. >>> For the last week the TRN files have been backed up and moved across to >>> the >>> Secondary Server - but I've discovered they haven't been restoring. >>> >>> In other words , I have a bunch of TRN files sitting in a folder and >>> that need to be restored. >>> 1)Is it possible to catch up , while the servers remain in their >>> existing modes? >>> >>> -- >>> >>> Jack Vamvas >>> ___________________________________ >>> Search IT jobs from multiple sources- http://www.ITjobfeed.com >>> >>> >>> >>> >>> >> >> > > |
|
|
|
| Outils de la discussion | |
|
|
