A database originally created at size of 500M, now grows to 1G, the data is 200M, to reclaim 600M for OS:
A. DBCC SHRINKDATABSE (database, 50)
B. DBCC SHRINKDATABSE (database, 400)
C. DBCC SHRINKFILE (database, 400)
D. DBCC SHRINKFILE (database, 50)
Answer:A
A database originally created at size of 500M, now grows to 1G, the data is 200M, to reclaim 600M for OS:
A. DBCC SHRINKDATABSE (database, 50) B. DBCC SHRINKDATABSE (database, 400) C. DBCC SHRINKFILE (database, 400) D. DBCC SHRINKFILE (database, 50)