SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 backup
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rajeshvarun
Starting Member

7 Posts

Posted - 08/05/2013 :  13:42:57  Show Profile  Reply with Quote
HI, What will happen to data being modified, when backup process is running... does backup process creates any sort of new transaction logs?... if not how do we recover modified dataa.. and from which part of tx log do we need to restore the data... am sorry if these qns seems to be silly as I am new to SQL DBA

James K
Flowing Fount of Yak Knowledge

3643 Posts

Posted - 08/05/2013 :  14:14:36  Show Profile  Reply with Quote
quote:
Originally posted by rajeshvarun

HI, What will happen to data being modified, when backup process is running... does backup process creates any sort of new transaction logs?... if not how do we recover modified dataa.. and from which part of tx log do we need to restore the data... am sorry if these qns seems to be silly as I am new to SQL DBA

When you restore a database from a full backup (or differential backup or log backup), the database will be consistent as of some point in time. Without going into a lot of details, that point in time is when the copying of the data extends was completed.

But the key thing is that the database will be consistent. You don't have to worry about DML operations that modified the data while the backup was in progress. Those may or may not be in the backup, and as long as you don't care whether the results of a DML operation that coincided with the backup task was included or excluded from the backup, you can ignore the gory details.

Edited by - James K on 08/05/2013 14:20:51
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 08/06/2013 :  01:52:32  Show Profile  Reply with Quote
To restore a database to point in time you will apply the last full backup available, latest differential backup after that full backup and then all the log backups after the differential backup in sequence until the time you want. This will make sure all transaction until the time are applied in db and you'll have database with complete data as of that required time.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

gerrywilson
Starting Member

1 Posts

Posted - 08/08/2013 :  06:16:59  Show Profile  Reply with Quote
You won't able to modify data when back up process is running. And back process won't contain modified data. You must create another back up after data is modified.

Business Reputation management
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3643 Posts

Posted - 08/08/2013 :  08:10:15  Show Profile  Reply with Quote
quote:
Originally posted by gerrywilson

You won't able to modify data when back up process is running. And back process won't contain modified data. You must create another back up after data is modified.


Both these statements are incorrect.

You CAN modify data when backup process is running.

Backup may or may not contain data that was modified after the backup process started.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000