No announcements
Found 2695402 threads
-
1 VotesDBCC ShrinkFile Not releasing Space
Try shrink the data file and the log file seperately FOR THE LOG FILE run select name, ...Answered | 14 Replies | 25696 Views | Created by Ben_in_Omaha - Wednesday, April 4, 2012 4:14 PM | Last reply by SQLWork - Friday, April 6, 2012 7:09 PM
-
0 Votes
DBCC SHRINKFILE Does Not Work
Actually I am not presenting this as a solution, but as a clue to help diagnose the real problem that it doesn't work under normal situation.Answered | 16 Replies | 19148 Views | Created by thecoleman - Tuesday, December 30, 2008 9:21 PM | Last reply by Amir Hussein Samiani, MCSD, MCPD - Thursday, November 1, 2012 12:12 AM -
2 Votes
DBCC SHRINKFILE on remote db
By default it's 600 seconds, which is often not long enough to complete a shrink, so you can set it to 0 before issuing the shrink command, then back to 600 ...Answered | 2 Replies | 2552 Views | Created by Y a h y a - Tuesday, April 9, 2013 7:10 PM | Last reply by Andrew Bainbridge - Tuesday, April 9, 2013 8:26 PM -
0 Votes
dbcc shrinkfile slows to a crawl
See Paul Randals blog:- http://www.sqlskills.com/blogs/paul/why-lob-data-makes-shrink-run-slooooowly-t-sql-tuesday-006/ In ...Answered | 15 Replies | 16697 Views | Created by Squeenid - Tuesday, March 30, 2010 4:58 AM | Last reply by SteveFrancis - Tuesday, March 7, 2017 1:02 PM -
0 Votes
DBCC SHRINKFILE - running multiple times to shrink?
One simple way to free all unused space by running the following statement: USE [db_name] GO DBCC SHRINKFILE ...Answered | 5 Replies | 7957 Views | Created by Dragon Curve - Tuesday, March 29, 2011 6:45 AM | Last reply by Alex Feng (SQL) - Wednesday, March 30, 2011 8:51 AM -
6 Votes
DBCC SHRINKFILE takes too long to run, LOB doesn't seem to be the problem
I bet that's what caused the performance problem...Answered | 13 Replies | 5241 Views | Created by EitanBlumin - Wednesday, October 22, 2014 12:07 PM | Last reply by Erland Sommarskog - Monday, October 27, 2014 3:55 PM -
1 Votes
DBCC SHRINKFILE WITH EMPTYFILE OPTION
If I use the DBCC SHRINKFILE WITH EMPTYFILE OPTION, whether the data will be emptied and moved to the files on the SAME FILE GROUP ?Answered | 2 Replies | 5843 Views | Created by skan2dan - Thursday, April 11, 2013 12:22 PM | Last reply by Kyle J. Anderson - Thursday, June 13, 2013 2:59 AM -
0 Votes
DBCC SHRINKFILE fails with a confusing error
If their is no alternative then you can change the database into single user mode then run - dbcc shrinkfile(1) http://uk.linkedin.com/in/ramjadduAnswered | 21 Replies | 13454 Views | Created by Mirko Hainke - Tuesday, April 19, 2011 5:29 PM | Last reply by Mirko Hainke - Tuesday, May 3, 2011 9:29 AM -
0 Votes
DBCC SHRINKFILE Failing
It could also be that DBCC SHRINKFILE loses track somewhere for whatever reason and thinks that it should look at this uninitialised page.Answered | 15 Replies | 1313 Views | Created by Joe Cesare - Thursday, January 14, 2016 4:23 PM | Last reply by Erland Sommarskog - Friday, January 15, 2016 10:40 PM -
3 Votes
DBCC Shrinkfile Error when file DOES exist
Hi, I would be interested to see what sys.database_files says when you next run into this problem.Answered | 9 Replies | 14923 Views | Created by icowden - Wednesday, June 20, 2012 4:12 PM | Last reply by nice guy from san jose heart center asking a serve - Thursday, October 8, 2015 8:33 PM -
0 Votes
DBCC SHRINKFILE ('LogicalFileName',5) showing error
Probably you required too much data to be moved towards the begining to free up the space.Answered | 5 Replies | 12635 Views | Created by Bobby_79 - Tuesday, December 14, 2010 4:54 AM | Last reply by Uri Dimant - Tuesday, December 14, 2010 10:45 AM -
0 Votes
DBCC SHRINKFILE parameter - target_size
Hi, from the Transact-SQL Reference for DBCC SHRINKFILE (http://msdn.microsoft.com/en-us/library/aa258824(SQL.80).aspx), there's a parameter call target_size.Answered | 1 Replies | 7063 Views | Created by Guo Ming Li - Thursday, March 4, 2010 9:40 PM | Last reply by Lekss - Thursday, March 4, 2010 10:12 PM -
1 Votes
DBCC SHRINKFILE in SQL Server 2008 R2
DBCC SHRINKFILE (N'ReportServer' , 500) Regards, Bijay Maurya follow and understand what Olaf's provided ...Answered | 4 Replies | 1509 Views | Created by Bijay Maurya - Tuesday, September 20, 2016 6:38 AM | Last reply by Bijay Maurya - Wednesday, September 21, 2016 5:11 PM -
0 Votes
Recovery option vs DBCC Shrinkfile
>However, in the Recovery option if I switch it to simple and then shrink the database it will shrink Shrinking of database is most evil operation you can do in SQL Server ...Answered | 1 Replies | 1114 Views | Created by transtar - Tuesday, April 22, 2014 9:18 PM | Last reply by Shanky_621 - Tuesday, April 22, 2014 9:38 PM -
0 Votes
DBCC Shrinkfile
In the case above, it completely reversed the order of the clustered index, taking it from perfectly defragmented to perfectly fragmented.Answered | 3 Replies | 1294 Views | Created by Karunakar Kotha - Tuesday, March 17, 2015 11:17 PM | Last reply by Uri Dimant - Wednesday, March 18, 2015 6:44 AM -
0 Votes
dbcc indexdefrag taking a long time
But, as long as your users aren't complaining about the performance during this time, I don't think it will be a problem.Answered | 4 Replies | 5808 Views | Created by D00linDalton - Tuesday, May 3, 2011 10:53 PM | Last reply by Alex Feng (SQL) - Friday, May 6, 2011 1:38 AM -
0 Votes
any issues using DBCC SHRINKFILE on Log files
If you really have to shrink the log file, you can certainly use DBCC SHRINKFILE.Answered | 2 Replies | 5112 Views | Created by km6589 - Thursday, January 8, 2009 10:21 PM | Last reply by Bodo Michael Danitz - Tuesday, January 13, 2009 2:33 AM -
0 Votes
DBCC SHRINKFILE with NOTRUNCATE has any performance impact in log shipping?
Hi, DBCC SHRINKFILE could be used on a log shipped database.Answered | 5 Replies | 2326 Views | Created by Kalyan Chakravarthi (MCP) - Monday, February 10, 2014 11:53 AM | Last reply by Kalyan Chakravarthi (MCP) - Tuesday, February 11, 2014 10:29 AM -
0 Votes
Downside of Regular DBCC SHRINKFILE (compact) and DBCC CHECKDB (repair)
After shrinking, it seems that rebuilding indexes is necessary.Answered | 2 Replies | 6530 Views | Created by walleye5hunter - Tuesday, November 16, 2010 7:13 PM | Last reply by Maher Riahi - Tuesday, November 16, 2010 7:29 PM -
0 Votes
DBCC shrinkfile for Data file while DB is online
If I will not shrink the data files (DBCC shrinkfile) I'll need to buy a new storage.Answered | 6 Replies | 4508 Views | Created by Gal1 - Thursday, May 8, 2014 10:55 AM | Last reply by Erland Sommarskog - Friday, May 9, 2014 9:45 PM - Items 1 to 20 of 2695402 Next ›
No announcements
