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 |
|
CanadaDBA
583 Posts |
 Posted - 2005-08-31 : 09:33:59
|
In production one of the DBs has the following sizes:Data size 770MBLog size 9.9GBWhen I transfer nightly backups to Dev environemt, the developers cannot restore on their local. Then I have to change the DBs recovery mode to Simple in EM and then run the following in QA.DBCC SHRINKFILE(Repo_Log, TRUNCATEONLY) Then backup it for developers use.Isn't it possible to backup somehow to prevent this problem?Canada DBA |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-08-31 : 09:39:13
|
| Do you need to restore to points in time in production? If not, switch your production database to simple recovery. Otherwise, enable backup jobs on a schedule for your production log file.-------Moo. :) |
 |
|
|
|
|
|
Shrink log files