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

Backup restore Expand / Collapse
Author
Message
Posted Friday, July 2, 2010 1:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 5:21 PM
Points: 208, Visits: 1,036
a snerio is this suppose, i took a full backup than took 2 transactional log backup than again took 2nd full backup than again 3rd n 4th transactional log backup, now i wud restore 1st full backup than restore all 4 transactional bakups, without restoring 2nd full backup. IS it possible?? and if not thn why??
Post #946633
Posted Friday, July 2, 2010 2:05 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 2:01 PM
Points: 40,390, Visits: 36,823
sachinsoni84 (7/2/2010)
IS it possible??


Yes. Full backups do not truncate the transaction log.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #946639
Posted Friday, July 2, 2010 2:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 5:21 PM
Points: 208, Visits: 1,036
thank you i have been askd thid in interview and i answered correct.

one more thng wanna knw, if a stored procedure has 50 Tsql statment and is it is suddenly showing slow performance how wud i trouble shoot n tune it??
Post #946641
Posted Friday, July 2, 2010 2:15 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 2:01 PM
Points: 40,390, Visits: 36,823
sachinsoni84 (7/2/2010)
one more thng wanna knw, if a stored procedure has 50 Tsql statment and is it is suddenly showing slow performance how wud i trouble shoot n tune it??


Please post this in a new thread. It's totally unrelated to backups and restores.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #946642
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse