Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 backup

Author  Topic 

rajeshvarun
Starting Member

7 Posts

Posted - 2013-08-05 : 13:42:57
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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-08-05 : 14:14:36
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-06 : 01:52:32
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 Post

Posted - 2013-08-08 : 06:16:59
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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-08-08 : 08:10:15
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
   

- Advertisement -