Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Shrinking db/datafile

Status
Not open for further replies.
Tomi

Tomi

Programmer
Nov 19, 2001
57
US
I have a database which has a datafile of 81 gb of which 42 gb has been used and 38 gig is free.
The log file is only 18mb .How do I shrink the datafile/db so that its size would be at 42gb (to regain the free space)?

Thanks
Tomi
 
Sort by date Sort by votes
You use DBCC SHRINKFILE to remove the free space from the file. Be sure to leave enough space for the system to function correctly. I'd also check the growth settings of the data file so that it grows at the correct rate based on your applications needs.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DougNaf
  • Locked
  • Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
469
fredericofonseca
fredericofonseca
intel233
  • Locked
  • Question
Backup/Restore DB from SQL issues
Replies
2
Views
320
intel233
intel233
SamBones
  • Locked
  • Question
Moving a SQL Server DB Server
Replies
1
Views
322
SamBones
SamBones
skibum019
  • Locked
  • Question
SQL Cluster Linked Server to SQLite DB
Replies
0
Views
291
skibum019
skibum019
TheBugSlayer
  • Locked
  • Question
Shrinking database after dropping columns 1
Replies
2
Views
306
TheBugSlayer
TheBugSlayer

Part and Inventory Search

Sponsor

Back
Top