Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

backup, copy is working however, restore is not working Expand / Collapse
Author
Message
Posted Wednesday, January 22, 2014 7:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:46 AM
Points: 6,370, Visits: 13,706
Akayisi (1/22/2014)
Perry Whittle (1/22/2014)
Akayisi (1/22/2014)
Hi Perry on secondary the output is

YayinSistemi_Data 219269000000023400116

on primary

YayinSistemi_Data 219269000000023400116

In this case you can fix the missing tran log backups issue by taking a differential backup on the primary and restoring it with NORECOVERY to the secondary This will bring the 2 in step and log restores should be successful. Do this before a full backup occurs on the primary


perry is there any way to fix it besides taking full backup of primary?

as i said above, immediately take a differential backup of the primary and apply to the secondary with NORECOVERY. Do this before a full backup occurs on the primary


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1533614
Posted Wednesday, January 22, 2014 7:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:46 AM
Points: 6,370, Visits: 13,706
I'm guessing by the sudden stunned silence you have fixed it

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1533643
Posted Wednesday, January 22, 2014 7:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 18, 2014 5:00 AM
Points: 38, Visits: 175
haha Yeah that was a solution i was thinking about. bUt during work-day i did not want to blow up the our network. Yeah it is working by the way lol
Post #1533651
Posted Wednesday, January 22, 2014 8:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:46 AM
Points: 6,370, Visits: 13,706
Akayisi (1/22/2014)
during work-day i did not want to blow up the our network. Yeah it is working by the way lol

The diff generally wouldnt be too large to do that


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1533667
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse