Hi, you all know that rebuild index will create huge size of log. To keep it in minimal size we need to shrink the database log file.While shrinking of logfile Today i faced a problem in shrinking of log. To shrinking of log, I fired a logbackup query in one query window. in another query window i started to shrinking log and finally it got failed. error screenshot is given below.
Reasons are : While backup is running parlelly few operations won't run successfully. such as
1) alter database
2) alter file
3) file shrink
Finally, once backup of log operation got completed then again re run the shrinking of log command and now it got completed successfully.
Reasons are : While backup is running parlelly few operations won't run successfully. such as
1) alter database
2) alter file
3) file shrink
Finally, once backup of log operation got completed then again re run the shrinking of log command and now it got completed successfully.
Post a Comment