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 Expand / Collapse
Author
Message
Posted Thursday, December 5, 2013 12:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 7, 2013 2:35 AM
Points: 3, Visits: 9
Hi

I am new in sql server.
I am confused with the backing up process ,when we do a Diff. backup does it backup from ldf. file or just mdf?What a bout Full and Log backup?
Does the ldf file only contain transaction log?

Could anyone please give me some resource to read more about it?
Post #1519880
Posted Thursday, December 5, 2013 12:09 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: Today @ 2:48 AM
Points: 42,438, Visits: 35,493
A differential backup is a backup of the data changes since the last full backup. It's a data backup, not a log backup, so mostly the data file with enough log to restore consistently.

The ldf is 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 #1519883
Posted Thursday, December 5, 2013 12:23 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 5, 2014 2:29 AM
Points: 235, Visits: 343
Hi,

This link will help you understand all the backup types of sql server in detail.

http://technet.microsoft.com/en-us/magazine/2009.07.sqlbackup.aspx

Thanks & regards
MJ
Post #1519885
Posted Thursday, December 5, 2013 12:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 29, 2014 11:29 PM
Points: 147, Visits: 587
go through below article to get an idea about SQL backups.

http://www.mssqltips.com/sqlservertutorial/6/types-of-sql-server-backups/





Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1519886
Posted Thursday, December 5, 2013 1:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 7, 2013 2:35 AM
Points: 3, Visits: 9
Sorry ,so " with enough log to restore consistently" means from ldf?


Post #1519897
Posted Thursday, December 5, 2013 2:32 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: Today @ 2:48 AM
Points: 42,438, Visits: 35,493
It means enough of the transaction log so that the restore can recreate the database in a transactionally consistent way. Don't worry about what from what file, just focus on what the backups do in terms of the database.


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 #1519918
Posted Saturday, December 7, 2013 2:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 7, 2013 2:35 AM
Points: 3, Visits: 9

Thanks to all
It was so helpful
Post #1520802
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse