November 20, 2001 at 2:05 am
Hello everyone.
I've MSSQL Server 7.0 SP3 on WinNT 4 SP6. In database was one big datafile (m.mdf), it's size was about 10GB. It caused some difficulties, because it became too big for 17GB disk after (maybe) 2 or 3 weeks. So i added to PRIMARY filegroup 2 more files and executed DBCC SHRINKFILE (m, EMPTYFILE).
Unfortunately, file m.mdf began to grow more and more, achieved size of 17GB and DBCC ended with error.
DBCC SHRINKFILE(m, 11000) and DBCC SHRINKFILE (m) didn't help. How can i shrink this file? (for i'm sure that it's
full of some kind of junk made by incorrect DBCC termiination).
Any help and ideas are welcome.
Natalia Mirochnick
November 21, 2001 at 6:14 pm
Im surprised that didnt work. What error did you receive from the dbcc? If nothing else, use DTS to copy your objects into a "new" db that has the files in the right place.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply