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.
| 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. |
 |
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
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 |
|
|
|
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. |
|
|
|
|
|
|
backup