A query which loads data on a Production Server runs. Transaction Log is approaching 500MB, less than 50% done. 3GB HD was free on the drive. DB growth was auto. The query blocks out other users. How could you give the general user quick access to the database for use.
A. Kill update process
B. Let the update process run until it finishes
C. Kill the blocked processes
D. Stop and restart the SQL server
Answer:B
A query which loads data on a Production Server runs. Transaction Log is approaching 500MB, less than 50% done. 3GB HD was free on the drive. DB growth was auto. The query blocks out other users. How could you give the general user quick access to the database for use.
A. Kill update process B. Let the update process run until it finishes C. Kill the blocked processes D. Stop and restart the SQL server