The Multifunctioning DBA:

Shrink

May 21, 2012 4:25 PM

Strange Error when shrinking db file

Posted by: Colin Smith

Shrink

So I almost never say that you should shrink but sometimes you have to. I ran into such a situation recently and I continued to get this error when changing the initial size of the file. File ID 2 of database ID 13 cannot be shrunk as it is either being shrunk by another process or is...



			
				
								
				 

				

				   

				 0 Comments
				   

				  RSS Feed
				   

				  Email a friend





				
			
			 
			
					
	

	About This Blog
	
	
	
	This blog is written by an IT professional with over 5 years experience in Windows Server Administration. New to the DBA world, Colin Smith is now involved with Microsoft SQL Server, Oracle and Sybase databases. This blog covers database administration, Windows administration, Scripting and more.	
		
			>> READ MORE ABOUT THIS BLOG
		
		
	




	
	
	
	
	
	

	
	
	
	
	
	



		
			Browse This Blog’s Tags
			
			
				
					
					70-443, Active Directory, AD, AD Administration, AD Managment, Administration, Android, Audit, Certification, Database, Database Administration, DBA, DR, Education, Exchange, Exchange Scripting, Free Training, Fun, Games, Help, Holiday, Job, Microsoft Windows, Monitoring, MS SQL, MSSQL, MS SQL Admin, MSSQL Administration, MS SQL Server, MSSQL Server, Oracle, PASS, PASS Summit, Phone, Powershell, Rant, Scripting, Speaking, SQL, SQL Admin, SQL Administration, SQL Saturday, SQL Saturday 131, SQL Server, Sybase, T-SQL, Training, Upgrade, Windows, Windows Administration					
				
			
		



		
		
			Archives
			
			
				
						February 2013
	November 2012
	October 2012
	September 2012
	August 2012
	June 2012
	May 2012
	April 2012
	March 2012
	February 2012
	January 2012
	November 2011
	October 2011
	September 2011
	August 2011
	July 2011
	June 2011
	May 2011
	April 2011
	March 2011
	February 2011
	January 2011
	December 2010
	November 2010
	October 2010
	August 2010
	July 2010
	June 2010
	May 2010
	April 2010
	March 2010
	February 2010
	January 2010
	October 2009
	September 2009
	August 2009
	July 2009
	June 2009
	May 2009
	April 2009
	March 2009
	February 2009
	January 2009
	December 2008
	November 2008
	October 2008
				
			
		
		
			
		
			Blog Roll
			
			
				
				ITKE Community Blog
SQL Server with Mr. Denny
VBScript for System Administrators
The musings of an IT Consultant
Security Corner
Quality Assurance and Project Management
Vista Enterprise Desktop
IT Career JumpStart
Virtualization Pro
The Network Hub: A SearchNetworking.com blog
				
			
		
		
		

	
		Help
		Subscribe to Alerts
	

	

	

					
				
				
				
			

			RSS feed of The Multifunctioning DBA
			

	



hidden modal window



			


	
	



		
		
			
			Community Blog | 
            About Us | 
			Contact Us | 
            FAQ | 
			Terms of Use |  
			DMCA Policy
			


			TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organization's IT projects - with its network of technology-specific Web sites, events and magazines.
			

			All Rights Reserved, Copyright 1999-2013, TechTarget | Read our Privacy Policy
			

			Questions and Answers Index 1 |
			Questions and Answers Index 2 |
			IT Topics Index 1 |
			IT Topics Index 2  |
			Blogs Index |
			Blogs Tags