March 29, 2006 at 10:25 am
Running low in disk space I erased a few data bases with junk, but no increase in disk availability was shown. How do I free it?
March 29, 2006 at 10:50 am
use DBCC options to shrink the database.
March 29, 2006 at 11:03 am
Sorry. Im a begginer. No idea of what is DBCC or how to get there.
(not even of what does it mean to "shrink" a data base)
March 29, 2006 at 11:22 am
Dont worry ...not a problem :-).
Check the below links.
1. http://www.sql-server-performance.com/sql_server_maintenance.asp
2. http://www.aspfaq.com/show.asp?id=2471
If this doesn't help you ,check the BOL [Books online] and search for DBCC and you will get it..
March 29, 2006 at 2:02 pm
Many thanks señor
March 30, 2006 at 3:16 am
DROP DATABASE removes the database from SL Server and deletes the files from the disk.
March 30, 2006 at 6:18 am
this tutorial might provide some helpful info on this situation
http://tutorial442.easycfm.com/
hth ~megan
March 30, 2006 at 6:57 am
The question of how to recover space on your SQL server after deleting the database is two fold. You have mentioned that the database had been deleted. It is possible to delete the database in SQL server, and leave files. When you delete the database, the server prompts you on whether you want to keep the history, and files. If you say yes then the software may leave the database, and log files on the disk. Follow your default path for your data files, and look for the appropriately named files.
FIRST... Find some way to back up files before you delete. Server backup, CD, zip, desktop, etc. Then you can delete the files that you deleted from SQL Server all ready (mdf,ldf).
Eric Dodge
Infrastructure Man.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply