Forum Replies Created

Viewing 15 posts - 1 through 15 (of 43 total)

  • RE: Question on backup of sql database

    GilaMonster (6/30/2011)

    Please go and do some reading on log shipping, log backups and restore sequences.

    Reinitialise as in recreate the log shipping secondary the same way you did when you first...

    June 30, 2011 at 9:07 pm

    #1346842

  • RE: Question on backup of sql database

    any advice on the logshipping portion? thanks

    June 30, 2011 at 2:42 am

    #1346384

  • RE: Question on backup of sql database

    GilaMonster (6/29/2011)

    REinitialise log shipping.

    Full or diff backups of a log shipped primary, yes. Log log backups, no.

    Hi GilaMonster, what do you mean by reinitialise log shipping? re-setup again?

    As for "Full...

    June 29, 2011 at 7:01 pm

    #1346305

  • RE: Log shipping failed - Restoring portion

    anthony.green (6/24/2011)

    We have an RTP of 15 minutes with an RTO of 2 hours, for this we use logshipping but we use the no recovery setting as we do not...

    June 29, 2011 at 12:11 am

    #1345645

  • RE: Question on backup of sql database

    GilaMonster (6/28/2011)

    That'll work.

    ok, btw how abt the log shipping? if the restore was done during last friday 1050hrs, it will cause broken link to the transaction logs for the logshipping...

    June 28, 2011 at 8:37 pm

    #1345617

  • RE: Question on backup of sql database

    GilaMonster (6/28/2011)

    That'll work.

    thanks for the advice... noted.

    June 28, 2011 at 8:23 pm

    #1345615

  • RE: Question on backup of sql database

    GilaMonster (6/28/2011)

    Illegal_Operation (6/27/2011)

    Executing the query "BACKUP LOG [Database] TO DISK = N'C:\\Backup\\Databas..." failed with the following error: "Database 'DATABASE' cannot be opened. It is in the middle of a...

    June 28, 2011 at 3:16 am

    #1345026

  • RE: Question on backup of sql database

    Erode P. Satheesh (6/28/2011)

    Have you scheduled a transaction log backup through maintenace plan on a database which is already a part of log shipping? If so, you should...

    June 28, 2011 at 12:58 am

    #1344976

  • RE: Question on backup of sql database

    Does this affect the log shipping as well? seems like my log shipping also got some problems. When i run the Restore job for the log shipping, it got this...

    June 27, 2011 at 7:55 pm

    #1344931

  • RE: Question on backup of sql database

    Erode P. Satheesh (6/27/2011)

    T-sql, maintenance plan and even if you are using third party tool the information will be stored in these tables.

    Hi Erode, i have run the script and...

    June 27, 2011 at 7:19 pm

    #1344925

  • RE: Question on backup of sql database

    Executing the query "BACKUP LOG [Database] TO DISK = N'C:\\Backup\\Databas..." failed with the following error: "Database 'DATABASE' cannot be opened. It is in the middle of a restore.

    The above...

    June 27, 2011 at 6:57 pm

    #1344923

  • RE: Question on backup of sql database

    Erode P. Satheesh (6/27/2011)

    I think you are having problem in sequencing the transaction log files. The below query will help you to sequence the same.

    SELECT b.physical_device_name,

    ...

    June 27, 2011 at 3:40 am

    #1344364

  • RE: Question on backup of sql database

    i think i know what is the problem. There is 1 transaction log that is missing which is 1050hrs. I am not sure why the file is missing, is it...

    June 27, 2011 at 12:24 am

    #1344314

  • RE: Question on backup of sql database

    got some problems again. I tried to restore last friday around 1700hrs backup.

    I restore the full backup which is successfull and the differential backup on friday which is successful too....

    June 27, 2011 at 12:15 am

    #1344312

  • RE: Question on backup of sql database

    any comments or advice? thanks

    June 26, 2011 at 10:56 pm

    #1344302

Viewing 15 posts - 1 through 15 (of 43 total)