Petri IT Knowledgebase Forums
 

Petri.co.il forums Home Forums Start Page Forums Frequently Asked Questions FAQ Member List Members List
Go Back   Petri IT Knowledgebase Forums > Databases > SQL Server 2008 / R2
Reload this Page

Shrink database sql 2008

Petri.co.il is happy to award auglan the title of Most Valuable Member !!!
Register Calendar Calendar Search Petri IT Knowledgebase Forums Search Todays Posts Today's Posts Mark Forums Read

Notices

Shrink database sql 2008

Shrink database sql 2008

this thread has 1 replies and has been viewed 1495 times

Closed Thread
 
Thread Tools Search this Thread Display Modes
  #1  
Old 1st August 2012, 10:39
Ruslan Ruslan is offline
Casual
Casual
  
 Join Date: Jul 2009
  6 month star 12 month star
 Location: France
 Posts: 33
 Reputation: Ruslan is on a distinguished road (10)
Default Shrink database sql 2008
Hi,
We have a database that is very large. We have done some cleaning operations in this database and removed some old data that is not needed anymore. So i just wonder if it would be time to use the function shrink database to free up diskspace?
Can this be done without to take the database offline? Has someone done this? Should i use the shrink database only, or also use the shrink files?
/R
  #2  
Old 1st August 2012, 14:05
Ossian Ossian is offline
Administrator
  
 Join Date: Nov 2003
  6 month star 12 month star
 Location: Bonnie Scotland
 Posts: 15,134
  Send a message via Skype™ to Ossian
 Reputation: Ossian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud ofOssian has much to be proud of (1300)
Default Re: Shrink database sql 2008
Lots of information online (e.g. http://www.straightpathsql.com/archi...shrink-button/) but IMHO, unless you are running out of space on the drive, leave the db file and let natural growth use up the free space
__________________
Tom Jones
MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
PhD, MSc, FIAP, MIITT
IT Trainer / Consultant
Ossian Ltd
Scotland

** Remember to give credit where credit is due and leave reputation points where appropriate **
Closed Thread

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How Do I Shrink Hyper-V Virtual Hard Disks In Server 2008 jbell Microsoft Hyper-V Technology 3 12th April 2012 11:39
How do you automate the SQL Server 2008 Database and OLAP backup ? Albertwt SQL Server 2008 / R2 5 13th April 2011 13:33
Exchange 2007 database files, shrink size, without offline defrag.. 2003 did it. Sort AaronAnderson Exchange 2007 / 2010 / 2013 3 27th February 2010 22:01
Corrupt AD database (EBS 2008) since BSOD Kiekeboe100 SBS 2008 / 2011 3 31st May 2009 21:19
Joining New SBS 2008 Domain causes problem with MYOB database Liam SBS 2008 / 2011 2 2nd April 2009 17:13


All times are GMT +3. The time now is 07:50.

Contact Us - Petri.co.il forums - Archive - Top
Steel Blue 3.5.4 vBulletin Style ©2006 vBEnhanced
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
 

Valid XHTML 1.0!   Valid CSS!

Copyright 2005 Daniel Petri