April 8, 2005 at 2:18 pm
Hi
I ran dbcc shrinkfile (3,emptyfile) command. The command failed in the midway for want of disk space after running for 6 hours. I did migrate some data. I created the disk space and ran again. The command did run successfully, but did not empty the file, though there is enough disk space and enough space on other files of the same filegroup.
What could be the reason?
Thanks in advance.
Hari
April 8, 2005 at 4:04 pm
Are you shrinking a data file or transaction log file? If there are active transactions, it can't shrink beyond those. Also, a transaction log is made up of multiple virtual log files. It can't shrink to a smaller size than one of those. If its a log file, you may need to run a process over the log to move all active transactions to the new file. Otherwise, just wait, and SQL should take care of it for you.
What is the purpose of using EMPTYFILE? Are you wanting to delete the file?
Steve
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply