I want to share about the Concurrent operations at database level i,e in an mind may arise questions like-
A)Can we do Backup and shrink at the same time?
B)Can we add additional Database files when Backup is running?
C)Can we do Full backup database along with the differential Backup?
As we know that during any Backup operation(either full,log or differential) it's not possible to do the add/remove additonal files, shrink, file modify(alter).
You can easily do in your test machine, how ever for Pictorical if you need then Please refer the below links
Link :http://technet.microsoft.com/en-us/library/ms189315%28SQL.90%29.aspx
A)Can we do Backup and shrink at the same time?
B)Can we add additional Database files when Backup is running?
C)Can we do Full backup database along with the differential Backup?
As we know that during any Backup operation(either full,log or differential) it's not possible to do the add/remove additonal files, shrink, file modify(alter).
You can easily do in your test machine, how ever for Pictorical if you need then Please refer the below links
Link :http://technet.microsoft.com/en-us/library/ms189315%28SQL.90%29.aspx
No comments:
Post a Comment