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 |
|
Mmats
Starting Member
47 Posts |
 Posted - 2004-04-21 : 10:16:45
|
| I have a log backup and database backup that are too big. Should i run a dbcc shrinkfile or truncate or something else? Major newb here(not good with coding) so try to be simple. any help greatly appreciated. |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-04-21 : 11:12:56
|
| EXEC DBCC SHRINKFILE ()- Sekar |
 |
|
|
Mmats
Starting Member
47 Posts |
Posted - 2004-04-21 : 13:01:07
|
| ok i ran 'backup log mydatabase with truncate only', but the backup transaction log didnt change in size at all |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-21 : 13:02:17
|
| What is your database recovery model set to? Right click on your database in Enterprise Manager, go to properties, then to options tab. If FULL, then you need to perform regular transaction log backups. If you don't need the ability to restore to a point in time, then change it to SIMPLE. Then run DBCC SHRINKFILE.Tara |
|
|
|
nickfinity
Yak Posting Veteran
55 Posts |
Posted - 2004-04-23 : 16:34:16
|
| I had a similar question. If I look at my log file right now it's only 1280KB. My MDF file is 120MB. My backups are around 119MB. Does that sound right? I create two full backups each day and hourly transaction log backups. I could probably get by with only the two full backups as there isn't much activity in this db, but I wanted to practice my backup "skills" (haha). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-23 : 16:42:05
|
| Yes it sounds right. Your backup file size will be slightly smaller than the size of the MDF.Tara |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-04-23 : 19:47:42
|
| If you use SQL LiteSpeed, you can get backups that are much smaller than the size of the MDF file. If you need to move the Backup files from you Production server to another server, a standard ZIP or RAR of the .Bak files will do some SERIOUS shrinking on that datafile.http://www.imceda.com/Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
Backups too big