Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pmccann1
Posting Yak Master
107 Posts |
 Posted - 2006-10-04 : 10:32:10
|
| how do i make a database smaller |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-04 : 10:34:56
|
| Read about DBCC SHRINKDATABASE in BOL.Also check the auto-shrink option in database options.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
pmccann1
Posting Yak Master
107 Posts |
Posted - 2006-10-04 : 10:39:35
|
| i tried that but i am still getting the error about the primary database being full |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-04 : 10:55:16
|
| Please post the scenario..your current machine configuration (OS, SQL Server edition, version etc.), backup strategy implemented, database options set, so that we can guide you more precisely.Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
pmccann1
Posting Yak Master
107 Posts |
Posted - 2006-10-04 : 11:16:35
|
| SQL7DATA FILE : AUTOMATICALLY GROW (5MB) UNRESTRICTED FILEGROWTHTRANACTION LOG : AUTOMATICALLY GROW (1MB) UNRESTRICTED FILEGROWTH |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-10-04 : 11:49:42
|
| What is the original question? Did you start with the error about PRIMARY being full? Or do you need to reclaim diskspace? |
|
|
|
pmccann1
Posting Yak Master
107 Posts |
Posted - 2006-10-04 : 11:57:47
|
| bit of both to be honest |
|
|
|
dboiler1
Starting Member
39 Posts |
Posted - 2006-10-04 : 12:11:05
|
| To shrink LDF files do the following:1. Open SQL Query Analyzer and run the following command: use dbnamebackup log dbname with truncate_only2. Go to SQL and shrink the db using defaults.Works great.Dave |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
reduce size of db